本文へスキップ
Kitbay
MCPサーバー

mcp-bigquery-server

ローカルで動作MIT2026年5月22日 更新148GitHubスターAPIキーが必要

A local MCP server for BigQuery by Salih Ergüt, sponsored by Oredata, that lets an AI client ask questions of a warehouse without being able to change it.

このサーバーについて

A local MCP server for BigQuery by Salih Ergüt, sponsored by Oredata, that lets an AI client ask questions of a warehouse without being able to change it. Only SELECT statements pass, and each one is checked with a BigQuery dry run before it executes; tables and materialised views can be listed and their schemas read. A simple mode runs straight from npx, while a protected mode reads a config file that caps billed bytes, blocks named sensitive columns and can scan datasets for fields that look like personal or medical data. It runs with npx and needs Google Cloud credentials, either through gcloud or a service-account key.

できること

  • Run read-only SELECT queries on BigQuery
  • List tables and materialised views with their schemas
  • Cap bytes billed per query
  • Block sensitive columns and scan for them automatically