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
Последнее обновление
19 июня 2026 г.