Supabase is a Databases MCP server that lets Claude Code, Cursor, Windsurf and any MCP-compatible AI agent database, auth, storage via Supabase. Install in 1 minute with mcpizy install supabase-mcp.
Connect your Supabase account once — MCPizy stores the credentials encrypted and uses them whenever you run a recipe in managed mode.
mcpizy install supabase-mcpnpx -y supabase-mcplist_tablesList all tables in one or more schemas of the project
Inputs
schemasstring[]optionallist_extensionsList all Postgres extensions installed in the database
list_migrationsList all migrations applied to the project
apply_migrationApply a SQL migration (DDL). Use this for schema changes
Inputs
namestringrequiredquerystringrequiredexecute_sqlExecute raw SQL (DML/queries)
Inputs
querystringrequiredget_logsFetch logs for a service (api, postgres, auth, storage, realtime)
Inputs
servicestringrequiredget_advisorsGet security and performance advisors for the project
Inputs
typestringrequiredlist_edge_functionsList all Edge Functions in the project
deploy_edge_functionDeploy a new or updated Edge Function
Inputs
namestringrequiredfilesobject[]requiredgenerate_typescript_typesGenerate TypeScript types from the current schema
Works identically across clients. Only the config file path differs.
~/.claude.json{
"mcpServers": {
"supabase-mcp": {
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase@latest",
"--access-token",
"${SUPABASE_ACCESS_TOKEN}"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "sbp_..."
}
}
}
}.cursor/mcp.json{
"mcpServers": {
"supabase-mcp": {
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase@latest",
"--access-token",
"${SUPABASE_ACCESS_TOKEN}"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "sbp_..."
}
}
}
}~/.codeium/windsurf/mcp_config.json{
"mcpServers": {
"supabase-mcp": {
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase@latest",
"--access-token",
"${SUPABASE_ACCESS_TOKEN}"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "sbp_..."
}
}
}
}Paste any of these prompts into Claude Code, Cursor or another MCP-compatible client.
“List every table in the public schema and summarise the columns of `users`”
Uses: list_tables
“Create a new `invoices` table with columns id, user_id, amount, status — generate the migration”
Uses: apply_migration
“Run `SELECT COUNT(*) FROM auth.users` and show me the result”
Uses: execute_sql
“Deploy an Edge Function named `hello` that returns `Hello, world`”
Uses: deploy_edge_function
“Audit my database for security issues and generate fresh TypeScript types”
Uses: get_advisors, generate_typescript_types
If Supabase doesn't fit your stack, these Databases MCP servers solve similar problems.
The Supabase MCP server is an Databases Model Context Protocol server that lets Claude Code, Cursor, Windsurf, VS Code with Copilot, and other MCP-compatible AI agents database, auth, storage via Supabase. It exposes Supabase's capabilities as tools the AI can call directly from your editor or CLI.
The fastest way is the MCPizy CLI: run `mcpizy install supabase-mcp` and MCPizy will add the server to your `.claude.json` automatically. You can also install it manually by adding an entry under `mcpServers` in `.claude.json` with the command `npx -y supabase-mcp` and restarting Claude Code.
Yes. The Supabase MCP server is free and open source (see the GitHub repository linked on this page). You may still need a Supabase account or API key to connect the server to the underlying service, but the MCP layer itself has no MCPizy subscription cost.
Yes. Any MCP-compatible client works — including Claude Code, Claude Desktop, Cursor (via `.cursor/mcp.json`), Windsurf, VS Code with Copilot Chat, and custom agents built on the MCP SDK. The same install command targets all of them; only the config file path differs.
Once installed, your AI agent can database, auth, storage via Supabase directly inside your conversation. Typical use cases include asking Claude Code or Cursor to run Supabase operations, inspect results, chain Supabase with other MCP servers (see our Workflow Recipes), and automate repetitive databases tasks without leaving your editor.