MCP.so
Sign In

Query | MCP server for Supabase

@alexander-zuev

Repository

About Query | MCP server for Supabase

Query MCP enables end-to-end management of Supabase via chat interface: read & write query executions, management API support, automatic migration versioning, access to logs and much more.

#cursor#windsurf#supabase#model-context-protocol

Basic information

Category

Cloud & Infrastructure

License

Apache-2.0

Runtime

python

Transports

stdio

Publisher

alexander-zuev

Config

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

{
  "mcpServers": {
    "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 server for Supabase?

Query | MCP server for Supabase is an open‑source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use the Auth Admin SDK — all with built‑in safety controls. It is designed for developers using Supabase with MCP‑compatible clients like Cursor, Windsurf, and Cline. Note that this server is no longer actively maintained; the official Supabase MCP server is recommended instead.

How to use Query | MCP server for Supabase?

Install via a Python package manager: pipx install supabase-mcp-server or uv pip install supabase-mcp-server. Then configure environment variables (e.g., QUERY_API_KEY, SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD) either in your MCP client settings, a global config file under ~/.config/supabase-mcp/.env (macOS/Linux), or %APPDATA%\supabase-mcp\.env (Windows). Start the server in your MCP client using the command supabase-mcp-server.

Key features of Query | MCP server for Supabase

  • Compatible with Cursor, Windsurf, Cline, and other stdio MCP clients
  • Read‑only and read‑write modes for SQL execution
  • Runtime SQL validation with risk‑level assessment
  • Three‑tier safety system: safe, write, and destructive
  • Robust transaction handling for direct and pooled connections
  • Automatic versioning of database schema changes
  • Manage Supabase projects via Management API and Auth Admin SDK

Use cases of Query | MCP server for Supabase

  • Running exploratory SQL queries from an IDE with safety guards
  • Performing schema migrations with automatic change versioning
  • Managing Supabase users and projects through the Auth Admin SDK
  • Interacting with remote Supabase databases via a transaction pooler
  • Prototyping MCP integrations for Cursor and Windsurf

FAQ from Query | MCP server for Supabase

Is this server still maintained?

No. Since Supabase released their own official MCP server, this project is no longer actively maintained. The official server is feature‑rich and will receive future updates.

What are the runtime requirements?

Python 3.12+ is required. PostgreSQL installation is no longer needed for the server itself, but a local PostgreSQL instance is still required if running a local Supabase stack.

How do I obtain the required API key?

An API key from thequery.dev is required (free). Set it as the QUERY_API_KEY environment variable.

Which Supabase configurations are supported?

Only official Supabase.com hosted projects and local development are supported. Self‑hosted Supabase, custom connection strings, and session pooling are not supported.

Which MCP clients have been tested with this server?

Cursor, Windsurf, Cline, and Claude Desktop (all via stdio protocol). Smithery.ai can also be used for installation.

Comments

More Cloud & Infrastructure MCP servers

Mcp K8s Go

strowk

MCP server connecting to Kubernetes

383

Lambda MCP Server Demo (Streamable HTTP)

mikegc-aws

Creates a simple MCP tool server with "streaming" HTTP.

234

AWS Model Context Protocol (MCP) Server

alexei-led

A lightweight service that enables AI assistants to execute AWS CLI commands (in safe containerized environment) through the Model Context Protocol (MCP). Bridges Claude, Cursor, and other MCP-aware AI tools with AWS CLI for enhanced cloud infrastructure management.

184

container-use

dagger

Development environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.

3.9K

Supabase MCP Server

coleam00

Supabase MCP server created in Python.

195