Google BigQuery — Claude Code MCP server: install
The Google BigQuery MCP server connects an agent to BigQuery for dataset discovery, schema checks, and read-only SQL queries.
no license 6,986 installs updated 2026-03-27
claude mcp add --transport http bigquery https://bigquery.run.toolsWhat Google BigQuery does
The server gives an agent access to BigQuery resources in a Google Cloud project. It can return dataset and table IDs, fetch metadata for either resource, and send a SQL query for its result. These actions are exposed through list_dataset_ids, get_dataset_info, list_table_ids, get_table_info, and execute_sql.
The connection uses the HTTP endpoint https://bigquery.run.tools. Queries are limited to SELECT; INSERT, UPDATE, DELETE, and stored procedures are rejected. That means this MCP server cannot write changes to BigQuery.
What it helps with
- find datasets in a Google Cloud project
- list tables inside a BigQuery dataset
- inspect table or dataset metadata
- run a read-only SQL query
Example prompts for the agent
- List the dataset IDs in my Google Cloud project.
- Inspect the schema for the
orderstable in theanalyticsdataset. - Run a
SELECTquery on theeventstable and return the results.
How to install Google BigQuery
Platform CLI: remote server
claude mcp add --transport http bigquery https://bigquery.run.toolsPlatform CLI: remote server
codex mcp add google-bigquery --url https://bigquery.run.toolsConfig file
{
"mcpServers": {
"google-bigquery": {
"url": "https://bigquery.run.tools"
}
}
}Config file
{
"servers": {
"google-bigquery": {
"type": "http",
"url": "https://bigquery.run.tools"
}
}
}Platform CLI: remote server
gemini mcp add -t http google-bigquery https://bigquery.run.toolsStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Google BigQuery
How do I install Google BigQuery in Claude Code?
Run these commands in order: claude mcp add --transport http bigquery https://bigquery.run.tools, then claude mcp add --transport http google-bigquery https://bigquery.run.tools.
What does Google BigQuery do?
This MCP server lets an agent browse BigQuery datasets and tables, inspect their metadata, and run SQL queries.
Which queries does the Google BigQuery MCP server support?
The execute_sql tool accepts SELECT queries only. INSERT, UPDATE, DELETE, and stored procedures are blocked.