Google BigQuery MCP Connector for Claude
A+Empower your AI agent to query massive datasets via BigQuery — execute Standard SQL, track active jobs, and inspect table schemas natively.
Connect your Google BigQuery data warehouse to any AI agent and empower it to act as a fractional data analyst. Traverse structured schemas, audit data pipelines, and execute complex aggregations over petabytes of data purely through conversational prompts.
What you can do
- Execute Queries — Prompt natively structural Data Analytics requests and allow the LLM to write, run, and summarize exact
Standard SQLinstantly - Discover Schemas — Inspect deep table column mappings, discovering strict clustering logic and native partitioning limits
- Audit Workloads — Paginate recent cluster jobs, identify heavily delayed computations globally, and read bytes explicitly processed by runs
- Dataset Topologies — Traverse nested datasets logically mapping GCP access properties recursively
- Performance Troubleshooting — Read exact job error traces directly confirming syntax failures natively
How it works
- Subscribe to this server
- Enter your GCP Project ID and an active OAuth/Service Account Token
- Start querying terabytes of rows securely from Claude, Cursor, or your preferred agent workspace
Stop switching into the GCP Console for quick data validations. Check database constraints and summarize recent daily logs all from your chat.
Who is this for?
- Data Engineers — troubleshoot failing scheduled queries and explore undocumented columns securely on-the-fly
- Marketing Analysts — request customer cohorts using conversational logic that natively translates to optimized SQL
- Backend Developers — rapidly confirm if application background pipelines successfully inserted the necessary rows without breaking flow
Related Connectors
Trigger.dev MCP
Equip your AI agent with direct access to Trigger.dev — manage background jobs, monitor task runs, and inspect workflow executions without opening the dashboard.
Alation MCP
Data catalog orchestration — search assets, audit metadata, and query data via AI.
Tableau MCP
Access workbooks, views, data sources, and dashboard insights from Tableau — the enterprise BI and analytics platform.
Portable.io MCP
Manage your Portable ETL pipelines directly via your AI agent — monitor flows, sync runs, and destination details seamlessly.