BigQuery MCP Server

Databasestdiov0.9.0
Repositorio

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

Conectar

Añade esta configuración a .claude/mcp.json

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

Herramientas (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"
    }
  }
}

Recursos

Este servidor no expone ningún recurso.

Prompts

Este servidor no expone ningún prompt.

Información del servidor

Autor
Google Cloud Community (@googleapis)
Repositorio
https://github.com/googleapis/genai-toolbox
Licencia
Apache-2.0
Versión
0.9.0
Estrellas
1,500
Última actualización
19 de junio de 2026