PluginBench
MCP Server
Active
MIT

BigQuery Data Platform MCP Server

io.github.deBilla/data-platform-mcp

RepositoryRegistry
How to choose

What this kind of tool is for

  • Query, inspect, or seed a database without writing a one-off script.
  • Let your agent look up schema details before it writes migration code.
  • Move a small dataset between tools without leaving the terminal.

How to compare servers like this

Engine match:
Confirm it speaks your exact database and version, not just the family.
Access scope:
Read-only connections are the safe default — start there before granting writes.
Safety rails:
Check whether destructive statements need an explicit confirmation before they run.
Maintenance signal:
Database drivers change; a recently updated tool is less likely to break mid-query.

This page carries your copy-paste config: pick your MCP client in the install section on this page and use the copy button.

What is the BigQuery Data Platform MCP server?

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

How to install BigQuery Data Platform

Copy-paste configuration for popular MCP clients.

transport: stdio
Config generated by PluginBench — verify against the source before use.
Environment / auth
  • BQ_MCP_ENVIRONMENTS

    JSON map of environment name to BigQuery settings (project, location, impersonate, dataset_allowlist, byte caps). Omit when using a config file at ~/.config/data-platform-mcp/config.toml.

  • BQ_MCP_DEFAULT_ENVIRONMENT

    Environment used when a tool call omits the environment argument.

  • BQ_MCP_CONFIG

    Path to a TOML config file, overriding ~/.config/data-platform-mcp/config.toml.

  • BQ_IMPERSONATE_SERVICE_ACCOUNT

    Read-only service account to impersonate, making read-only a property of the identity rather than of this code. Create it with `data-platform-mcp setup`.

  • BQ_PROJECT

    GCP project whose BigQuery datasets are queried. Falls back to the project associated with Application Default Credentials.

  • BQ_LOCATION

    BigQuery location for jobs and datasets. Defaults to US.

  • BQ_CODE_ASSET_LOCATION

    Region holding BigQuery Studio notebooks and saved queries. Separate from BQ_LOCATION and usually different: code assets are regional and Dataform rejects multi-regions, so datasets in US typically pair with code assets in a region like us-central1. A wrong region returns an empty list rather than an error. Defaults to BQ_LOCATION.

  • BQ_DATASET_ALLOWLIST

    Comma-separated dataset IDs the server may read. Empty means all datasets.

  • BQ_WARN_BYTES

    Scan size above which a query is returned for user confirmation instead of run. Defaults to 1 GiB.

  • BQ_MAX_BYTES_BILLED

    Hard per-query scan cap; a query estimated above this never runs. Defaults to 5 GiB.

  • BQ_MCP_AUDIT_LOG

    Path for the JSONL tool-call audit log, or 'off' to disable it. SQL text is never recorded, only a hash and a length.

~/Library/Application Support/Claude/claude_desktop_config.json
JSON config
{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ],
      "env": {
        "BQ_MCP_ENVIRONMENTS": "<YOUR_BQ_MCP_ENVIRONMENTS>",
        "BQ_MCP_DEFAULT_ENVIRONMENT": "<YOUR_BQ_MCP_DEFAULT_ENVIRONMENT>",
        "BQ_MCP_CONFIG": "<YOUR_BQ_MCP_CONFIG>",
        "BQ_IMPERSONATE_SERVICE_ACCOUNT": "<YOUR_BQ_IMPERSONATE_SERVICE_ACCOUNT>",
        "BQ_PROJECT": "<YOUR_BQ_PROJECT>",
        "BQ_LOCATION": "<YOUR_BQ_LOCATION>",
        "BQ_CODE_ASSET_LOCATION": "<YOUR_BQ_CODE_ASSET_LOCATION>",
        "BQ_DATASET_ALLOWLIST": "<YOUR_BQ_DATASET_ALLOWLIST>",
        "BQ_WARN_BYTES": "<YOUR_BQ_WARN_BYTES>",
        "BQ_MAX_BYTES_BILLED": "<YOUR_BQ_MAX_BYTES_BILLED>",
        "BQ_MCP_AUDIT_LOG": "<YOUR_BQ_MCP_AUDIT_LOG>"
      }
    }
  }
}

Related MCP servers

Read-only GCP tools for debugging incidents and finding cost savings

2
Python
MIT
View repository →

Inspect PDF, Office, and iWork documents without rendering: counts, metadata, security signals

0
TypeScript
MIT
View repository →
DEDeFiMind logo

DeFiMind

Active

Live LP analytics — Uniswap V2/V3, Balancer, Curve stableswap: PnL, health, slippage, depeg risk.

0
Python
Apache-2.0
View repository →

Read and filter Excel, CSV, ODS, SQLite, Parquet and MTSV files — or a folder — as plain text

Schedule and publish social content across nine destinations with human guardrails.

DEdeAPI MCP Server logo

35 AI tools for image/video generation, TTS, transcription, OCR & embeddings via deAPI

0
Python
MIT
View repository →