MCP BigQuery Server logo

MCP BigQuery Server

by monochromegane

MCP BigQuery Server allows you to query BigQuery tables using MCP. It is written in Go and is lightweight and easy to install.

View on GitHub

Last updated: N/A

What is MCP BigQuery Server?

MCP BigQuery Server is a server that enables querying BigQuery tables through MCP (presumably Metadata Completion Protocol). It provides tools to interact with BigQuery datasets and tables.

How to use MCP BigQuery Server?

First, install the server using brew tap monochromegane/tap and brew install monochromegane/tap/mcp-bigquery-server. Then, register the server in your .cursor/mcp.json configuration file, specifying the command to run the server and the datasets to allow access to.

Key features of MCP BigQuery Server

  • List allowed datasets

  • List tables in a dataset

  • Get table schema

  • Dry run queries for cost estimation

Use cases of MCP BigQuery Server

  • Querying BigQuery data through MCP

  • Exploring BigQuery datasets and tables

  • Integrating BigQuery with Cursor or other MCP-compatible tools

  • Estimating query costs before execution

FAQ from MCP BigQuery Server

What is MCP?

MCP is likely Metadata Completion Protocol, but further context is needed for a precise definition.

How do I specify multiple datasets?

You can specify multiple datasets by repeating the --dataset argument in the configuration.

What programming language is this server written in?

This server is written in Go.

What is the license for this server?

This server is licensed under the MIT license.

Where can I find the source code?

The source code is available on GitHub at https://github.com/monochromegane/mcp-bigquery-server