Supabase MCP
Give AI agents governed, policy-scoped access to your Supabase Postgres backend
A Model Context Protocol integration lets an autonomous agent operate a Supabase project directly: inspect schema, run SQL queries, manage migrations and branches, read logs, and work with data and edge functions through a governed interface. Agents act on the live backend with permissions and read-only modes we set, so they can build and investigate without a human relaying every command.
List tables, columns, and relationships, then run parameterized SQL reads against the live database.
Draft and execute versioned migrations to create tables, indexes, RLS policies, and functions.
Spin up development branches, check project settings, and retrieve connection details for a task.
Pull API, Postgres, and edge-function logs to diagnose errors and verify that changes behaved.
An agent reads the current schema, proposes a migration for a new feature, applies it on a dev branch, and generates the typed queries the frontend needs — all reviewed before it touches production.
When a metric looks off, an agent queries the relevant tables, cross-checks Postgres and edge-function logs, and returns a root-cause summary with the exact rows and errors involved.
An agent monitors embedding tables in pgvector, backfills missing vectors, and reindexes on a schedule, keeping a retrieval system fresh without manual SQL runs.
We scope access deliberately — read-only mode for investigation, dev branches for changes, and explicit review gates before any migration reaches production.
Only what the MCP connection and its credentials permit: the schema, data, logs, and config you grant. We limit scope per project and per task.
No. Agents handle the mechanical work of querying, drafting migrations, and debugging, while we keep approval of anything that alters schema or writes to live data.
