MCP.so
Sign In

Query MCP (Supabase MCP Server)

@MCP-Mirror

About Query MCP (Supabase MCP Server)

Mirror of

Basic information

Category

Cloud & Infrastructure

License

Apache-2.0 license

Runtime

python

Transports

stdio

Publisher

MCP-Mirror

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "medieage_supabase-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "supabase-mcp-server"
      ]
    }
  }
}

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is Query MCP (Supabase MCP Server)?

Query MCP (Supabase MCP Server) is an MCP server that enables your favorite IDE to safely execute SQL queries, manage your Supabase database end-to-end, access the Supabase Management API, and handle user authentication with built-in safety controls.

How to use Query MCP (Supabase MCP Server)?

Install via pipx or uv with pipx install supabase-mcp-server (recommended) or uv pip install supabase-mcp-server. Configure required environment variables (SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD, SUPABASE_REGION) in your MCP client settings, a global config file, or a local .env file. Then connect your MCP client (Cursor, Windsurf, Cline, etc.) to the server.

Key features of Query MCP (Supabase MCP Server)

  • SQL execution with read-only and read-write modes
  • Runtime SQL validation with risk level assessment
  • Three-tier safety system: safe, write, destructive
  • Robust transaction handling for direct/pooled connections
  • Automatic versioning of database schema changes
  • Supabase Management API and Auth Admin SDK integration

Use cases of Query MCP (Supabase MCP Server)

  • Safely run SQL queries from your IDE with risk controls
  • Manage Supabase projects and users without leaving your editor
  • Automate schema migrations with automatic versioning
  • Handle user authentication and admin tasks via Auth Admin SDK

FAQ from Query MCP (Supabase MCP Server)

What does Query MCP (Supabase MCP Server) do?

It enables your favorite IDE to safely execute SQL queries, manage your Supabase database end-to-end, access the Management API, and handle user authentication with built-in safety controls.

Which MCP clients are supported?

It is compatible with Cursor, Windsurf, Cline, and other MCP clients that support the stdio protocol.

What are the required configuration variables?

You must set SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD, and SUPABASE_REGION (default us-east-1). Optionally set SUPABASE_ACCESS_TOKEN and SUPABASE_SERVICE_ROLE_KEY.

Does the server support self-hosted Supabase instances?

No, it only supports official Supabase.com hosted projects and local development. Custom connection strings are not supported.

What Python version is required?

Python 3.12 or later is required. PostgreSQL installation is no longer needed for the server itself.

Comments

More Cloud & Infrastructure MCP servers