VS Code Supabase execute_sql
How to: VS Code Supabase execute_sql
Add Supabase to VS Code
-
01
Open .vscode/mcp.json and merge this in. Keep any servers already there.
{
"inputs": [
{
"type": "promptString",
"id": "supabase-access-token",
"description": "SUPABASE_ACCESS_TOKEN",
"password": true
}
],
"servers": {
"mcp-server-supabase": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@supabase/mcp-server-supabase"
],
"env": {
"SUPABASE_ACCESS_TOKEN": "${input:supabase-access-token}"
}
}
}
}-
02
Save the file and restart VS Code.
-
03
Ask for something execute_sql does. VS Code lists the server's tools on connect and calls execute_sql itself — you do not invoke it by name.
-
04
If nothing happens, check the server is running and that Supabase's identifier in your config matches the one above exactly.
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs
Set these first
Supabase will not start until these are set, so execute_sql never becomes available.
-
SUPABASE_ACCESS_TOKEN
Same tool, other clients
Mutating and Read-only are read off each tool's name, not its schema — a hint, not a guarantee. The registry stores tool names only; connect the server for its live schemas.