Supabase MCP Server
OfficialFull Supabase access — database, auth, storage, and edge functions
The official Supabase MCP server exposes your entire Supabase project to your AI assistant. Beyond basic database queries, it provides access to Supabase Auth (user management), Storage (file buckets), Edge Functions, and project configuration. It connects through the Supabase Management API using a personal access token, making it safe for use across multiple projects. Ideal for developers building on the Supabase platform who want AI assistance across their full stack.
Install Config
Config file: ~/Library/Application Support/Claude/claude_desktop_config.json· Windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"supabase": {
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase",
"--access-token",
"${SUPABASE_ACCESS_TOKEN}"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "sbp_your_token_here"
}
}
}
}Required environment variables:
SUPABASE_ACCESS_TOKEN— Supabase personal access token(e.g. sbp_xxxxxxxxxxxxxxxxxxxx)
Available Tools (6)
| Tool name | Description |
|---|---|
| execute_sql | Run SQL queries against your Supabase database |
| list_tables | List all tables across schemas |
| list_projects | List all Supabase projects in your account |
| get_project | Get details for a specific project |
| list_edge_functions | List all deployed Edge Functions |
| get_logs | Retrieve logs from your Supabase project |
Example Prompts
- “List all my Supabase projects”
- “What tables are in my production database?”
- “Show me the recent auth logs”
- “List all Edge Functions in my project”
- “What's the row count for each table?”
Pros & Cons
Pros
- Official Supabase server — full platform access
- Access to Auth, Storage, and Edge Functions — not just the database
- Works across multiple projects
Cons
- Requires a Supabase account and project
- More complex setup than a direct database connection
Who Is This For?
- ·Developers building applications on Supabase
- ·Teams using Supabase as their backend
When to use: Use when your project is hosted on Supabase and you want AI access to the full platform — not just the database.
Supported Clients
Related Use Cases
Related Servers
PostgreSQL MCP Server
OfficialQuery your PostgreSQL database with natural language
The official PostgreSQL MCP server from Anthropic lets your AI assistant read and query any PostgreSQL database. Ask que…
SQLite MCP Server
OfficialQuery and analyze SQLite databases with your AI assistant
The official SQLite MCP server gives your AI assistant full access to any SQLite database file. Unlike PostgreSQL, SQLit…