MoreAI.tools
B
BigQuery MCP
45
Stack Score
Editorial pick✓ Verified workingMCP server
BigQuery MCP logo

BigQuery MCP

Query Google BigQuery from Claude.

Try BigQuery MCP

Best for

Best for GCP-resident data teams using BigQuery as their warehouse.

At a glance

Pricing
open-source
Setup time
20 minutes
Learning curve
moderate
Last verified
5/27/2026

What we love

  • ✓Cost-preview before run is invaluable
  • ✓Native GCP fit
  • ✓Strong analyst tool

Where it falls short

  • −Service-account setup needed
  • −Cost discipline still important
  • −GCP-only

Install & connect

Copy-paste ready

Install
shell
npx -y mcp-remote https://bigquery.run.tools
Config — Claude Desktop
json
{
  "mcpServers": {
    "bigquery": {
      "command": "npx",
      "args": ["-y", "mcp-remote", "https://bigquery.run.tools"]
    }
  }
}
Config — Claude Code
shell
claude mcp add --transport http bigquery https://bigquery.run.tools

Pricing

✓ Pricing verified Jun 14, 2026

1 tier

Open-source

$0

perpetual

  • ✓Apache 2.0

Overview

MCP server for BigQuery — SELECT, schema, dataset listing, with cost-estimate previews. Auth via service-account JSON.

Key features

  • ●Dataset + table listing
  • ●Cost-aware previews
  • ●Service-account auth
  • ●Read-only mode
  • ●Schema introspection

Exposed tools

The MCP-tool names this server exposes. Your agent can invoke any of these when this server is connected.

  • list_dataset_ids
    List BigQuery dataset IDs in a Google Cloud project.
  • get_dataset_info
    Get metadata about a BigQuery dataset.
  • list_table_ids
    List table IDs in a BigQuery dataset.
  • get_table_info
    Get metadata about a BigQuery table.
  • execute_sql
    Run a SELECT-only SQL query against BigQuery.

Best use cases

BigQuery-grounded analysis

Have Claude run SQL against BigQuery datasets for sourced answers.

Cost-controlled experimentation

Preview cost before running heavy queries during AI-led exploration.

Integrations

BigQuery
GCP
Looker Studio
dbt

Similar tools

See all analytics →
Hotjar
58
Heatmaps, session recordings, and surveys.
Mixpanel
55
Event analytics for product teams.
RudderStack
52
Open-source customer data platform.
Compare side-by-side
BigQuery MCP vs Hotjar vs Mixpanel
Pros, cons, pricing, role-fit — all on one page.
Open comparison

One AI Stack pick every week.

The tool we’d pay for this week, why we’d pay for it, and what we’d skip. No promo spam.