Yazdani-Supabase-MCP-Server
About
A Supabase PostgreSQL MCP server with Claude 3.7 Sonnet integration for natural language to SQL conversion
Details
- Author
- byazdani9
- Downloads
- 175
- Categories
- Cloud Service
Jump to
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Yazdani-Supabase-MCP-ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install dependencies with pip install -r requirements.txt, create a .env file with Supabase and Anthropic credentials, then run the server using python run_server.py (live) or USE_MOCK_DB=true python run_server.py (mock). For natural language testing, use run_nl_test.bat or run http_server.py and `
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"yazdani-supabase-mcp-server": {
"yazdani-supabase-mcp-server": {
"command": "python",
"args": [
"run_server.py"
]
}
}
}
}McpServers
{
"yazdani-supabase-mcp-server": {
"command": "python",
"args": [
"run_server.py"
]
}
}Yazdani-Supabase-MCP-Server
An MCP server that integrates with Supabase PostgreSQL and uses Claude 3.7 for natural language query processing, designed for integration with React Native PaveApp.
Features
- Schema Inspection: View database schemas, tables, columns, and relationships
- SQL Execution: Run SQL queries with safety controls
- Migration Management: View and manage database migrations
- Natural Language Processing: Convert natural language to SQL using Claude 3.7
- Safety Controls: Protection against destructive operations
- Mock Database Mode: Support for development and testing without a live database connection
- Auto-Fallback Mechanism: Gracefully falls back to mock data when database connection fails
- Session Pooler Support: Uses Supabase Session pooler for stable connections
Installation
Prerequisites
- Python 3.8 or higher
- Access to a Supabase PostgreSQL database (optional with mock mode)
- Anthropic API key (for Claude integration)
Setup
1. Clone the repository:
git clone <repository-url>
cd Yazdani-supabase-mcp-server
2. Install dependencies:
pip install -r requirements.txt
3. Create a .env file with your credentials:
# Supabase credentials
SUPABASE_PROJECT_REF=your_project_ref
SUPABASE_URL=https://your_project_ref.supabase.co
SUPABASE_DB_PASSWORD=your_db_password
SUPABASE_REGION=your_region
SUPABASE_ACCESS_TOKEN=your_access_token
SUPABASE_SERVICE_ROLE_KEY=your_service_role_key
# Database connection
POSTGRES_HOST=db.your_project_ref.supabase.co
POSTGRES_PORT=5432
POSTGRES_DB=postgres
POSTGRES_USER=postgres
SUPABASE_POOLER_HOST=aws-0-ca-central-1.pooler.supabase.com
# Claude API
ANTHROPIC_API_KEY=your_anthropic_api_key
# Optional: for mock database mode
# USE_MOCK_DB=true
Usage
Running the Server with Live Database
For normal operation with a Supabase database connection:
python run_server.py
Running the Server with Mock Database
For development or testing without a live database connection:
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
