BigQuery-Read-Only-MCP-Server
JSON →A secure, self-hosted Model Context Protocol (MCP) server for Google BigQuery. Hard table allowlists, per-query scan ceilings, built-in rate limiting, and predictable costs on Cloud Run. Works with Claude, ChatGPT, Cursor, Gemini, and any MCP-compatible AI agent.
Install
pip install -r Tools · 2
- get_table_schema Retrieve the schema of an allowed BigQuery table
- query_assessments Run SELECT queries against allowed BigQuery tables with scan budget, row cap, and rate limiting
Environment variables
BQ_DATASET_IDMCP_API_KEYMCP_ADMIN_KEYPROJECT_IDGCP_PROJECT_IDYOUR_MCP_API_KEY