Skip to content

MCP setupDatabases

Supabase MCP Server

Connect your agent to Supabase's hosted MCP server to inspect tables, run read-only SQL and manage a project from your editor.

npx workspacetemplates add supabase-mcp --tool claude-code

Writes 1 file to your project root

.mcp.jsonmerge into your file11 lines · 254 BFile
{
  "mcpServers": {
    "supabase": {
      "type": "http",
      "url": "https://mcp.supabase.com/mcp?project_ref=${SUPABASE_PROJECT_REF}&read_only=true",
      "headers": {
        "Authorization": "Bearer ${SUPABASE_ACCESS_TOKEN}"
      }
    }
  }
}

What it does

Supabase runs an official MCP server that lets an agent list tables, read schemas, run SQL and look up the docs for one project. It is useful when the agent needs the real schema, not a guess.

This config pins the server to a single project and turns on read-only mode. Remove the read-only flag only when you want the agent to change data, and keep it away from production.

Example

you › List the tables in my project and tell me which have no row-level security policy.

agent › public has 9 tables. Without RLS enabled: audit_log, feature_flags. orders and profiles have policies for select and insert only.

Questions

Where do I find the project ref?
In the Supabase dashboard under project settings, or in the dashboard URL after /project/.
Can I let it write?
Delete read_only=true from the URL. Do that on a development project only.
  • Convex MCP Server

    MCP setuptypescript

    Free
  • MongoDB MCP Server

    MCP setupDatabases

    Free
  • Neon MCP Server

    MCP setupDatabases

    Free
  • PlanetScale MCP Server

    MCP setupDatabases

    Free