Skip to content
MCP server

BigQuery MCP by InsightfulPipe

Hosted BigQuery server: list datasets, read schemas and run Standard SQL

Install
Pricing
Free trial
Platforms
API, CLI, Web
Runs
Remotely
Version
1.0.0
Listing updated
3 days ago

About BigQuery MCP by InsightfulPipe

BigQuery MCP by InsightfulPipe is an MCP server for databases. It runs as a hosted remote server, so there is nothing to install locally.

Five actions are enough to explore and query a warehouse: list_datasets, list_tables, get_table_schema, get_table_metadata and run_query. Metadata covers schema, row count, size, partitioning and expiration, so an assistant can learn an unfamiliar project before writing SQL.

Authentication is a service account JSON key for one Google Cloud project. InsightfulPipe says a single SELECT through run_query counts as a read, while other SQL is a write limited to owners, admins and operators. Queries can wait up to five minutes and return up to 10,000 rows, and the page describes a dry-run step to see bytes processed before spending.

The site compares it with Google's managed BigQuery MCP server, which uses OAuth with IAM roles and returns up to 3,000 rows. The InsightfulPipe version sits in a workspace with ads, analytics and e-commerce connectors and has team roles.

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://bigquery.insightfulmcp.com/
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "bigquery": {
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

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

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "bigquery": {
      "serverUrl": "https://bigquery.insightfulmcp.com/"
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "bigquery": {
      "type": "http",
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}

Tools this server provides (5)

Taken from the project documentation; the running server may differ.

list_datasets
List datasets in the connected project.
list_tables
List tables and views in a dataset.
get_table_schema
Get column names and types.
get_table_metadata
Get schema, row count, size, partitioning and expiration.
run_query
Execute a Standard SQL query and return rows.

What it does

Dataset and table listing
Browse datasets in the connected project and tables inside them.
Schema and metadata
Column types, row count, size, partitioning and expiry.
Standard SQL
Run queries and get rows back, up to 10,000.
Read and write split
SELECT counts as a read; other SQL is limited to privileged roles.
Dry-run cost check
Estimate bytes processed before running.
Service account setup
Connect with a JSON key for one project.

Good for

  • Explore an unfamiliar warehouse
  • Ask a business question and get a summarised result
  • Check a query's cost before running it
  • Read table partitioning and expiry

Pricing

Free trial, from $29.99 a month

Included in InsightfulPipe plans from $29.99 a month, with a trial

Prices change. Check insightfulpipe.com before you buy.

BigQuery MCP by InsightfulPipe FAQ

How do I authenticate?

Upload a service account JSON key for the Google Cloud project.

How many rows can come back?

Up to 10,000, per the comparison table.

Can it write data?

Non-SELECT SQL is treated as a write and limited to owners, admins and operators.

Price?

Included in InsightfulPipe plans from $29.99 a month, with a trial.

Is BigQuery MCP by InsightfulPipe free?

BigQuery MCP by InsightfulPipe is a paid product with a free trial. Paid plans start at $29.99 a month.

How do I add BigQuery MCP by InsightfulPipe to Claude Code?

Run this command in your terminal: claude mcp add --transport http bigquery https://bigquery.insightfulmcp.com/

What are the best alternatives to BigQuery MCP by InsightfulPipe?

The closest alternatives to BigQuery MCP by InsightfulPipe are Agent-Native Analytics, Google Ads + Meta Ads + SEO/GEO MCP, Tapetide - Indian Stock Market MCP, Midplane and World Monitor.

Alternatives to BigQuery MCP by InsightfulPipe

  1. Open-source analytics app where an AI agent builds charts and dashboards from your data

    • Remote
    • Open source
    • 7.7K GitHub stars
    • Analytics and data
  2. Hosted MCP connector for managing Google Ads, Meta Ads, GA4 and Search Console from chat

    • 8 tools
    • Remote
    • Freemium
    • 8.1K GitHub stars
    • Marketing and SEO
  3. Indian NSE and BSE stock market data for AI assistants through 48 MCP tools

    • 17 tools
    • Remote
    • Freemium
    • 150 GitHub stars
    • Finance and payments
  4. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  5. World Monitor

    MCP server

    Live geopolitical intelligence dashboard with an API and MCP server for agents

    • Remote
    • Freemium
    • Analytics and data
  6. CompanyData

    MCP server

    Search and enrich company records from official registers via the CompanyData API

    • 3 tools
    • Remote
    • Paid
    • 3 GitHub stars
    • Analytics and data