ergut/mcp-bigquery-server

Overview

A Model Context Protocol (MCP) server that provides secure, read-only access to BigQuery datasets. It enables Large Language Models (LLMs) to safely query and analyze data through a standardized interface.

Best for

Best for
Developers who need to give LLMs safe, structured access to BigQuery data

Use cases

• Let an LLM run read-only SQL queries on BigQuery tables
• Give an AI assistant access to business data for analysis
• Integrate BigQuery with MCP-compatible tools and agents

Notes

A Model Context Protocol (MCP) server that provides secure, read-only access to BigQuery datasets. It enables Large Language Models (LLMs) to safely query and analyze data through a standardized interface.

140 stars on GitHub. Last updated 2026-05-22. Licensed MIT.

Use cases

• Let an LLM run read-only SQL queries on BigQuery tables
• Give an AI assistant access to business data for analysis
• Integrate BigQuery with MCP-compatible tools and agents

Pros

• Read-only design prevents accidental data modification
• Standard MCP interface works with many LLM frameworks
• Written in TypeScript for type safety and easy integration

Cons

• Limited to read-only queries, no write or DDL operations
• Requires BigQuery credentials and network access to Google Cloud
• MCP ecosystem still maturing, fewer clients than REST APIs

Indexed from awesome-mcp-servers-punkpeye and enriched against its public facts.