BigQuery
About
(by LucasHild) - BigQuery database integration with schema inspection and query capabilities
Details
- Author
- LucasHild
- GitHub stars
- 128
- Downloads
- 499
- Categories
- Database, Community, Other
Jump to
- Provides three tools: execute-query, list-tables, describe-table
- Configurable via command line arguments or environment variables
- Supports filtering by specific BigQuery datasets
- Can use a service account key file or default credentials
- Optional query timeout setting
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
BigQueryCommand (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 Smithery using npx -y @smithery/cli install mcp-server-bigquery --client claude or configure directly in client configs (Claude Desktop, Claude Code, Cursor). Required configuration: project ID (via --project argument or BIGQUERY_PROJECT env var) and location (via --location or BIGQUERY_LOCATION). Run with uvx mcp-server-bigquery.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"bigquery": {
"mcp-server-bigquery": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp-server-bigquery",
"--client",
"claude"
]
}
}
}
}McpServers
{
"mcp-server-bigquery": {
"command": "npx",
"args": [
"-y",
"@smithery/cli",
"install",
"mcp-server-bigquery",
"--client",
"claude"
]
}
}BigQuery MCP server
A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.
Components
Tools
The server implements one tool:
- execute-query: Executes a SQL query using BigQuery dialect
- list-tables: Lists all tables in the BigQuery database
- describe-table: Describes the schema of a specific table
Configuration
The server can be configured either with command line arguments or environment variables.
| Argument | Environment Variable | Required | Description |
| ------------ | -------------------- | -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| --project | BIGQUERY_PROJECT | Yes | The GCP project ID. |
| --location | BIGQUERY_LOCATION | Yes | The GCP location (e.g. europe-west9). |
| --dataset | BIGQUERY_DATASETS | No | Only take specific BigQuery datasets into consideration. Several datasets can be specified by repeating the argument (e.g. --dataset my_dataset_1 --dataset my_dataset_2) or by joining them with a comma in the environment variable (e.g. BIGQUERY_DATASETS=my_dataset_1,my_dataset_2). If not provided, all datasets in the project will be considered. |
| --key-file | BIGQUERY_KEY_FILE | No | Path to a service account key file for BigQuery. If not provided, the server will use the default credentials. |
| --timeout | BIGQUERY_TIMEOUT | No | Maximum time in seconds to wait for a query to complete. If not provided, queries will wait indefinitely. |
Installation
Installing via Smithery
To install BigQuery Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install mcp-server-bigquery --client claude
Claude Code
claude mcp add bigquery --scope user --transport stdio -- uvx mcp-server-bigquery --project {PROJECT_ID} --location {{LOCATION}}
Claude Desktop
On MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json
{
"mcpServers": {
"bigquery": {
"command": "uvx",
"args": ["mcp-server-bigquery"],
"env": {
"BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
"BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
}
}
}
}
Cursor
1. Open Cursor Settings → MCP
2. Click Add new global MCP server
3. Add an entry for the BigQuery MCP, following the pattern below:
{
"mcpServers": {
"bigquery": {
"command": "uvx",
"args": ["mcp-server-bigquery"],
"env": {
"BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
"BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
}
}
}
}
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
