Skip to content
Agent Month
Email

Connect AI agents to BigQuery with MCP

Google Cloud’s serverless data warehouse. Wiring it to your agents over the Model Context Protocol lets Claude Code, Cursor, and other clients work against it safely.

Community MCP servers exist

Why connect BigQuery to your AI agents?

The Model Context Protocol (MCP) is an open standard for exposing a system’s capabilities to AI models as typed tools. Wire BigQuery up once as an MCP server and any MCP-capable client — Claude Code, Cursor, and others — can use it, instead of every developer hand-rolling their own integration.

Google Cloud’s serverless data warehouse. Today, most engineers copy-paste data from BigQuery into a chat by hand. With an MCP connection the agent reaches it directly and safely — which is the difference between a demo and something a whole team can rely on.

What an agent can do with BigQuery

Once connected, the agent can act against BigQuery as part of a task rather than asking you to fetch context for it. Common uses:

  • Let an agent draft and run analytics queries
  • Answer questions against governed datasets
  • Estimate query cost before running

The right default is read-only: let the agent observe and reason first, then grant specific write actions deliberately, each behind audit logging and — for anything high-impact — human approval.

Connect Claude Code to BigQuery

  1. Pick or build an MCP server for BigQuery (community mcp servers exist).
  2. Register it with Claude Code via claude mcp add (or your project’s MCP config), pointing at the server’s command or URL.
  3. Provide credentials out of band — A service account with dataset-scoped, read-only IAM roles. Never hardcode them in the repo.
  4. Restart Claude Code so it discovers the server’s tools, then confirm the BigQuery tools appear.
  5. Try a read-only task first to validate scope and permissions before granting any write access.

Connect Cursor to BigQuery

  1. Open Cursor’s settings and find the MCP / tools configuration.
  2. Add the BigQuery MCP server entry (command or URL + transport).
  3. Supply credentials via environment or Cursor’s secret handling — A service account with dataset-scoped, read-only IAM roles.
  4. Reload Cursor and verify the BigQuery tools are available to the agent.

Authentication

A service account with dataset-scoped, read-only IAM roles.

Claude Code or Cursor for BigQuery?

Both speak MCP, so the same BigQuery server works in either. Reach for Claude Code when you want an agent to use BigQueryas part of an autonomous, multi-step task or in automation; reach for Cursor when you’re working interactively in the editor and want BigQuery context inline. Many teams wire it into both — see Claude Code vs Cursor for the full breakdown.

What a production setup needs

A working connection is the easy part. The hard part — and what actually matters for letting a team use agents against BigQuery — is bytes-scanned cost guards and dataset-level IAM scoping. A well-built server adds scoped credentials, read-only defaults, audit logging, and human approval gates on high-impact actions.

BigQuery MCP security checklist

What separates a safe team-wide integration from a liability:

  • Scope credentials to the minimum BigQuery access the task needs — never a full-access token.
  • Default to read-only; add write actions one at a time, deliberately.
  • Log every tool call with who, what, and when, so agent actions are auditable.
  • Keep credentials out of the repo and out of the agent’s sandbox — inject them at the boundary.
  • Gate high-impact or irreversible actions behind explicit human approval.

Troubleshooting

If the BigQuery tools don’t appear after setup, it’s almost always auth or transport. See MCP server not connecting for the step-by-step fix — and note that hosted servers often need OAuth, not a plain API key. To understand how MCP relates to ordinary tool use, see MCP vs function calling.

Frequently asked questions

Is there an official MCP server for BigQuery?

Community MCP servers exist. Whichever you use, a production setup needs bytes-scanned cost guards and dataset-level iam scoping.

How does authentication work for BigQuery over MCP?

A service account with dataset-scoped, read-only IAM roles. Credentials should never live in the sandbox or the repo; route them through your client’s secret handling or a vaulted credential.

What can an agent actually do with BigQuery?

Let an agent draft and run analytics queries; Answer questions against governed datasets; Estimate query cost before running. Start read-only and add write access deliberately, behind audit logging.

Is it safe to give agents access to BigQuery?

Yes, when scoped correctly: least-privilege credentials, read-only by default, audit logs on every call, and human approval for any high-impact action. Bytes-scanned cost guards and dataset-level IAM scoping.

Reference current as of June 2026.