广告合作
MCP.so
登录

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.

常见问题

1

What LLMs does this server work with?

Currently only Claude Desktop in developer preview.

2

What are the prerequisites?

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

3

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.

4

Is the data accessed read-only?

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

评论

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K
广告合作