BigQuery MCP: Documentation
Updated:
Connection
npx -y @toolbox-sdk/server --prebuilt=bigquery --stdio — a prebuilt BigQuery toolset on top of the MCP Toolbox for Databases. Auth is Google Cloud Application Default Credentials (gcloud auth application-default login) or a service account with a BigQuery IAM role (e.g., BigQuery Data Viewer/Editor).
Tools
bigquery-list-dataset-ids, bigquery-get-dataset-info, bigquery-list-table-ids, bigquery-get-table-info — explore the project's structure; bigquery-execute-sql / bigquery-sql — run queries; bigquery-forecast — forecast from historical data; plus bigquery-search-catalog (data catalog search) and bigquery-analyze-contribution, bigquery-conversational-analytics for deeper analysis.
Agent flow
"What datasets exist in the analytics-prod project?", "show me the events table schema", "forecast next quarter's revenue", "find every table with a user_id field".
Pricing
The MCP Toolbox is free and open source (Apache-2.0; the repo is shared across all supported databases, ~16k stars). BigQuery queries themselves are billed by Google Cloud (by data scanned or by slots).