广告提交登录

BigQuery MCP server

@MCP-Mirror

基本信息

分类

数据库

传输方式

stdio

作者

MCP-Mirror

关于 BigQuery MCP server

Mirror of

#bigquery #mcp-server #data-access

BigQuery MCP server 配置

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

{
  "mcpServers": {
    "LucasHild_mcp-server-bigquery": {
      "command": "uv",
      "args": [
        "sync"
      ]
    }
  }
}

BigQuery MCP server 工具

3

Executes a SQL query using BigQuery dialect

Lists all tables in the BigQuery database

Describes the schema of a specific table

概览

What is BigQuery MCP server?

A Model Context Protocol server that gives LLMs access to Google BigQuery. It lets AI assistants inspect database schemas and execute SQL queries directly against BigQuery datasets.

How to use BigQuery MCP server?

Install via uvx mcp-server-bigquery and configure it in your MCP client (e.g., Claude Desktop) by passing --project (required), --location (required), and optionally --dataset (repeatable). The server runs over stdio and exposes three tools.

Key features of BigQuery MCP server

Execute arbitrary SQL queries using BigQuery dialect
List all tables in the configured project/datasets
Describe the schema of a specific table
Filter which datasets are available to the LLM
Published on PyPI for easy installation

Use cases of BigQuery MCP server

Let an LLM assistant answer natural-language questions by querying BigQuery
Automate schema discovery and documentation generation
Build a natural-language interface for business analysts to explore data
Integrate BigQuery querying into AI-powered coding or analysis workflows

常见问题

1

What tools does BigQuery MCP server provide?

It provides three tools: `execute-query`, `list-tables`, and `describe-table`.

2

How do I restrict which datasets the server can access?

Use the `--dataset` argument (repeatable) to specify one or more datasets. If omitted, all tables in the project are considered.

3

What are the required configuration arguments?

You must provide `--project` (the GCP project ID) and `--location` (the GCP location, e.g. `europe-west9`).

4

Is BigQuery MCP server published on PyPI?

Yes. It can be run via `uvx mcp-server-bigquery` without a local checkout.

5

How can I debug the server?

Use the MCP Inspector. Run `npx @modelcontextprotocol/inspector uv --directory <PATH> run mcp-server-bigquery` to get a debugging URL.

评论

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

Redis MCP Server

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

Sail MCP Server for Spark SQL

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Chroma MCP Server

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers