Query | MCP server for Supabase

Name: Query | MCP server for Supabase
Author: alexander-zuev

@alexander-zuev

关于 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

基本信息

分类

云与基础设施

许可证

Apache-2.0

运行时

python

传输方式

stdio

发布者

alexander-zuev

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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.

云与基础设施分类下的更多 MCP 服务器

Azure DevOps MCP Server

Tiberriver256

An MCP server for Azure DevOps

377

Lambda MCP Server Demo (Streamable HTTP)

mikegc-aws

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

234

K8s MCP Server

alexei-led

K8s-mcp-server is a Model Context Protocol (MCP) server that enables AI assistants like Claude to securely execute Kubernetes commands. It provides a bridge between language models and essential Kubernetes CLI tools including kubectl, helm, istioctl, and argocd, allowing AI syste

212