Data infrastructure Official

BigQuery MCP server

Remote endpoint bigquery.googleapis.com/mcp. Checked September 2026.

Google's hosted BigQuery server lists a project's datasets and tables, reads their metadata, and runs SQL under the caller's IAM roles over whatever a brand has loaded, such as GA4 exports, Shopify orders, or ad spend from scheduled transfers. Its execute_sql tool also runs INSERT, UPDATE, and DELETE unless an admin denies it by IAM policy.

BigQuery MCP options

Every fact in a row comes from the publisher's own documentation.

Ways to reach BigQuery data from an assistant
Option	Audience	Reads or changes	Sign-in	Setup
BigQuery MCP server `https://bigquery.googleapis.com/mcp` Google	Merchants	Hosted by Google, it lists datasets and tables, reads their metadata and runs SQL under the caller's IAM roles; execute_sql_readonly allows SELECT only, while execute_sql can also run INSERT, UPDATE, DELETE, and CREATE statements unless an admin denies that tool with an IAM policy. Can write	OAuth sign-in	Setup guide (opens in a new tab)
MCP Toolbox for Databases Google Registered as io.github.googleapis/mcp-toolbox (opens in a new tab)	Developers	An open-source server run locally with its prebuilt BigQuery toolset: lists datasets and tables, searches the catalog in natural language, executes SQL statements, and calls BigQuery forecasting, contribution analysis, and data insights tools, signed in with Application Default Credentials. Can write	See guide	Setup guide (opens in a new tab)
BigQuery Data Transfer Service MCP server `https://bigquerydatatransfer.googleapis.com/mcp` Google	Developers	Lists data sources, transfer configurations, runs, and logs, and can create, update, delete, and manually start scheduled transfers such as a Google Ads load into BigQuery. Can write	OAuth sign-in	Setup guide (opens in a new tab)

Connect BigQuery to your assistant

Each card lists the servers whose setup guide covers that assistant.

Connect BigQuery to ChatGPT or Gemini

BigQuery MCP server (opens in a new tab)
Guide covers ChatGPT, Gemini CLI
BigQuery Data Transfer Service MCP server (opens in a new tab)
Guide covers ChatGPT, Gemini CLI

Connect BigQuery to Claude

BigQuery MCP server (opens in a new tab) Add from Claude's connector directory (opens in a new tab)
Claude Code
```
claude mcp add --transport http bigquery https://bigquery.googleapis.com/mcp
```
MCP Toolbox for Databases (opens in a new tab)
Guide also covers Claude Code

BigQuery Data Transfer Service MCP server

Claude Code

claude mcp add --transport http bigquery https://bigquerydatatransfer.googleapis.com/mcp

Connect BigQuery to Cursor

BigQuery MCP server

.cursor/mcp.json

{"mcpServers":{"bigquery":{"url":"https://bigquery.googleapis.com/mcp"}}}

MCP Toolbox for Databases (opens in a new tab)

BigQuery Data Transfer Service MCP server

.cursor/mcp.json

{"mcpServers":{"bigquery":{"url":"https://bigquerydatatransfer.googleapis.com/mcp"}}}

Connect BigQuery to VS Code

BigQuery MCP server

.vscode/mcp.json

{"servers":{"bigquery":{"type":"http","url":"https://bigquery.googleapis.com/mcp"}}}

MCP Toolbox for Databases (opens in a new tab)

BigQuery Data Transfer Service MCP server

.vscode/mcp.json

{"servers":{"bigquery":{"type":"http","url":"https://bigquerydatatransfer.googleapis.com/mcp"}}}

BigQuery's setup guides also name Antigravity, Windsurf, and Cline.

Tools each server exposes

Listed as each publisher documents them. A write tool can change something in the account.