MCP BigQuery Server

@monochromegane

About MCP BigQuery Server

MCP BigQuery Server is a server that allows you to query BigQuery tables using MCP.

Basic information

Category

Databases

License

MIT license

Runtime

go

Transports

stdio

Publisher

monochromegane

Config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Tools

4

Get a listing of all allowed datasets.

Get a detailed listing of all tables in a specified dataset.

Get the schema of a specified table in a specified dataset.

Dry run a query to get the estimated cost and time.

Overview

What is MCP BigQuery Server?

MCP BigQuery Server is a lightweight server written in Go that allows you to query BigQuery tables using the Model Context Protocol (MCP). It is designed for developers who need to interact with BigQuery datasets through MCP-compatible clients like Cursor.

How to use MCP BigQuery Server?

Install via Homebrew with brew tap monochromegane/tap && brew install monochromegane/tap/mcp-bigquery-server. Then configure it in Cursor by adding a JSON entry to .cursor/mcp.json with the command mcp-bigquery-server start and flags --project and --dataset (repeatable).

Key features of MCP BigQuery Server

List all allowed datasets
List tables in a specified dataset
Get the schema of a specified table
Dry run a query to estimate cost and time

Use cases of MCP BigQuery Server

Discover which BigQuery datasets are available for querying
Explore table listings and schemas within a dataset
Estimate query costs before running a full query
Perform ad‑hoc SQL queries via an MCP‑enabled editor

FAQ from MCP BigQuery Server

What tools does MCP BigQuery Server provide?

It provides four tools: list_allowed_datasets, list_tables, get_table_schema, and dry_run_query.

How do I install MCP BigQuery Server?

Install using Homebrew with brew tap monochromegane/tap && brew install monochromegane/tap/mcp-bigquery-server.

How can I specify multiple datasets?

Pass the --dataset flag multiple times in the configuration, for example --dataset test1 --dataset test2.

What license is MCP BigQuery Server under?

It is licensed under the MIT License.

Comments

More Databases MCP servers

Sail MCP Server for Spark SQL

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

Snowflake MCP Server

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

MongoDB Lens

🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases

Multi Database MCP Server

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.