Google BigQuery MCP Server

Enables natural language exploration and querying of Google BigQuery datasets through four tools: listing datasets, inspecting table schemas, generating SQL queries with LLM assistance, and executing approved queries.

→ garethcull/google-bigquery-mcp · listed on glama

Is this your MCP?

Claim it to get a verified publisher badge, a free copy of our full audit findings, and direct contact for any high-priority issues we find.

Install from

Glama

M8ven verifies MCPs across every public registry — install directly from whichever one you prefer.

// key findings

✅

No credential exfiltration, no sensitive file access, no obfuscation

Static analysis found nothing flowing your secrets to unexpected places.

✅

Open source with a license and README

Anyone can audit the code, the license is declared, and the publisher documents what it does.

🔐

You'll be asked for 3 credentials: MCP_TOKEN, GCP_BQ_BASE64_KEY, GOOGLE_AI_KEY

These are read from process.env at runtime. Make sure you trust where they’ll be sent.

// required environment variables

This server reads these from process.env. You'll be asked to provide them before it can run.

🔐 secretMCP_TOKEN— This server requires authorization via a shared token (). All requests to the /mcp endpoint must include a Bearer token in the Authorization header.

🔐 secretGCP_BQ_BASE64_KEY— 1. - This is a base64‑encoded Google Cloud service account key. Users must encode their JSON key file as base64 before running the MCP server. You can find this referenced in mcp_helper.py.

🔐 secretGOOGLE_AI_KEY— 2. - This is your Gemini API key, which is used to call Gemini 2.5 Flash for SQL generation via natural language. You can find this referenced in mcp_helper.py.

// full audit trail

The full breakdown of what we checked, the deductions that landed, the network hosts, the dependency advisories, and concrete fix guidance is available to verified publishers.

// improvement guidance — verified publishers only

We have 1 concrete improvement we can share with the publisher of this MCP. Each comes with specific guidance to raise the trust score.

// embed badge in your README

[![M8ven Score](https://m8ven.ai/badge/mcp/garethcull-google-bigquery-mcp-fbq1xm)](https://m8ven.ai/mcp/garethcull-google-bigquery-mcp-fbq1xm)

commit: b629d20ed4094194008677c6e063c7650fc6d53d

code hash: 25f6db0d6bf81b734fc98c3017e9bd8b536af8568fa5840f38d971fc7d3dc9cd

verified: 6/17/2026, 12:39:47 PM

view raw JSON →