Databases - official Supabase server
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. It runs locally from @supabase/mcp-server-postgrest (npm) with API key auth.
Last verified 2 tools3 sources
Install
Generic
{
"mcpServers": {
"todos": {
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-postgrest@latest",
"--apiUrl",
"https://your-project-ref.supabase.co/rest/v1",
"--apiKey",
"your-anon-key",
"--schema",
"public"
]
}
}
}Tools
postgrestRequest- Performs an HTTP request to a configured PostgREST server.
sqlToRest- Converts a SQL query to the equivalent PostgREST syntax (as method and path).
As documented on October 17, 2026. A running server reports its current list through tools/list.
Notes and caveats
- Listed under 'Other MCP servers' in the supabase/mcp repo; intended for connecting your own users to your app via REST API.
- The generic snippet is the Claude Desktop config from the package README. apiKey is optional (anon key, service role, or user JWT).
- Also usable programmatically as a library.
- No GA or beta wording found.
More MCP servers for databases
- SupabaseStatus: GA
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.
Transport: Streamable HTTPAuth: OAuth or 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 Postgrest MCP server do?
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. The vendor documents 2 tools, including postgrestRequest and sqlToRest.
How do I add the Supabase Postgrest MCP server to an MCP client?
Supabase documents a Generic config; copy it from the Generic section of this page.
Does the Supabase Postgrest MCP server need authentication?
Yes, API key. Transport: stdio. Status: Unlabelled, last checked October 17, 2026.
Sources
Last verified against 3 Supabase pages, then re-checked independently.
- raw.githubusercontent.comhttps://raw.githubusercontent.com/supabase/mcp/main/README.md
- raw.githubusercontent.comhttps://raw.githubusercontent.com/supabase/mcp/main/packages/mcp-server-postgrest/README.md
- registry.npmjs.orghttps://registry.npmjs.org/@supabase/mcp-server-postgrest
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.