Bio Preferred MCP Server

A Model Context Protocol (MCP) server that provides AI agents with access to Bio Preferred product data from a PostgreSQL database.

🚀 Quick Start

1. Install Dependencies

pip install -r requirements.txt

2. Start the MCP Server

python run_server_simple.py

3. Configure Claude Desktop

Add this configuration to Claude Desktop → Settings → Developer → MCP:

{
  "mcpServers": {
    "bio-preferred": {
      "command": "/Users/ginugeorge/miniconda3/bin/python",
      "args": ["/Users/ginugeorge/Report_mcp/run_server_simple.py"],
      "name": "Bio Preferred Database",
      "description": "Access to Bio Preferred product database with 9 products and 5 categories"
    }
  }
}

4. Test with Claude

Ask Claude: "What products are in the Bio Preferred database?"

Related MCP server: PostgreSQL MCP Server

📊 Available Data

• 9 Products: Biodegradable Soap, Plant-Based Degreaser, Soy-Based Paint, etc.

• 5 Categories: Cleaning Agents, Lubricants, Paints & Coatings, Construction Materials, Office Supplies

• 6 Tables: products, product_categories, category_product_map, acquisition, awards, contract_bio_entry

• 4 Acquisition Records: Contract values and funding agencies

🛠️ MCP Tools

The server provides 9 tools for AI agents:

Product & Category Tools

1. search_products - Search for products by name

2. list_categories - Show all product categories

Contract Management Tools

3. list_contract_information - List all contract information including acquisition details, contract values, and funding agencies

4. list_contracts_with_reports - List contracts that have submitted reports with submission details and report counts

5. list_contracts_without_reports - List contracts that have NOT submitted reports yet

Database Tools

6. list_tables - List all database tables

7. get_table_schema - Explore table structure

8. execute_custom_query - Execute custom SQL queries (read-only)

📁 Project Structure

Report_mcp/
├── 🚀 run_server_simple.py      # Main MCP server (Claude-compatible)
├── 🔧 database.py               # Database connection and utilities
├── ⚙️  config.py                # Configuration management
├── 🏃 run_server.py             # Alternative server implementation
├── 🚀 start_for_chatgpt.py      # Easy startup script
├── 📦 requirements.txt          # Python dependencies
├── 📁 tests/                    # Test suite
│   ├── test_all.py             # Run all tests
│   ├── test_database_connection.py
│   ├── test_local_mcp.py
│   ├── test_mcp_tools.py
│   └── test_chatgpt_integration.py
└── 📁 docs/                     # Documentation
    ├── CHATGPT_INTEGRATION.md
    ├── CHATGPT_SETUP_GUIDE.md
    ├── CONFIGURATION.md
    ├── TESTING.md
    └── mcp_config.json

🧪 Testing

Run All Tests

python tests/test_all.py

Individual Tests

# Test database connection
python tests/test_database_connection.py

# Test MCP server locally
python tests/test_local_mcp.py

# Test ChatGPT integration
python tests/test_chatgpt_integration.py

⚙️ Configuration

The server is pre-configured with:

• Database: biopref (localhost:5432)

• User: ginugeorge

• Schema: public

• Connection Timeout: 10 seconds

• Query Timeout: 30 seconds

No environment variables or additional configuration needed!

🔧 Database Schema

Products Table

• id - UUID product identifier

• name - Product name (e.g., "Biodegradable Soap")

Categories Table

• id - UUID category identifier

• name - Category name (e.g., "Cleaning Agents")

Additional Tables

• category_product_map - Links products to categories

• acquisition - Contract values and funding agencies

• awards - Award information

• contract_bio_entry - Contract bio entries

💬 Example Claude Conversations

• "Find all soap products in the Bio Preferred database"

• "What categories are available?"

• "Show me the structure of the products table"

• "How many products are in each category?"

🚨 Troubleshooting

Common Issues

1. "Database connection failed"

   • Ensure PostgreSQL is running: psql -l

   • Check the biopref database exists

2. "MCP server not found"

   • Verify the Python path in Claude Desktop configuration

   • Test locally: python tests/test_local_mcp.py

3. "No tools available"

   • Check server logs in Claude Desktop

   • Run tests to verify functionality

Debug Commands

# Test database connection
python tests/test_database_connection.py

# Test MCP server
python tests/test_local_mcp.py

# Check server status
ps aux | grep python

📚 Documentation

• Claude Desktop Setup - Complete setup guide

• Configuration Details - Configuration reference

• Testing Guide - Comprehensive testing instructions

• Integration Guide - ChatGPT integration details

🎯 Status

✅ Production Ready - All tests passing, optimized for Claude Desktop

Your Bio Preferred MCP server is ready to provide AI agents with access to real product data! 🎉