App MCP

Turn an existing Supabase database and Edge Functions into an MCP server you can install in Cursor, Claude, ChatGPT, or any MCP client.

This is not the official Supabase management MCP. That product runs SQL, migrations, and org admin. This one exposes your app: selected tables (with RLS) and your Edge Functions as tools.

What you get

1. Connect a Supabase project.

2. Pick tables and operations, register Edge Functions with a JSON Schema.

3. Install the same tool catalog two ways:

   • Hosted: paste a Streamable HTTP URL and API key into any client.

   • Self-host: run the server on your machine so Supabase keys never leave it.

Monorepo

apps/web                 Dashboard + hosted /mcp/:projectId endpoint
packages/mcp-core        Schema introspect, tool catalog, executors
packages/mcp-server      MCP factory, stdio CLI, local HTTP
examples/mcp-config.json Sample self-host config

Dashboard

npm install
cp .env.example .env
npm run dev

Open http://localhost:3000. Persistence defaults to apps/web/data/store.json. Set DASHBOARD_PASSWORD to lock the UI. Set PRODUCT_SUPABASE_URL and PRODUCT_SUPABASE_SERVICE_ROLE_KEY (and run supabase/migrations/001_init.sql) to store projects in your own Supabase instead.

Customer service_role keys are encrypted at rest. Table tools use the anon key so RLS applies unless you opt into the service role.

Self-host / local MCP

cp .env.example .env
# fill SUPABASE_URL and SUPABASE_ANON_KEY
npm run mcp -- tools
npm run mcp -- serve --stdio
npm run mcp -- serve --http --port 3333

Cursor mcp.json:

{
  "mcpServers": {
    "my-app": {
      "command": "npx",
      "args": ["tsx", "packages/mcp-server/src/cli.ts", "serve", "--stdio"],
      "env": {
        "SUPABASE_URL": "https://xxxx.supabase.co",
        "SUPABASE_ANON_KEY": "eyJ...",
        "MCP_CONFIG": "./examples/mcp-config.json"
      }
    }
  }
}

Inspector:

npx @modelcontextprotocol/inspector npx tsx packages/mcp-server/src/cli.ts serve --stdio

Hosted clients use:

{
  "mcpServers": {
    "my-app": {
      "url": "http://localhost:3000/mcp/PROJECT_ID",
      "headers": {
        "Authorization": "Bearer smcp_..."
      }
    }
  }
}

Tests

npm test