BigQuery MCP

Local install

com.renzojohnson/bigquery-mcpv26.11.14 Domain verified

BigQuery MCP server: list datasets and tables, read schemas, run SELECT queries with a byte limit.

Data & Databases

Watch Website

Registry entry

Open in the registry

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-11-13T01:57:38.15442Z",
      "publishedAt": "2026-11-13T01:57:38.15442Z",
      "statusChangedAt": "2026-11-13T01:57:38.15442Z"
    }
  },
  "server": {
    "name": "com.renzojohnson/bigquery-mcp",
    "title": "BigQuery MCP",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "version": "26.11.14",
    "packages": [
      {
        "version": "26.11.14",
        "transport": {
          "type": "stdio"
        },
        "identifier": "@renzo.johnson/bigquery-mcp",
        "registryType": "npm",
        "environmentVariables": [
          {
            "name": "GOOGLE_APPLICATION_CREDENTIALS",
            "format": "filepath",
            "description": "Path to a service account key or authorized_user JSON file. Optional if you use gcloud Application Default Credentials or the OAuth variables."
          },
          {
            "name": "GOOGLE_OAUTH_CLIENT_ID",
            "format": "string",
            "description": "OAuth client ID. Set together with the client secret and refresh token."
          },
          {
            "name": "GOOGLE_OAUTH_CLIENT_SECRET",
            "format": "string",
            "isSecret": true,
            "description": "OAuth client secret."
          },
          {
            "name": "GOOGLE_OAUTH_REFRESH_TOKEN",
            "format": "string",
            "isSecret": true,
            "description": "OAuth refresh token with the BigQuery scopes."
          },
          {
            "name": "BIGQUERY_MCP_PROJECT_ID",
            "format": "string",
            "description": "Google Cloud project ID used when a request does not name one."
          },
          {
            "name": "BIGQUERY_MCP_MAX_BYTES_BILLED",
            "format": "string",
            "description": "Largest number of bytes a query may scan (default 1000000000)."
          }
        ]
      }
    ],
    "websiteUrl": "https://renzojohnson.com/contributions/bigquery-mcp",
    "description": "BigQuery MCP server: list datasets and tables, read schemas, run SELECT queries with a byte limit."
  }
}

Maintain this server? Claim it

Try it

This server only runs locally, from a package. Install it with the instructions on this page to try it.

Install

Pick your client. Values in capitals, like YOUR_TOKEN, are yours to fill in.

One click: Add to Cursor Add to VS Code Add to LM Studio Add to Goose

Run in a terminal

claude mcp add bigquery-mcp \
  -- npx -y @renzo.johnson/[email protected]

Environment

GOOGLE_APPLICATION_CREDENTIALS (optional, not in the config above): 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_ID (optional, not in the config above): OAuth client ID. Set together with the client secret and refresh token.
GOOGLE_OAUTH_CLIENT_SECRET (optional, not in the config above): OAuth client secret.
GOOGLE_OAUTH_REFRESH_TOKEN (optional, not in the config above): OAuth refresh token with the BigQuery scopes.
BIGQUERY_MCP_PROJECT_ID (optional, not in the config above): Google Cloud project ID used when a request does not name one.
BIGQUERY_MCP_MAX_BYTES_BILLED (optional, not in the config above): Largest number of bytes a query may scan (default 1000000000).

Tools

We don't run packages, so we can't list this server's tools.