BigQuery Data Platform for Gemini CLI

io.github.debilla/data-platform-mcp

Read-only BigQuery tools for plain-language data questions, with a cost gate on every query

client:Gemini CLI transport:stdio runtime:pypi

Install BigQuery Data Platform in Gemini CLI

~/.gemini/settings.json · windows: %USERPROFILE%\.gemini\settings.json

BQ_MCP_ENVIRONMENTS

BQ_MCP_DEFAULT_ENVIRONMENT

BQ_MCP_CONFIG

BQ_IMPERSONATE_SERVICE_ACCOUNT

BQ_PROJECT

BQ_LOCATION

BQ_CODE_ASSET_LOCATION

BQ_DATASET_ALLOWLIST

BQ_WARN_BYTES

BQ_MAX_BYTES_BILLED

BQ_MCP_AUDIT_LOG

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ],
      "env": {
        "BQ_MCP_ENVIRONMENTS": "<BQ_MCP_ENVIRONMENTS>",
        "BQ_MCP_DEFAULT_ENVIRONMENT": "<BQ_MCP_DEFAULT_ENVIRONMENT>",
        "BQ_MCP_CONFIG": "<BQ_MCP_CONFIG>",
        "BQ_IMPERSONATE_SERVICE_ACCOUNT": "<BQ_IMPERSONATE_SERVICE_ACCOUNT>",
        "BQ_PROJECT": "<BQ_PROJECT>",
        "BQ_LOCATION": "<BQ_LOCATION>",
        "BQ_CODE_ASSET_LOCATION": "<BQ_CODE_ASSET_LOCATION>",
        "BQ_DATASET_ALLOWLIST": "<BQ_DATASET_ALLOWLIST>",
        "BQ_WARN_BYTES": "<BQ_WARN_BYTES>",
        "BQ_MAX_BYTES_BILLED": "<BQ_MAX_BYTES_BILLED>",
        "BQ_MCP_AUDIT_LOG": "<BQ_MCP_AUDIT_LOG>"
      }
    }
  }
}

Gemini expands $VAR and ${VAR} inside env values, so a secret can live in your shell rather than this file. Gemini CLI docs

BigQuery Data Platform in other clients

BigQuery Data Platform MCP server