BigQuery MCP server: list datasets and tables, read schemas, run SELECT queries with a byte limit.
Connect Runs on your machine
claude mcp add bigquery-mcp -e GOOGLE_APPLICATION_CREDENTIALS=<GOOGLE_APPLICATION_CREDENTIALS> -e GOOGLE_OAUTH_CLIENT_ID=<GOOGLE_OAUTH_CLIENT_ID> -e GOOGLE_OAUTH_CLIENT_SECRET=<GOOGLE_OAUTH_CLIENT_SECRET> -e GOOGLE_OAUTH_REFRESH_TOKEN=<GOOGLE_OAUTH_REFRESH_TOKEN> -e BIGQUERY_MCP_PROJECT_ID=<BIGQUERY_MCP_PROJECT_ID> -e BIGQUERY_MCP_MAX_BYTES_BILLED=<BIGQUERY_MCP_MAX_BYTES_BILLED> -- npx -y @renzo.johnson/[email protected]{
"mcpServers": {
"bigquery-mcp": {
"command": "npx",
"args": [
"-y",
"@renzo.johnson/[email protected]"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_OAUTH_CLIENT_ID": "<GOOGLE_OAUTH_CLIENT_ID>",
"GOOGLE_OAUTH_CLIENT_SECRET": "<GOOGLE_OAUTH_CLIENT_SECRET>",
"GOOGLE_OAUTH_REFRESH_TOKEN": "<GOOGLE_OAUTH_REFRESH_TOKEN>",
"BIGQUERY_MCP_PROJECT_ID": "<BIGQUERY_MCP_PROJECT_ID>",
"BIGQUERY_MCP_MAX_BYTES_BILLED": "<BIGQUERY_MCP_MAX_BYTES_BILLED>"
}
}
}
}{
"mcpServers": {
"bigquery-mcp": {
"command": "npx",
"args": [
"-y",
"@renzo.johnson/[email protected]"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_OAUTH_CLIENT_ID": "<GOOGLE_OAUTH_CLIENT_ID>",
"GOOGLE_OAUTH_CLIENT_SECRET": "<GOOGLE_OAUTH_CLIENT_SECRET>",
"GOOGLE_OAUTH_REFRESH_TOKEN": "<GOOGLE_OAUTH_REFRESH_TOKEN>",
"BIGQUERY_MCP_PROJECT_ID": "<BIGQUERY_MCP_PROJECT_ID>",
"BIGQUERY_MCP_MAX_BYTES_BILLED": "<BIGQUERY_MCP_MAX_BYTES_BILLED>"
}
}
}
}{
"servers": {
"bigquery-mcp": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@renzo.johnson/[email protected]"
],
"env": {
"GOOGLE_APPLICATION_CREDENTIALS": "<GOOGLE_APPLICATION_CREDENTIALS>",
"GOOGLE_OAUTH_CLIENT_ID": "<GOOGLE_OAUTH_CLIENT_ID>",
"GOOGLE_OAUTH_CLIENT_SECRET": "<GOOGLE_OAUTH_CLIENT_SECRET>",
"GOOGLE_OAUTH_REFRESH_TOKEN": "<GOOGLE_OAUTH_REFRESH_TOKEN>",
"BIGQUERY_MCP_PROJECT_ID": "<BIGQUERY_MCP_PROJECT_ID>",
"BIGQUERY_MCP_MAX_BYTES_BILLED": "<BIGQUERY_MCP_MAX_BYTES_BILLED>"
}
}
}
}Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.
Tools
This server runs locally, so its tools are listed by your MCP client once it starts.
Environment variables
| Name | Description |
|---|---|
GOOGLE_APPLICATION_CREDENTIALSOptional | Path to a service account key or authorized_user JSON file. Optional if you use gcloud Application Default Credentials or the OAuth variables. |
GOOGLE_OAUTH_CLIENT_IDOptional | OAuth client ID. Set together with the client secret and refresh token. |
GOOGLE_OAUTH_CLIENT_SECRETOptional, secret | OAuth client secret. |
GOOGLE_OAUTH_REFRESH_TOKENOptional, secret | OAuth refresh token with the BigQuery scopes. |
BIGQUERY_MCP_PROJECT_IDOptional | Google Cloud project ID used when a request does not name one. |
BIGQUERY_MCP_MAX_BYTES_BILLEDOptional | Largest number of bytes a query may scan (default 1000000000). |
Details
| Package | @renzo.johnson/[email protected] (NPM, stdio) |
| First published | 13 Nov 2026 |
| Last updated | 13 Nov 2026 |
| Registry name | com.renzojohnson/bigquery-mcp |
More databases servers See all
Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.