Set up Supabase MCP in VS Code
Query your Supabase database, manage tables, run migrations, deploy edge functions, and manage branches directly from your AI editor.
1
Locate the config file
VS Code reads MCP server configuration from the following file:
.vscode/settings.json → mcp sectionCreate this file if it does not already exist. For VS Code, this is inside your workspace .vscode/settings.json file under the mcp section.
2
Add the configuration
Add the following to your VS Code config file:
json
{
"servers": {
"supabase-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "YOUR_SUPABASE_ACCESS_TOKEN"
}
}
}
}3
Set up environment variables
Supabase MCP requires the following environment variables:
SUPABASE_ACCESS_TOKENRequiredSupabase personal access token
4
Verify it works
Restart VS Code. Supabase MCP should appear in your MCP server list with 25 tools available.
This server adds approximately 12,875 tokens to your context window for tool definitions.