Query MCP (Supabase MCP Server)

@MCP-Mirror

About Query MCP (Supabase MCP Server)

Mirror of

#supabase #mcp-server #database-management

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.

Frequently asked questions

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

Basic information

More Cloud & Infrastructure MCP servers

Azure DevOps MCP Server

Tiberriver256

An MCP server for Azure DevOps

377

MCP Gateway

mcp-ecosystem

🧩 MCP Gateway - A lightweight gateway service that instantly transforms existing MCP Servers and APIs into MCP servers with zero code changes. Features Docker deployment and management UI, requiring no infrastructure modifications.

2.2K