Bigquery Analysis MCP Server

Run query in bigquery for analytics.

Local serverstdio

What is the Bigquery Analysis MCP Server?

Run query in bigquery for analytics.

What you get

MacOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%/Claude/claude_desktop_config.json

This server is an MCP server for executing SQL queries against Google BigQuery, providing the following features:

Configuration and credentials

  • Node.js (v16 or higher) - Google Cloud authentication setup (gcloud CLI or service account)

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
dry_run_queryPerform a dry run of a BigQuery query
run_query_with_validationRun a BigQuery query with validation

How to install the Bigquery Analysis MCP Server

{
  "mcpServers": {
    "bigquery-analysis-server": {
      "command": "/path/to/bigquery-analysis-server/build/index.js"
    }
  }
}

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

  • Node.js (v16 or higher) - Google Cloud authentication setup (gcloud CLI or service account)

Example prompts to try

  • “Use Bigquery Analysis to dry run query.”
  • “Use Bigquery Analysis to run query with validation.”
  • “Use Bigquery Analysis to Tools.”

Frequently asked questions

Run query in bigquery for analytics. Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.