Supabase
ECOSYSTEM REFERENCEAUTH REQUIREDProprietaryOpen SourceSource: @agenticmarket· community reference
Connect your AI coding assistant to Supabase. Query databases, run migrations, deploy Edge Functions, and manage projects — all through natural language in VS Code, Cursor, Claude Desktop, and more.
This server requires your own API credentials or OAuth tokens to function. You can install it via `npx agenticmarket install supabase` and provide your credentials during setup, or use the manual config guide below.
Setup Guide
{
"mcpServers": {
"supabase": {
"type": "http",
"url": "https://mcp.supabase.com/mcp"
}
}
}Tools
list_tables
List all tables in the database
list_extensions
List available and installed Postgres extensions
list_migrations
List existing database migrations
apply_migration
Apply a new database migration
execute_sql
Execute arbitrary SQL queries against the database
get_logs
Retrieve service logs for API, Postgres, Edge Functions, Auth, Storage, or Realtime
get_advisors
Get security and performance advisor recommendations
get_project_url
Get the REST API URL for the Supabase project
get_publishable_keys
Get the anon/public API keys for the project
generate_typescript_types
Generate TypeScript types directly from the database schema
list_edge_functions
List all deployed Edge Functions in the project
get_edge_function
Inspect the source and metadata of a specific Edge Function
deploy_edge_function
Deploy a new or updated Edge Function
list_projects
List all Supabase projects in your account
get_project
Get details for a specific Supabase project
create_project
Create a new Supabase project
pause_project
Pause an active project
restore_project
Restore a previously paused project
list_organizations
List all organizations in the account
get_organization
Get details for a specific organization
get_cost
Get cost information for a project or account
confirm_cost
Confirm a cost action before it is applied
search_docs
Search Supabase official documentation
create_branch
Create a new database branch (requires paid plan)
list_branches
List all database branches (requires paid plan)
delete_branch
Delete a database branch (requires paid plan)
merge_branch
Merge a branch into the production database (requires paid plan)
reset_branch
Reset a branch to its original base state (requires paid plan)
rebase_branch
Rebase a branch against latest production (requires paid plan)
list_storage_buckets
List all storage buckets (disabled by default — enable with ?features=storage)
get_storage_config
Get storage configuration (disabled by default)
update_storage_config
Update storage configuration (disabled by default)
Compatibility
About
What This Server Does
The Supabase MCP server is the official Model Context Protocol server for Supabase. It bridges your AI assistant directly to your Supabase project — letting you inspect schemas, execute SQL, deploy Edge Functions, debug logs, and manage projects without leaving your editor.
Ask your AI agent questions like:
- "What tables are in my database?"
- "Generate TypeScript types from my schema."
- "Show me the last 50 Postgres error logs."
- "Deploy my new Edge Function."
- "Create a new branch for this feature."
No copy-pasting, no context-switching. Your agent has direct, authenticated access to your Supabase project.
Installation
One-command install via AgenticMarket CLI
bashagenticmarket install supabase/mcp
This auto-detects your IDE and writes the configuration. Supports VS Code, Cursor, Claude Desktop, Claude Code, Windsurf, Zed, and more.
Manual configuration
VS Code / Claude Code (.vscode/mcp.json)
json{ "servers": { "supabase": { "type": "http", "url": "https://mcp.supabase.com/mcp" } } }
Cursor (.cursor/mcp.json)
json{ "mcpServers": { "supabase": { "url": "https://mcp.supabase.com/mcp" } } }
Claude Desktop (claude_desktop_config.json)
json{ "mcpServers": { "supabase": { "type": "http", "url": "https://mcp.supabase.com/mcp" } } }
Scoped to a specific project
Add ?project_ref=<your-project-id> to the server URL to limit the server to a single project:
https://mcp.supabase.com/mcp?project_ref=abc123
Read-only mode
For safer usage with real data, enable read-only mode:
https://mcp.supabase.com/mcp?read_only=true
Enable specific feature groups only
https://mcp.supabase.com/mcp?features=database,docs
Authentication
Once the server is configured, your MCP client will open a browser window to log in to your Supabase account. No personal access token (PAT) required for standard usage — the server uses OAuth dynamic client registration automatically.
CI / headless environments:
Generate a PAT from your Supabase account settings and pass it as a header:
json{ "mcpServers": { "supabase": { "type": "http", "url": "https://mcp.supabase.com/mcp?project_ref=${SUPABASE_PROJECT_REF}", "headers": { "Authorization": "Bearer ${SUPABASE_ACCESS_TOKEN}" } } } }
Available Tools
Database
| Tool | Description |
|---|---|
list_tables | List all tables in the database |
list_extensions | List available and installed Postgres extensions |
list_migrations | List existing database migrations |
apply_migration | Apply a new database migration |
execute_sql | Execute arbitrary SQL queries |
Debugging
| Tool | Description |
|---|---|
get_logs | Retrieve service logs — API, Postgres, Edge Functions, Auth, Storage, Realtime |
get_advisors | Get security and performance advisor recommendations |
Development
| Tool | Description |
|---|---|
get_project_url | Get the REST API URL for your project |
get_publishable_keys | Get the anon/public API keys |
generate_typescript_types | Generate TypeScript types directly from your database schema |
Edge Functions
| Tool | Description |
|---|---|
list_edge_functions | List all deployed Edge Functions |
get_edge_function | Inspect a specific Edge Function |
deploy_edge_function | Deploy a new or updated Edge Function |
Account Management
| Tool | Description |
|---|---|
list_projects | List all projects in your account |
get_project | Get details for a specific project |
create_project | Create a new Supabase project |
pause_project | Pause a project |
restore_project | Restore a paused project |
list_organizations | List organizations in your account |
get_organization | Get details for a specific organization |
get_cost | Check cost information for a project |
confirm_cost | Confirm a cost action |
Documentation
| Tool | Description |
|---|---|
search_docs | Search Supabase documentation from within your agent |
Branching (requires paid plan)
| Tool | Description |
|---|---|
create_branch | Create a new database branch |
list_branches | List all branches |
delete_branch | Delete a branch |
merge_branch | Merge a branch to production |
reset_branch | Reset a branch to its base state |
rebase_branch | Rebase a branch |
Storage (disabled by default)
| Tool | Description |
|---|---|
list_storage_buckets | List all storage buckets |
get_storage_config | Get storage configuration |
update_storage_config | Update storage configuration |
Configuration Parameters
| Parameter | Description | Example |
|---|---|---|
project_ref | Scope the server to a single project | ?project_ref=abc123 |
read_only | Execute all queries as a read-only Postgres user | ?read_only=true |
features | Enable only specific tool groups (comma-separated) | ?features=database,docs |
Parameters can be combined:
https://mcp.supabase.com/mcp?project_ref=abc123&read_only=true&features=database,debugging
Local Development
When using Supabase CLI for local development, the MCP server is available at:
http://localhost:54321/mcp
Security Best Practices
- Never connect to production — use the server with a development or staging project only
- Enable read-only mode when connecting to any project with real data
- Scope to a project using
?project_ref=to limit access surface - Review every tool call before confirming — most MCP clients prompt per call
- Use branching to test schema changes before merging to production
- Restrict feature groups to only the tools your agent needs
Prompt injection warning: Never ask your AI agent to process untrusted user-submitted content (e.g. support tickets, form submissions) while the Supabase MCP server is connected. Malicious instructions inside that content could trigger unintended database operations.
Supported IDEs
Works out of the box with any IDE that supports MCP:
- VS Code (with GitHub Copilot)
- Cursor
- Claude Desktop
- Claude Code
- Windsurf
- Zed
- Cline
- Codex
Related Resources
FAQ
Does this require an API key?
No. The server uses OAuth browser-based login by default. For CI environments, a personal access token (PAT) can be used instead.
Is it safe for production databases?
Supabase recommends using this server only with development projects. For production data, always enable ?read_only=true and scope to a specific project.
Install and Troubleshooting Intent Coverage
Developer-install and troubleshooting intent for community MCP server listings.
install mcp server / mcp server setup guide
mcp json config example / vscode mcp setup
mcp server not working / mcp tools not showing
mcp server compatibility matrix / cursor vs vscode mcp compatibility
mcp server monetization options / convert community mcp server to paid listing
Related Setup, Debug, and Learning Links
Database MCP troubleshooting
Connection and env-path failures are common in DB tools.
Authentication guide
Most database listings require secure credential flow.
CLI installation guide
Install baseline for all IDEs before listing-specific setup.
Using servers guide
Covers runtime usage patterns and auth flow.
Cursor setup walkthrough
High-intent setup path for developer troubleshooting journeys.
Troubleshooting: tools not showing
Covers discovery/listing failures across major IDEs.
Related explore entry: Memory
Keeps same-intent users on matched category and tool shape.
Related explore entry: Roundtable MCP
Keeps same-intent users on matched category and tool shape.
Related explore entry: Sequential Thinking
Keeps same-intent users on matched category and tool shape.
Related explore entry: Everything MCP Server
Keeps same-intent users on matched category and tool shape.
Install this server with the AgenticMarket CLI — you'll be prompted for your API credentials or OAuth tokens during setup. No manual JSON editing.
$npx agenticmarket install supabaseMemory
Give your AI assistant persistent memory across conversations. The Memory server stores entities, relations, and observations in a local knowledge graph that persists between sessions.
Roundtable MCP
Multi-model AI council MCP server that enables collaborative reasoning for architecture, debugging, code review, and engineering decisions.
Sequential Thinking
Enhance your AI assistant's reasoning with structured, step-by-step thinking. Supports revisions, branching, and dynamic adjustment of reasoning depth.
Everything MCP Server
The official MCP reference server that exercises every protocol feature — prompts, tools, resources, sampling, and all transports. Built for MCP client developers and testing.
AgenticMarket