BigQuery MCP Server
Description
# BigQuery MCP Server A Model Context Protocol (MCP) server for accessing Google BigQuery. This server enables Large Language Models (LLMs) to understand BigQuery dataset structures and execute SQL queries. ## Features ### Authentication and Connection Management - Supports…
About
# BigQuery MCP Server A Model Context Protocol (MCP) server for accessing Google BigQuery. This server enables Large Language Models (LLMs) to understand BigQuery dataset structures and execute SQL queries. ## Features ### Authentication and Connection Management - Supports Application Default Credentials (ADC) or…
Details
- Author
- takuya0206
- Downloads
- 150
- Categories
- Database, Other
Jump to
- Execute read-only SELECT queries with configurable limits
- List all datasets in a project
- List tables with schemas for a given dataset
- Retrieve table schema and sample data (up to 20 rows)
- Dry-run queries to estimate cost without execution
- Supports Application Default Credentials or service account key files
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
BigQuery MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install via local build (bun install, bun run build) or Docker. Configure the server with --project-id, --location, --max-results, --max-bytes-billed, and optionally a --key-file for service account authentication. Add the server to your MCP client configuration with the path to the binary and arguments.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"bigquery mcp server": {
"bigquery-mcp-server": {
"command": "bun",
"args": [
"run",
"build"
]
}
}
}
}McpServers
{
"bigquery-mcp-server": {
"command": "bun",
"args": [
"run",
"build"
]
}
}BigQuery MCP Server
A Model Context Protocol (MCP) server for accessing Google BigQuery. This server enables Large Language Models (LLMs) to understand BigQuery dataset structures and execute SQL queries.
Features
Authentication and Connection Management
- Supports Application Default Credentials (ADC) or service account key files - Configurable project ID and location settings - Authentication verification on startupTools
1. query
- Execute read-only (SELECT) BigQuery SQL queries
- Configurable maximum results and bytes billed
- Security checks to prevent non-SELECT queries
2. list_all_datasets
- List all datasets in the project
- Returns an array of dataset IDs
3. list_all_tables_with_dataset
- List all tables in a specific dataset with their schemas
- Requires a datasetId parameter
- Returns table IDs, schemas, time partitioning information, and descriptions
4. get_table_information
- Get table schema and sample data (up to 20 rows)
- Support for partitioned tables with partition filters
- Warnings for queries on partitioned tables without filters
5. dry_run_query
- Check query validity and estimate cost without execution
- Returns processing size and estimated cost
Security Features
- Only SELECT queries are allowed (read-only access) - Default limit of 500GB for query processing to prevent excessive costs - Partition filter recommendations for partitioned tables - Secure handling of authentication credentialsInstallation
Local Installation
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
