BigQuery Data Platform MCP Server
io.github.deBilla/data-platform-mcp
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.
BQ_MCP_ENVIRONMENTSJSON 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_ENVIRONMENTEnvironment used when a tool call omits the environment argument.
BQ_MCP_CONFIGPath to a TOML config file, overriding ~/.config/data-platform-mcp/config.toml.
BQ_IMPERSONATE_SERVICE_ACCOUNTRead-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_PROJECTGCP project whose BigQuery datasets are queried. Falls back to the project associated with Application Default Credentials.
BQ_LOCATIONBigQuery location for jobs and datasets. Defaults to US.
BQ_CODE_ASSET_LOCATIONRegion 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_ALLOWLISTComma-separated dataset IDs the server may read. Empty means all datasets.
BQ_WARN_BYTESScan size above which a query is returned for user confirmation instead of run. Defaults to 1 GiB.
BQ_MAX_BYTES_BILLEDHard per-query scan cap; a query estimated above this never runs. Defaults to 5 GiB.
BQ_MCP_AUDIT_LOGPath for the JSONL tool-call audit log, or 'off' to disable it. SQL text is never recorded, only a hash and a length.
{
"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

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

io.github.deckflow/deckprobe
Inspect PDF, Office, and iWork documents without rendering: counts, metadata, security signals

DeFiMind
Live LP analytics — Uniswap V2/V3, Balancer, Curve stableswap: PnL, health, slippage, depeg risk.
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.

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