Database · MODEL CONTEXT PROTOCOL

mcp-server-bigquery

A Model Context Protocol server that provides access to BigQuery

打开来源所有 MCP 服务器

连接能力

mcp-server-bigquery 为 AI Agent 提供什么

来源目录未提供结构化功能列表，请在使用前阅读源仓库文档。

安全

MCP 收录不等于安全审核

MCP 服务器可能获得模型上下文、凭据、本地文件或调用外部系统的权限。连接 Agent 前，请检查代码、环境变量、网络行为、软件包来源与维护状态。

README

仓库文档

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

Open Cursor Settings → MCP
Click Add new global MCP server
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}}"
      }
    }
  }
}

在 GitHub 查看 README

社区

收藏、评分与讨论

正在载入社区数据…