BigQuery MCP Server

A custom MCP server for Google BigQuery with service account authentication.

Setup

1. Install dependencies:

   pip install -r requirements.txt

2. Set environment variables:

   export BQ_SERVICE_ACCOUNT_KEY="/path/to/your-service-account-key.json"
   export BQ_PROJECT_ID="your-default-project-id"

3. Run the server:

   python bigquery_mcp.py

Related MCP server: BigQuery Readonly MCP

Configuration for Claude Desktop / Cowork

Add this to your MCP settings (e.g. claude_desktop_config.json):

{
  "mcpServers": {
    "bigquery": {
      "command": "python",
      "args": ["/path/to/bigquery_mcp.py"],
      "env": {
        "BQ_SERVICE_ACCOUNT_KEY": "/path/to/your-service-account-key.json",
        "BQ_PROJECT_ID": "looplink-drt"
      }
    }
  }
}

Available Tools

Notes

• Only SELECT queries are allowed (safety enforced)

• 10 GB billing cap per query

• Supports both looplink-drt and dandelion-tf-production projects via project_id parameter