概览
What is Supabase MCP Server?
A feature-rich MCP server that enables any MCP client (Cursor, Windsurf, Claude Desktop, Cline, and others) to safely interact with Supabase databases. It provides tools for database management, SQL query execution, Supabase Management API access, and user authentication with built-in safety controls.
How to use Supabase MCP Server?
Install the server via pipx install supabase-mcp-server or uv pip install supabase-mcp-server. Then configure environment variables (e.g., SUPABASE_PROJECT_REF, SUPABASE_DB_PASSWORD, SUPABASE_ACCESS_TOKEN) in your MCP client or a global config file. Finally, add the server to your MCP client using the command supabase-mcp-server.
Key features of Supabase MCP Server
- Compatible with Cursor, Windsurf, Cline, and other MCP clients using
stdio - Read-only and read-write modes for SQL execution
- Runtime SQL validation with risk level assessment
- Three-tier safety system: safe, write, and destructive
- Automatic versioning of database schema changes
- Manage Supabase projects via Management API
Use cases of Supabase MCP Server
- Safely execute SQL queries from your IDE with built-in guardrails
- Manage database schemas and track changes automatically
- Administer Supabase projects and user authentication via API
- Develop locally with a Supabase instance and then apply changes to production
FAQ from Supabase MCP Server
Does the server support self-hosted Supabase?
No. The server supports only official Supabase.com hosted projects and local development (using the Supabase CLI on 127.0.0.1:54322).
What Python version is required?
Python 3.12 or higher is required.
What connection types are supported for the database?
Only transaction pooling is supported. Session pooling and custom connection strings are not supported.
Can I use Management API and Auth Admin with a local Supabase instance?
No. Management API and Auth Admin SDK features work only with remote Supabase projects, not local development.
How do I find my Supabase project reference?
Your project reference is in your Supabase project URL: https://supabase.com/dashboard/project/<project-ref>.
