mcp-bigquery-server

What it does

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.

Capabilities

Details