BigQuery MCP Server

Databasestdiov0.9.0
代码仓库

MCP server for Google BigQuery that lets AI agents explore datasets, inspect table schemas, and run SQL analytics queries with dry-run cost estimation. Useful for natural-language data analysis, ad-hoc reporting, and pipeline debugging against large-scale BigQuery warehouses.

bigquerygoogle-cloudsqlanalyticsdata-warehousereporting

连接

将此配置添加到 .claude/mcp.json

{
  "mcpServers": {
    "bigquery": {
      "command": "uvx",
      "args": [
        "bigquery-mcp"
      ],
      "env": {
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>",
        "BIGQUERY_PROJECT": "<YOUR_BIGQUERY_PROJECT>"
      }
    }
  }
}

工具 (3)

execute_query

Run a SQL query against BigQuery and return the result rows.

{
  "type": "object",
  "required": [
    "query"
  ],
  "properties": {
    "query": {
      "type": "string",
      "description": "Standard SQL query to execute"
    },
    "dry_run": {
      "type": "boolean",
      "description": "If true, estimate bytes processed without running the query"
    }
  }
}

list_datasets

List datasets available in the configured GCP project.

{
  "type": "object",
  "properties": {
    "project_id": {
      "type": "string",
      "description": "GCP project ID (defaults to configured project)"
    }
  }
}

get_table_schema

Return the schema of a BigQuery table.

{
  "type": "object",
  "required": [
    "dataset",
    "table"
  ],
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "dataset": {
      "type": "string",
      "description": "Dataset name"
    }
  }
}

资源

此服务器未提供任何资源。

提示词

此服务器未提供任何提示词。

服务器信息

作者
Google Cloud Community (@googleapis)
代码仓库
https://github.com/googleapis/genai-toolbox
许可证
Apache-2.0
版本
0.9.0
星标
1,500
最后更新
2026年6月19日