Supabase MCP Server

What it does

This MCP server provides a secure bridge between AI assistants and Supabase projects. It allows developers to perform complex database operations, manage their project via the Supabase Management API, and administer users using the Auth Admin SDK, all while maintaining a strict safety system to prevent accidental data loss.

Tools

• execute_postgresql: Run SQL statements against your database with risk assessment.
• get_table_schema: Retrieve detailed table structure, including columns and relationships.
• send_management_api_request: Interact with the Supabase Management API for project-level changes.
• call_auth_admin_method: Invoke Auth Admin SDK methods to create or manage users.
• retrieve_logs: Access logs from various Supabase services (Postgres, Auth, Storage, etc.).
• live_dangerously: Toggle between safe (read-only) and unsafe (write/destructive) modes.

Installation

Install via pipx:

pipx install supabase-mcp-server

Configure your claude_desktop_config.json:

{
  "mcpServers": {
    "supabase": {
      "command": "/full/path/to/supabase-mcp-server",
      "env": {
        "QUERY_API_KEY": "your-api-key",
        "SUPABASE_PROJECT_REF": "your-project-ref",
        "SUPABASE_DB_PASSWORD": "your-db-password",
        "SUPABASE_REGION": "us-east-1"
      }
    }
  }
}

Supported hosts

Confirmed for Claude Desktop, Cursor, Windsurf, and Cline.