BigQuery MCP Server

Name: BigQuery MCP Server
Author: takuya0206

@takuya0206

代码仓库

关于 BigQuery MCP Server

暂无概览

基本信息

分类

数据库

许可证

MIT license

运行时

node

传输方式

stdio

发布者

takuya0206

配置

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

{
  "mcpServers": {
    "bigquery-mcp-server": {
      "command": "bun",
      "args": [
        "run",
        "build"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is BigQuery MCP Server?

A Model Context Protocol (MCP) server that enables Large Language Models to access Google BigQuery. It supports dataset discovery, schema exploration, and read-only SQL query execution.

How to use BigQuery MCP Server?

Install via local build (bun install, bun run build) or Docker. Configure the server with --project-id, --location, --max-results, --max-bytes-billed, and optionally a --key-file for service account authentication. Add the server to your MCP client configuration with the path to the binary and arguments.

Key features of BigQuery MCP Server

Execute read-only SELECT queries with configurable limits
List all datasets in a project
List tables with schemas for a given dataset
Retrieve table schema and sample data (up to 20 rows)
Dry-run queries to estimate cost without execution
Supports Application Default Credentials or service account key files

Use cases of BigQuery MCP Server

LLMs exploring BigQuery dataset structures and schemas
Running safe, read-only SQL queries via natural language
Estimating query costs before executing large queries
Inspecting partitioned tables and their partitions
Programmatic dataset and table discovery within a project

FAQ from BigQuery MCP Server

What authentication methods are supported?

The server supports Application Default Credentials (ADC) and service account key files. ADC is set up via gcloud auth application-default login.

What BigQuery permissions are required?

The recommended role is roles/bigquery.user. Alternatively, both roles/bigquery.dataViewer and roles/bigquery.jobUser are needed.

Are write queries allowed?

No. Only SELECT queries are permitted; the server performs security checks to reject non-SELECT statements.

What is the default query processing limit?

A default limit of 500 GB is set for query processing to prevent excessive costs. This can be changed via --max-bytes-billed.

Can I run the server in a Docker container?

Yes. Build the Docker image with docker build -t bigquery-mcp-server . and run it with docker run -it --rm bigquery-mcp-server --project-id=your-project-id.

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

MongoDB MCP Server

mongodb-js

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

1.1K

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245