BigQuery MCP for VS Code
com.renzojohnson/bigquery-mcp
BigQuery MCP server: list datasets and tables, read schemas, run SELECT queries with a byte limit.
client:VS Code
transport:stdio
runtime:npm
Install BigQuery MCP in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "google-application-credentials",
"description": "GOOGLE_APPLICATION_CREDENTIALS",
"password": true
},
{
"type": "promptString",
"id": "google-oauth-client-id",
"description": "GOOGLE_OAUTH_CLIENT_ID",
"password": true
},
{
"type": "promptString",
"id": "google-oauth-client-secret",
"description": "GOOGLE_OAUTH_CLIENT_SECRET",
"password": true
},
{
"type": "promptString",
"id": "google-oauth-refresh-token",
"description": "GOOGLE_OAUTH_REFRESH_TOKEN",
"password": true
},
{
"type": "promptString",
"id": "bigquery-mcp-project-id",
"description": "BIGQUERY_MCP_PROJECT_ID",
"password": true
},
{
"type": "promptString",
"id": "bigquery-mcp-max-bytes-billed",
"description": "BIGQUERY_MCP_MAX_BYTES_BILLED",
"password": true
}
],
"servers": {
"bigquery-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@renzo.johnson/bigquery-mcp"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}",
"GOOGLE_OAUTH_CLIENT_ID": "${input:google-oauth-client-id}",
"GOOGLE_OAUTH_CLIENT_SECRET": "${input:google-oauth-client-secret}",
"GOOGLE_OAUTH_REFRESH_TOKEN": "${input:google-oauth-refresh-token}",
"BIGQUERY_MCP_PROJECT_ID": "${input:bigquery-mcp-project-id}",
"BIGQUERY_MCP_MAX_BYTES_BILLED": "${input:bigquery-mcp-max-bytes-billed}"
}
}
}
}VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs