Query | MCP server for Supabase
@alexander-zuev
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.
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.
Frequently asked questions
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](https://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.
Basic information
More Cloud & Infrastructure MCP servers
container-use
aluzzardiDevelopment environments for coding agents. Enable multiple agents to work safely and independently with your preferred stack.
AWS MCP
RafalWilinskiTalk with your AWS using Claude. Model Context Protocol (MCP) server for AWS. Better Amazon Q alternative.
Muumuu Domain MCP Server
pepaboThe official MCP server for Muumuu Domain by GMO Pepabo, Inc — the first remote MCP server in the Japanese domain registrar industry. Search and register domains, manage owned domains and contracts, and configure DNS rec
tfmcp: Terraform Model Context Protocol Tool
nwiizo🌍 Terraform Model Context Protocol (MCP) Tool - An experimental CLI tool that enables AI assistants to manage and operate Terraform environments. Supports reading Terraform configurations, analyzing plans, applying configurations, and managing state with Claude Desktop integrati
Supabase MCP Server
supabase-communityConnect Supabase to your AI assistants
Comments