Developer Tools

Google BigQuery MCP Server

Use Studio chat to drive this server — credentials stay in your workspace.

Google BigQuery is a serverless, highly scalable data warehouse with built-in machine learning capabilities. Run SQL queries on massive datasets, perform real-time analytics, integrate machine learning models, and analyze petabytes of data with automatic scaling and optimization for business intelligence and data science.

10 tools
Agent guide included
API Key
Start Chatting

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for Google BigQuery — workflow patterns, data models, and gotchas for your AI agent.

BigQuery

BigQuery uses project/dataset/table hierarchy. Run SQL, list datasets/tables, preview rows. Auth via service account JSON.

Data Model

  • Datasets contain tables. Format: project.dataset. List datasets for discovery.
  • Tables are in datasets. List tables by dataset_id. Get schema, preview, stats, list rows.
  • Search runs parameterized SQL. Returns rows with resource ids for fetch (bigquery:row:...).
  • Queries: Standard SQL. Fully qualified names: project.dataset.table.

Gotchas

  • Fully qualified names: Use backticks for project.dataset.table when project has hyphens/dots.
  • Service account: Auth via JSON key. Uses Google SDK, not HTTP headers.
  • Resource id: From search results for fetch. Format includes project, dataset, table, row identifier.

Tools in this Server (10)

Bigquery Execute

Execute write operations on BigQuery (INSERT, UPDATE, DELETE, DDL). Changes are permanent.

Bigquery Get Ai Description

Get compact, AI-friendly description of BigQuery project structure.

Bigquery Get Table Schema

Get detailed schema for a BigQuery table.

Bigquery Get Table Stats

Get statistics for a BigQuery table including row count and size.

Bigquery List Datasets

List all datasets in a BigQuery project.

Bigquery List Rows

List rows from a BigQuery table with filtering and pagination.

Bigquery List Tables

List tables in a BigQuery dataset.

Bigquery Preview Table

Preview first N rows from a BigQuery table.

Fetch

Fetch BigQuery table metadata by ID.

Search

Execute SQL queries on BigQuery. Returns query results with column names and values. Maximum 1000 rows.

Frequently Asked Questions

What is the Google BigQuery MCP server?

Google BigQuery is a serverless, highly scalable data warehouse with built-in machine learning capabilities. Run SQL queries on massive datasets, perform real-time analytics, integrate machine learning models, and analyze petabytes of data with automatic scaling and optimization for business intelligence and data science. It provides 10 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect Google BigQuery to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/bigquery. Authentication is handled automatically.

How many tools does Google BigQuery provide?

Google BigQuery provides 10 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does Google BigQuery require?

Google BigQuery uses API Key. Google BigQuery requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect Google BigQuery to any MCP client in minutes

https://mcp.mcpbundles.com/bundle/bigquery

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.

Use this bundle in 3 steps

  1. Copy the MCP URL above
  2. Open your AI tool and add a new MCP/connector
  3. Paste the URL and follow any auth prompts

Claude Desktop Users

Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.

Pick your tool tab for exact steps

Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.

Ready to chat with Google BigQuery?

Same flow: Studio opens on this server after sign-in. Keep chatting to call tools from the conversation.

Google BigQuery MCP Server & Skill — 10 Tools