Supabase

Supabase’s official MCP server (supabase-community/supabase-mcp).

Why it matters

Checking schema, running queries, and applying migrations meant the Supabase dashboard or CLI. Connect the Supabase MCP and you can do database and backend work as a conversation in Claude Code.

What you can do

Representative tasks from Supabase’s official docs:

• List tables and schema — “List all tables and show the schema of the users table.”
• Run SQL — “Run this query against my project and summarize the results.”
• Apply migrations — “Create a migration that adds a created_at column to the orders table and apply it.”
• Generate TypeScript types — “Generate TypeScript types for my database schema.”
• Debug — “Fetch the recent service logs and the security advisor warnings.”
• Deploy edge functions — “Deploy this edge function to my project.”

Grounded in supabase.com/docs/guides/getting-started/mcp.

Key features

• Database — list_tables, execute_sql, apply_migration, list_migrations
• Development — generate_typescript_types, get_project_url, get_publishable_keys
• Debugging — get_logs, get_advisors
• Edge functions — list_edge_functions, deploy_edge_function
• Branching, storage, docs search (search_docs)

Setup

Remote (recommended):

claude mcp add --transport http supabase "https://mcp.supabase.com/mcp?project_ref=YOUR_REF&read_only=true" --header "Authorization: Bearer YOUR_ACCESS_TOKEN"

Local:

claude mcp add supabase -- npx -y @supabase/mcp-server-supabase@latest --read-only --project-ref=YOUR_REF --access-token=YOUR_TOKEN

Notes

• Auth — pass a personal access token (PAT) via an Authorization: Bearer header or --access-token (OAuth login is also supported)
• Use --read-only (or read_only=true) when connecting to a production database
• License — Apache 2.0 (supabase-community/supabase-mcp, canonical supabase/mcp)
• Also available as an official Claude connector (paid Claude plans)