Skip to content
MCP server

BigQuery Data Platform

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

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.4.0
Listing updated
4 days ago

About BigQuery Data Platform

BigQuery Data Platform is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.

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

Install

Run in a terminal

claude mcp add data-platform-mcp -- uvx data-platform-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "data-platform-mcp": {
      "type": "stdio",
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ]
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ]
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "data-platform-mcp": {
      "command": "uvx",
      "args": [
        "data-platform-mcp"
      ]
    }
  }
}

Configuration

  • 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.

Pricing

Open source

Prices change. Check debilla.github.io before you buy.

BigQuery Data Platform FAQ

Is BigQuery Data Platform free?

Yes. BigQuery Data Platform is open source, so you can use and self-host it for free.

How do I add BigQuery Data Platform to Claude Code?

Run this command in your terminal: claude mcp add data-platform-mcp -- uvx data-platform-mcp

What are the best alternatives to BigQuery Data Platform?

The closest alternatives to BigQuery Data Platform are Midplane, PlatypusDB, Lorebase, Sovaria and model2data studio.

Alternatives to BigQuery Data Platform

  1. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  2. PlatypusDB

    MCP server

    Gives MCP clients access to your PlatypusDB database connections, scoped per agent

    Runs locally
    • Open source
    • Databases
  3. Lorebase

    MCP server

    Lets agents read and change a governed, versioned Postgres knowledge graph

    Runs locally
    • Open source
    • Knowledge and memory
  4. Sovaria

    MCP server

    Manage a Sovaria backend (Postgres, auth, storage, functions) from an AI assistant

    Not checked yet
    • 4 tools
    • Remote
    • Freemium
    • Databases
  5. Generate realistic connected test data, dbt projects and dashboards from a schema

    • Remote
    • Freemium
    • Databases
  6. semlayer

    MCP server

    Infers a semantic layer from your data warehouse and serves it to agents

    Runs locally
    • Free
    • Databases