# BigQuery MCP by InsightfulPipe

> BigQuery MCP by InsightfulPipe is an MCP server for databases. Hosted BigQuery server: list datasets, read schemas and run Standard SQL. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Free trial
- **Starting price:** $29.99 a month
- **Platforms:** API, CLI, Web
- **Website:** https://insightfulpipe.com/mcp-servers/bigquery
- **Repository:** https://github.com/insightful-pipe/bigquery-mcp-server
- **MCP Registry name:** com.insightfulpipe/bigquery
- **Categories:** databases, analytics and data
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

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

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://bigquery.insightfulmcp.com/
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "bigquery": {
      "url": "https://bigquery.insightfulmcp.com/"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

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

### Windsurf (~/.codeium/windsurf/mcp_config.json)

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

### Other clients (your client's MCP settings (most use this shape))

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

## Tools

- `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.

## 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

- [Agent-Native Analytics](https://ai-powered.com/mcp/agent-native-analytics): Agent-Native Analytics is an open-source MCP server for analytics and data.
- [Google Ads + Meta Ads + SEO/GEO MCP](https://ai-powered.com/mcp/google-ads-meta-ads-seo-geo-mcp): Google Ads + Meta Ads + SEO/GEO MCP is a freemium MCP server for marketing and seo.
- [Tapetide - Indian Stock Market MCP](https://ai-powered.com/mcp/tapetide-indian-stock-market-mcp): Tapetide - Indian Stock Market MCP is a freemium MCP server for finance and payments.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [World Monitor](https://ai-powered.com/mcp/world-monitor): World Monitor is a freemium MCP server for analytics and data.
- [CompanyData](https://ai-powered.com/mcp/companydata): CompanyData is a paid MCP server for analytics and data.
- [ChartAnt](https://ai-powered.com/mcp/chartant): ChartAnt is a freemium MCP server for design and media.
- [Quantivex Research](https://ai-powered.com/mcp/quantivex-research): Quantivex Research is a free MCP server for finance and payments.

---
Source: https://ai-powered.com/mcp/bigquery-mcp-by-insightfulpipe
