mcp-server-bigquery and bigquery-mcp
About mcp-server-bigquery
LucasHild/mcp-server-bigquery
A Model Context Protocol server that provides access to BigQuery
Exposes three tools for LLM interaction: `execute-query` for BigQuery SQL execution, `list-tables` for schema discovery, and `describe-table` for inspecting column definitions. Communicates via stdio transport and integrates directly with Claude Desktop and Cursor through MCP configuration, supporting GCP authentication via service account keys or default credentials. Supports dataset filtering and configurable query timeouts to control execution scope and resource consumption.
About bigquery-mcp
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.
Related comparisons
Scores updated daily from GitHub, PyPI, and npm data. How scores work