convez.ai
MCP ServerDados & AnalyticsIntermediário
LucasHild

MCP Server BigQuery

LucasHild/mcp-server-bigquery

Integre BigQuery ao Claude via MCP para análise e consultas de dados

Ver no GitHub
BomPluginScore · de 0 a 100

Servidor MCP que integra Claude com BigQuery, permitindo inspeção de schemas e execução de queries SQL. Oferece ferramentas para listar tabelas, descrever esquemas e executar consultas direto do BigQuery.

Instalação

$npx convez-ai LucasHild/mcp-server-bigquery

1 comando no terminal: detecta o formato do repositório (marketplace ou plugin avulso) e instala via Claude Code. Requer Node 18+ e o Claude Code instalado.

Métricas

Estrelas
131
Forks
41
Acompanhando
3
Saúde
57%
Último commit
há 1 semana
Versão
v0.3.3
Issues abertas
0
Contribuidores
5

Casos de uso

  • Explorar schemas e estruturas de tabelas em BigQuery
  • Executar queries SQL complexas e analisar resultados
  • Automatizar extração e análise de dados para relatórios
  • Debugar e validar consultas BigQuery com assistência de IA

Veredito

MCP server robusto e bem documentado para integração BigQuery-Claude. Cobre os casos essenciais (query, list, describe) com configuração flexível via CLI ou env vars. Ideal para equipes que trabalham com data warehousing no GCP.

README

A tradução para o português deste README ainda está na fila.

BigQuery MCP server

smithery badge

A Model Context Protocol server that provides access to BigQuery. This server enables LLMs to inspect database schemas and execute queries.

Components

Tools

The server implements one tool:

  • execute-query: Executes a SQL query using BigQuery dialect
  • list-tables: Lists all tables in the BigQuery database
  • describe-table: Describes the schema of a specific table

Configuration

The server can be configured either with command line arguments or environment variables.

ArgumentEnvironment VariableRequiredDescription
--projectBIGQUERY_PROJECTYesThe GCP project ID.
--locationBIGQUERY_LOCATIONYesThe GCP location (e.g. europe-west9).
--datasetBIGQUERY_DATASETSNoOnly take specific BigQuery datasets into consideration. Several datasets can be specified by repeating the argument (e.g. --dataset my_dataset_1 --dataset my_dataset_2) or by joining them with a comma in the environment variable (e.g. BIGQUERY_DATASETS=my_dataset_1,my_dataset_2). If not provided, all datasets in the project will be considered.
--key-fileBIGQUERY_KEY_FILENoPath to a service account key file for BigQuery. If not provided, the server will use the default credentials.
--timeoutBIGQUERY_TIMEOUTNoMaximum time in seconds to wait for a query to complete. If not provided, queries will wait indefinitely.

Installation

Installing via Smithery

To install BigQuery Server for Claude Desktop automatically via Smithery:

npx -y @smithery/cli install mcp-server-bigquery --client claude

Claude Code

claude mcp add bigquery --scope user --transport stdio -- uvx mcp-server-bigquery --project {PROJECT_ID} --location {{LOCATION}}

Claude Desktop

On MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
On Windows: %APPDATA%/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "bigquery": {
      "command": "uvx",
      "args": ["mcp-server-bigquery"],
      "env": {
        "BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
        "BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
      }
    }
  }
}

Cursor

  1. Open Cursor Settings → MCP
  2. Click Add new global MCP server
  3. Add an entry for the BigQuery MCP, following the pattern below:
{
  "mcpServers": {
    "bigquery": {
      "command": "uvx",
      "args": ["mcp-server-bigquery"],
      "env": {
        "BIGQUERY_PROJECT": "{{GCP_PROJECT_ID}}",
        "BIGQUERY_LOCATION": "{{GCP_LOCATION}}"
      }
    }
  }
}
Ver o original no GitHub

Bom para

Relacionados