BigQuery MCP Server
by MCP-Mirror
A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.
Last updated: N/A
What is BigQuery MCP Server?
The BigQuery MCP server is a Model Context Protocol server that allows Large Language Models (LLMs) to interact with and query BigQuery databases. It provides tools for LLMs to understand database schemas and execute SQL queries.
How to use BigQuery MCP Server?
To use the server, configure it with the required GCP project ID and location. Optionally, specify specific BigQuery datasets to consider. Then, configure your LLM environment (e.g., Claude Desktop) with the server's command and arguments, replacing placeholders with your actual values. The provided configuration snippets show how to configure the server for both development and published versions.
Key features of BigQuery MCP Server
Execute SQL queries using BigQuery dialect
List all tables in the BigQuery database
Describe the schema of a specific table
Configurable with GCP project ID, location, and dataset filters
Use cases of BigQuery MCP Server
Allowing LLMs to answer questions based on data in BigQuery
Enabling LLMs to generate reports from BigQuery data
Providing LLMs with the ability to explore and understand BigQuery schemas
Integrating BigQuery data into LLM-powered applications
FAQ from BigQuery MCP Server
What is MCP?
What is MCP?
MCP stands for Model Context Protocol, a standard for allowing LLMs to interact with external tools and data sources.
What GCP permissions are required?
What GCP permissions are required?
The server requires permissions to access BigQuery, including the ability to list datasets, list tables, describe table schemas, and execute queries.
How do I specify multiple datasets?
How do I specify multiple datasets?
You can specify multiple datasets by repeating the --dataset argument, e.g., --dataset my_dataset_1 --dataset my_dataset_2.
How do I debug the server?
How do I debug the server?
The README recommends using the MCP Inspector for debugging, which can be launched using npx @modelcontextprotocol/inspector uv --directory {{PATH_TO_REPO}} run mcp-server-bigquery.
Where can I find the MCP Inspector?
Where can I find the MCP Inspector?
The MCP Inspector is available at https://github.com/modelcontextprotocol/inspector.