Supabase MCP: Documentation

Connection

• Local (stdio): npx -y @supabase/mcp-server-supabase@latest --project-ref=<ref> with a personal access token. Use --read-only for a safe mode (read-only Postgres role only).
• Hosted: https://mcp.supabase.com/mcp with URL parameters — ?project_ref=<id>&read_only=true&features=database,docs.
• Local development (Supabase CLI): http://localhost:54321/mcp.

Tools by group

• Database: list_tables, list_extensions, list_migrations, apply_migration, execute_sql.
• Debugging: get_logs (API, Postgres, Edge Functions, Auth, Storage, Realtime), get_advisors (security and performance advice).
• Development: get_project_url, get_publishable_keys, generate_typescript_types.
• Edge Functions: list_edge_functions, get_edge_function, deploy_edge_function.
• Docs: search_docs.
• Account management (disabled in project-scoped mode): list_projects/get_project, create_project/pause_project/restore_project, list_organizations/get_organization, get_cost/confirm_cost.
• Branching (experimental, requires a paid plan): create_branch, list_branches, delete_branch, merge_branch, reset_branch, rebase_branch.
• Storage (disabled by default): list_storage_buckets, get_storage_config, update_storage_config.

Agent flow

"Create an orders table with RLS", "show slow queries", "generate types for the frontend".

Limits

The branching tool group requires a paid Supabase plan. The URL's features= parameter and local server flags let you enable only the groups you need, keeping the tool list lean.