広告掲載
MCP.so
ログイン

BigQuery MCP Server

@ergut

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

ergut

BigQuery MCP Server について

A Model Context Protocol (MCP) server that provides secure, read-only access to BigQuery datasets. Enables Large Language Models (LLMs) to safely query and analyze data through a standardized interface.

#bigquery#sql#mcp#google-cloud#model-context-protocol#mcp-servers

BigQuery MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mcp-bigquery-server": {
      "command": "npx",
      "args": [
        "@ergut/mcp-bigquery-server",
        "--project-id",
        "your-project-id",
        "--location",
        "europe-west1",
        "--key-file",
        "/path/to/key.json",
        "--config-file",
        "/path/to/config.json",
        "--maximum-bytes-billed",
        "2000000000"
      ]
    }
  }
}

BigQuery MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is BigQuery MCP Server?

BigQuery MCP Server lets LLMs like Claude talk directly to your BigQuery data — read-only, with no ability to mutate your warehouse. It uses the Model Context Protocol (MCP) to translate natural language into safe SQL queries, making it ideal for AI‑assisted data exploration.

How to use BigQuery MCP Server?

Set up authentication (gcloud auth application-default-login or a service account key file), then add the server to your MCP client’s config (e.g., claude_desktop_config.json or .mcp.json). Run via npx @ergut/mcp-bigquery-server with flags such as --project-id, --location, --key-file, and --config-file. Once configured, open your client and chat with your data in plain English.

Key features of BigQuery MCP Server

  • Read-only by design — only SELECT statements are allowed.
  • Run SQL queries by asking questions in plain English.
  • Access both tables and materialized views with schema exploration.
  • Configurable safe limits via config.json or command line.
  • Protect sensitive data with field‑level restrictions.
  • Auto‑discover sensitive columns across all datasets.

Use cases of BigQuery MCP Server

  • Ask “What were our top 10 customers last month?” and get an answer in plain English.
  • Explore dataset schemas without writing any SQL.
  • Query BigQuery from AI assistants while preventing exposure of PII/PHI.
  • Automatically scan for and restrict sensitive fields across the entire warehouse.

よくある質問

1

What are the prerequisites to run the server?

You need Node.js 14+, a Google Cloud project with BigQuery enabled, and an MCP‑compatible client (e.g., Claude Desktop or Claude Code).

2

How do I authenticate with Google Cloud?

Use `gcloud auth application-default-login` for development or provide a service account key file via the `--key-file` argument for production.

3

Does the server modify my BigQuery data?

No. The server is read‑only — only `SELECT` statements are allowed. Every query is validated by BigQuery’s dry‑run planner, so mutations are rejected.

4

How can I protect sensitive data from the AI agent?

Define `preventedFields` in `config.json` to block specific columns, and enable auto‑scanning to automatically discover and restrict sensitive fields across all datasets.

5

What are the main limitations?

Processing limits are configurable per query. Some complex view types may not be supported. A config file is optional; without one the server uses safe defaults.

コメント

「データベース」の他のコンテンツ

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

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
広告掲載