pvoo/bigquery-mcp
Practical MCP server for large BigQuery datasets. Supports vector search. Keep LLM context small while staying fast and allowing only safe read-only actions.
Implements MCP (Model Context Protocol) as a stdio-based server with dual-mode tools that minimize token usage by defaulting to lightweight responses—basic dataset listings return names only, detailed metadata loads on-demand. Enforces read-only safety through query validation (SELECT/WITH statements only) and automatic cost tracking with a ~$0.50 per-query billing cap. Integrates with BigQuery's Vertex AI embeddings for semantic vector search and supports dataset access control via allowlisting.
Available on PyPI.
Stars
8
Forks
2
Language
Python
License
MIT
Category
Last pushed
Dec 11, 2025
Monthly downloads
773
Commits (30d)
0
Dependencies
3
Get this data via API
curl "https://pt-edge.onrender.com/api/v1/quality/mcp/pvoo/bigquery-mcp"
Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.
Compare
Higher-rated alternatives
dbt-labs/dbt-mcp
A MCP (Model Context Protocol) server for interacting with dbt.
kubeflow/mcp-apache-spark-history-server
MCP Server for Apache Spark History Server. The bridge between Agentic AI and Apache Spark.
HatriGt/hana-mcp-server
SAP HANA MCP server — Model Context Protocol server for SAP HANA. Use with Claude Code, VS Code....
ktanaka101/mcp-server-duckdb
A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction...
redis/mcp-redis
The official Redis MCP Server is a natural language interface designed for agentic applications...