BigQuery MCP Server

@MCP-Mirror

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

MCP-Mirror

关于 BigQuery MCP Server

Mirror of

#bigquery #llm#data-communication

BigQuery MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "ergut_mcp-bigquery-server": {
      "command": "npx",
      "args": [
        "@smithery/cli",
        "install",
        "@ergut/mcp-bigquery-server",
        "--client",
        "claude"
      ]
    }
  }
}

BigQuery MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is BigQuery MCP Server?

It is a server that connects LLMs like Claude to BigQuery via the Model Context Protocol, allowing natural language queries to databases. It acts as a secure translator between AI assistants and BigQuery data.

How to use BigQuery MCP Server?

Install via Smithery by running npx @smithery/cli install @ergut/mcp-bigquery-server --client claude or manually by adding a configuration to Claude Desktop's claude_desktop_config.json. Provide your Google Cloud project ID, location (defaults to us-central1), and optionally a service account key file. Then start asking questions in Claude Desktop.

Key features of BigQuery MCP Server

Translate natural language questions into SQL queries.
Access both tables and materialized views in datasets.
Explore dataset schemas with labeled resource types.
Enforce a 1GB query limit for safe analysis.
Read-only access ensures data security.
Integrates with MCP, available in Claude Desktop.

Use cases of BigQuery MCP Server

Ask business questions like "top 10 customers last month" without writing SQL.
Explore database schema and tables through natural language.
Generate ad-hoc reports by chatting with your data.
Enable non-technical users to query BigQuery.

常见问题

What LLMs does this server work with?

Currently only Claude Desktop in developer preview.

What are the prerequisites?

Node.js 14+, a Google Cloud project with BigQuery enabled, and either Google Cloud CLI or a service account key.

How does authentication work?

You can use Google Cloud CLI (`gcloud auth application-default login`) for development or supply a service account key file with `--key-file` for production.

Is the data accessed read-only?

Yes, queries are read-only with a default 1GB processing limit

数据库分类下的更多 MCP 服务器

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi