BigQuery MCP
BigQuery MCP server: list datasets and tables, read schemas, run SELECT queries with a byte limit.
Open the source (opens renzojohnson.com) https://renzojohnson.com/contributions/bigquery-mcp
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: GOOGLE_OAUTH_CLIENT_SECRET, GOOGLE_OAUTH_REFRESH_TOKEN. Use a key with the least access you can.
What it is
MCP servers from com.renzojohnson.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
npm package (stdio)
@renzo.johnson/bigquery-mcp@26.11.14
From the server's entry in the official MCP Registry
Settings it asks for
GOOGLE_APPLICATION_CREDENTIALS· Path to a service account key or authorized_user JSON file. Optional if you use gcloud Application Default Credentials or the OAuth variables.GOOGLE_OAUTH_CLIENT_ID· OAuth client ID. Set together with the client secret and refresh token.GOOGLE_OAUTH_CLIENT_SECRETsecret · OAuth client secret.GOOGLE_OAUTH_REFRESH_TOKENsecret · OAuth refresh token with the BigQuery scopes.BIGQUERY_MCP_PROJECT_ID· Google Cloud project ID used when a request does not name one.BIGQUERY_MCP_MAX_BYTES_BILLED· Largest number of bytes a query may scan (default 1000000000).
Related
-
bigquery-mcp
MCP serversA SnowLeopardAI-managed MCP server that provides access to Google BigQuery data.
sl-bigquery-mcp@0.1.9 -
BigQuery Data Platform
MCP serversRead-only BigQuery tools for plain-language data questions, with a cost gate on every query
data-platform-mcp@0.4.0 -
BigQuery MCP by InsightfulPipe
MCP serversHosted BigQuery MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
-
Claude-Patent-Creator
MCP serversUSPTO patent creation system with MCP server + Claude Code plugin. Hybrid RAG search over MPEP/USC/CFR, BigQuery access to 76M+ patents, automated 35 USC 112 compliance checks, prior art search, diagram generation. GPU-accelerated with skills and autonomous agents.
git clone https://github.com/RobThePCGuy/Claude-Patent-Creator.git -
orionbelt-semantic-layer
MCP serversSource-available semantic and context layer, rule engine, and semantic sidecar for agentic AI and governed analytics. Compiles declarative YAML models into optimized SQL, KPIs, and semantic context across 8 SQL dialects.
git clone https://github.com/ralforion/orionbelt-semantic-layer.git -
mcp-server
MCP serversQuery BigQuery, Snowflake, Redshift & Azure Synapse with natural language