Supabase MCP server

Supabase × VS Code

Use the Supabase MCP server
in VS Code

Query your database, inspect schema, and manage projects (dev, not prod). This guide connects Supabase to VS Code (GitHub Copilot's agent mode) through a governed gateway — one URL that also works in every other MCP client you use, with your rules and a full log attached.

Live-probed · Security-scanned · OAuth sign-in

Setup: Supabase in VS Code

VS Code adds MCP servers via MCP server configuration. The gateway route takes about two minutes:

  1. Connect Supabase to your free gate gateway from the verified directory.
  2. On your gate overview, click 'Add to VS Code' — VS Code prompts to add the gateway as an HTTP MCP server.
  3. Confirm and approve the sign-in.
  4. Copilot's agent mode can now use Supabase — logged and governed through your gateway.

What to ask once it’s connected

Show me the schema of the users table.
Query signups per week in the dev database.
Why might this query be slow? Check the indexes.
Draft a migration for this new column.

Why route it through a gateway

One URL, every client

The same Supabase connection works in Claude, Claude Code, ChatGPT, Cursor too — no per-client re-wiring.

Rules before regret

Allow, ask, or block every tool Supabase exposes — reads can flow freely while writes require your approval.

Every call logged

A plain-language activity log of everything VS Code did with Supabase — searchable, exportable, auditable.

Scanned and probed

Supabase passed a live handshake probe and a security scan before listing — and drift detection watches it after you connect.

Also available: Supabase in Claude · Supabase in Claude Code · Supabase in ChatGPT · Supabase in Cursor