Alexander Zuev Supabase MCP Server

🚀 Supabase MCP Server

Supabase MCP Server: A bridge connecting Supabase and development tools

✨ Features

• Python Method Support: Offers the same functionality as the native Python SDK.
• SQL Query Validation: Enhances the security and accuracy of SQL queries.
• Local Development Support: Integrates with the Supabase CLI to simplify the development process.
• Multi - platform Compatibility: Compatible with macOS, Windows, and Linux systems.

📦 Prerequisites

Mac OS

1. Install PostgreSQL:

   brew install postgresql
   

2. Start the PostgreSQL service:

   brew services start postgresql
   

Windows OS

1. Download and install PostgreSQL: PostgreSQL Download Page
2. After installation, start the PostgreSQL service.

📦 Installation

1. Clone the project repository:

   git clone https://github.com/your-repository.git
   cd your-repository
   

2. Install dependencies using the uv package manager:

   uv sync
   

💻 Usage Examples

Starting the Development Server

1. Start the development server:

   mcp dev main.py
   

2. Simultaneously, start the local Supabase instance:

   supabase start
   

Configuration Instructions

Example of mcp_config.json:

{
  "mcpServers": {
    "supabase": {
      "command": "/Users/az/.local/bin/uv",
      "args": [
        "--directory",
        "/Users/username/cursor/supabase-mcp-server",
        "run",
        "main.py"
      ],
      "env": {
        "SUPABASE_PROJECT_REF": "127.0.0.1:54322",
        "SUPABASE_DB_PASSWORD": "postgres"
      }
    }
  }
}

🔮 Future Improvement Plans

• Expand Python Support: Add more methods and features identical to the native Python SDK.
• Enhance Query Validation: Optimize SQL query syntax checking and error prompts.
• Improve Documentation: Provide more detailed usage guides and technical documentation.