Databases - official Supabase server
Supabase MCP server
Hosted MCP server that lets an agent manage Supabase projects: list tables, run SQL and migrations, read logs and advisors, deploy Edge Functions, manage branches and search Supabase docs, with optional project scoping and read-only mode. Supabase hosts it at https://mcp.supabase.com/mcp, or you can run @supabase/mcp-server-supabase (npm) locally with OAuth or API key auth.
Last verified 15 tools4 sources
Install
Claude Code
About Claude Codeclaude mcp add --scope project --transport http supabase "https://mcp.supabase.com/mcp?features=docs%2Caccount%2Cdatabase%2Cdebugging%2Cdevelopment%2Cfunctions%2Cbranching"Generic
{
"mcpServers": {
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}
}Tools
list_tables- List all tables in the database.
list_extensions- List available/installed Postgres extensions.
list_migrations- List database migrations.
apply_migration- Apply a database migration.
execute_sql- Execute SQL queries.
query_logs- Run a read-only SQL query against project logs.
get_advisors- Get security and performance advisors.
get_project_url- Get the API URL for a project.
get_publishable_keys- Get publishable and legacy anon API keys for a project.
generate_typescript_types- Generate TypeScript types from schema.
list_edge_functions- List all Edge Functions.
deploy_edge_function- Deploy an Edge Function.
list_projects- List project details (account management group).
search_docs- Search Supabase documentation.
create_branch- Branch management (experimental, requires a paid plan).
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Default auth is OAuth with dynamic client registration (no personal access token needed); for CI, a scoped personal access token can be sent as an Authorization: Bearer header, and a manual OAuth app is supported for clients without dynamic registration.
- URL parameters: read_only=true, project_ref=<id> (disables account tools), features=<groups>, skip_elicitations=<tools>.
- Feature groups: docs, account, database, debugging, development, functions, branching (experimental, paid plan), storage (off by default).
- Supabase CLI local development exposes the server at
http://localhost:54321/mcp, and self-hosted Supabase offers a limited tool subset without OAuth 2.1. - The docs page uses an interactive configurator; only the Claude Code snippet was rendered statically, so other client snippets are left null.
- Supabase warns about prompt-injection risk and advises against giving the server to end users.
More MCP servers for databases
- Supabase
Supabase Postgrest MCP server
Local stdio MCP server that lets an LLM perform CRUD operations against a Supabase project or any PostgREST server through its REST API, and convert SQL to PostgREST syntax.
Transport: stdioAuth: API key - AirtableStatus: GA
Airtable MCP server
Airtable's official hosted MCP server lets AI tools list and create bases, change table and field schema, read and write records, build interfaces, submit forms and draft automations, all within the user's existing permissions.
Transport: Streamable HTTPAuth: OAuth or API key - Chroma
Chroma MCP server
Self-hosted MCP server that lets agents create and manage Chroma collections and add, query, update and delete documents. It supports vector search, full-text search and metadata filtering against ephemeral, persistent, self-hosted HTTP or Chroma Cloud clients.
Transport: stdioAuth: Other - ClickHouseStatus: Beta
ClickHouse Cloud remote MCP server
A fully managed remote MCP endpoint for ClickHouse Cloud services that lets agents list databases and tables, run read-only SELECT queries, and inspect organizations, services, backups, ClickPipes and billing. All 13 tools are read-only.
Transport: Streamable HTTPAuth: OAuth or API key - ClickHouse
ClickHouse MCP server
Open-source MCP server from ClickHouse that lets AI assistants list databases and tables and run SQL against any ClickHouse instance, self-hosted or Cloud. It also has an optional chDB embedded engine. It runs locally over stdio by default, and can also serve Streamable HTTP.
Transport: stdio, Streamable HTTP, SSEAuth: Other - CockroachDBStatus: GA
CockroachDB Cloud MCP server
Managed MCP server built into CockroachDB Cloud that lets AI tools list clusters, explore live schemas and run SQL against clusters in a CockroachDB Cloud organization. Connections can cover every cluster the user or service account can access, or be scoped to one cluster with an mcp-cluster-id header.
Transport: Streamable HTTPAuth: OAuth or API key
Related reading
- Self-Improving Applications Are Now Cheaper Than Hiring: The Claude Code and Codex Closed LoopSelf-improving applications with Claude Code and Codex: the loop from user feedback to GitHub issue to reviewed PR, paying per closed issue, not per token.
- Convex vs Supabase for AI AppsConvex and Supabase both work for AI-powered apps. Here is when to use each, based on building production apps with both.
- Zoer: Full-Stack App in 5 Minutes with Vibe CodingZoer is a text-to-app platform that generates the database, Next.js app and deployment from one prompt. How it works and how it compares to Lovable and Bolt.
- Lovable: Building Full-Stack Web Apps with AI and SupabaseLovable builds full-stack web apps from prompts with native Supabase auth, database and migrations. See a course platform build, its error handling and limits.
- What's New in Mastra (Late 2026): Harness, AgentController GA, Eval Gates and MCP 2.xMastra in late 2026: goals, schedules, signals, AgentController GA, eval gates and MCP 2.x, with type-checked TypeScript examples and honest tradeoffs.
- MCP vs A2A vs Function Calling: Which Layer Does What in 2026MCP vs A2A vs function calling compared on the 2026-07-28 MCP spec and A2A 1.0: what each protocol does, where they overlap, and how to stack them.
FAQ
What does the Supabase MCP server do?
Hosted MCP server that lets an agent manage Supabase projects: list tables, run SQL and migrations, read logs and advisors, deploy Edge Functions, manage branches and search Supabase docs, with optional project scoping and read-only mode. The vendor documents 15 tools, including list_tables, list_extensions, list_migrations and apply_migration.
How do I add the Supabase MCP server to Claude Code?
Run claude mcp add --scope project --transport http supabase "https://mcp.supabase.com/mcp?features=docs%2Caccount%2Cdatabase%2Cdebugging%2Cdevelopment%2Cfunctions%2Cbranching", copied from Supabase's docs. This page also has snippets for Generic.
Does the Supabase MCP server need authentication?
Yes, OAuth or API key. Transport: Streamable HTTP. Status: GA, last checked October 17, 2026.
Sources
Last verified against 4 Supabase pages, then re-checked independently.
- supabase.comhttps://supabase.com/docs/guides/ai-tools/mcp
- raw.githubusercontent.comhttps://raw.githubusercontent.com/supabase/mcp/main/README.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/supabase/mcp/main/LICENSE
- registry.npmjs.orghttps://registry.npmjs.org/@supabase/mcp-server-supabase
Newsletter
New MCP servers, the week they ship
One email per week. New official MCP servers, the coding tools that support them and how developers wire them up.