Set it up
- 1
Turn on Supabase in your AI
In Claude: open Settings → Connectors and add Supabase. In ChatGPT: Settings → Apps & Connectors.
- 2
Add it to your app once
Copy the short config below into your app. It just tells your AI where to find Supabase.
- 3
Just ask
Tell it what you want in plain words — no special commands.
For example, say
“List all tables in my Supabase database and show their row counts”
Need the exact config? Show it +
Add to your client
{
"mcpServers": {
"supabase": {
"command": "npx",
"args": ["-y", "@supabase/mcp-server-supabase@latest", "--access-token", "<your-personal-access-token>"]
}
}
}Paste into your client's MCP configuration file.
Quick skills
Copy one, paste it to your AI, watch it work.
Schema Design with AI
“Add a 'tags' jsonb column to the posts table with a GIN index and create the migration”
Data Investigation
“Show me the 10 users who signed up most recently and their completed onboarding steps”
Edge Function Deployment
“Create an Edge Function that sends a welcome email when a new user signs up”
In the wild
“I use the heck out of Supabase MCP during development, in read only mode. It's great and saves so much time! What I would never do is connect it to a production DB”
“I use LLM dev tools, and even have Supabase MCP running. I love these tools. They allowed me to create a SaaS product on my own”
“I open Claude Code and say something like "check the database for any tables missing RLS policies." Claude Code uses the MCP to list tables, then runs SQL to check which ones have Row Level Security enabled.”
Good to know
- · Use a project access token scoped to the right project — not your personal account token
- · Running migrations on production is destructive — always review generated SQL before applying
- · RLS policies can hide data from the MCP server — query results may look incomplete
When to use
- ✓ You're building an app on Supabase and want AI help with schema and queries
- ✓ You need to inspect production or staging data without leaving your editor
- ✓ You want AI to draft and apply migrations based on conversation
- ✓ You're debugging auth issues and want to query the auth schema
When not to use
- × You use Firebase, PlanetScale, or self-hosted Postgres (use those specific servers)
- × You want to give AI write access to production without a review gate
- × You need real-time WebSocket subscriptions from the MCP server (not supported)
About
Imagine telling your AI: 'Show me the last 100 signups from the users table' or 'Create a new migration that adds a created_at column' — and it manages your Supabase backend directly. This server connects your AI to Supabase so it can query databases, run migrations, deploy Edge Functions, and manage auth and storage.
The official Supabase MCP server gives AI assistants comprehensive access to the Supabase platform. Manage databases, run SQL queries, handle migrations, configure authentication, manage storage buckets, and interact with Edge Functions — all through natural language.
Maintained by the Supabase team with deep integration into the Supabase CLI and dashboard.
Workflows That Use Supabase MCP
Skip the SQL client. Ask product questions in plain English; get charts, insights, and ad-hoc reports.
Point Claude at Postgres, MongoDB, Redis, SQLite or a managed cloud DB and ask questions in plain language.
Works With
Also Consider
FAQ
What does Supabase MCP do? +
Imagine telling your AI: 'Show me the last 100 signups from the users table' or 'Create a new migration that adds a created_at column' — and it manages your Supabase backend directly. This server connects your AI to Supabase so it can query databases, run migrations, deploy Edge Functions, and manage auth and storage.
Do I need to know how to code? +
No. Turn it on in your AI's settings and ask in plain English — no terminal, no coding.
When should I use Supabase MCP? +
Reach for it when you need to: You're building an app on Supabase and want AI help with schema and queries; You need to inspect production or staging data without leaving your editor; You want AI to draft and apply migrations based on conversation; You're debugging auth issues and want to query the auth schema.
When should I avoid Supabase MCP? +
Skip it when: You use Firebase, PlanetScale, or self-hosted Postgres (use those specific servers); You want to give AI write access to production without a review gate; You need real-time WebSocket subscriptions from the MCP server (not supported).
Is Supabase MCP free? +
Supabase MCP is free and open source (Apache-2.0 license).
How do I install Supabase MCP? +
In Claude Code, run: claude mcp add supabase -- npx -y @supabase/mcp-server-supabase@latest --access-token <your-personal-access-token>. Copy-paste configs for Claude Desktop, Cursor, and Windsurf are at the top of this page.
