MCP BigQuery Server (rodneyelmore/bigquery-mcp-server) is an MCP server listed on the M8ven Trust Index. M8ven has not graded it: we have no way to read this server ourselves. No publisher has claimed this listing.

C
Caution
74/100
9 days ago

MCP BigQuery Server

Production-ready MCP server for BigQuery that translates natural language questions to SQL, executes queries securely, and delivers results via stdio or HTTP for integration with GitHub Copilot, Power BI, and web applications.

Caution. Specific findings reduced this grade. They are listed on the page. Grades reflect the full trust pyramid: code, verification depth, and reputation. New projects cap at C until adoption is earned.

How we verified

Code Verified⚡ Live Monitored: not connected

Verified is a snapshot. Live keeps it current, and builds your track record.

⚡ Connect GitHub → continuous verification on every pushwhy connect →

Who stands behind it

rodneyelmore

Source: 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. Or connect your repo for our deepest verification, Live Monitored: read-only, revoke anytime. What we access →

Install from

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

// key findings
🚨
Known vulnerabilities in dependencies: 2 critical, 1 high
Affects packages this MCP installs at runtime. Upgrade or remove the affected dependency.
🔐
You'll be asked for 4 credentials: AZURE_CLIENT_SECRET, AZURE_OPENAI_API_KEY, KV_SECRET_AOAI_KEY, REDIS_PASSWORD
These are read from process.env at runtime. Make sure you trust where they’ll be sent.
// known CVEs in dependencies2 critical1 high4 low

Disclosed vulnerabilities in this server's declared npm dependencies (via OSV). Whether each is reachable depends on the installed versions.

criticalvitest@1.2.2GHSA-5xrq-8626-4rwp

When Vitest UI server is listening, arbitrary file can be read and executed

criticalvitest@1.2.2GHSA-9crc-q9x8-hgqq

Vitest allows Remote Code Execution when accessing a malicious website while Vitest API server is listening

high@modelcontextprotocol/sdk@1.0.0GHSA-w48q-cv73-mx4w

Model Context Protocol (MCP) TypeScript SDK does not enable DNS rebinding protection by default

low@azure/identity@4.0.1GHSA-m5vv-6r4h-3vj9

Azure Identity Libraries and Microsoft Authentication Library Elevation of Privilege Vulnerability

lowexpress@4.18.2GHSA-qw6h-vgh9-j6wx

express vulnerable to XSS via response.redirect()

Depend on this server? Get alerted when its CVEs change.Watch this server free →
// environment variables
To run this server yourself, you supply these values. They go in your own MCP client configuration and stay on your machine. The secret label means the value is sensitive, not that the server mishandles it.
configALLOWED_DATASETS"": "dataset1,dataset2",
configALLOWED_ORIGINS
configAZURE_CLIENT_ID
🔐 secretAZURE_CLIENT_SECRET
configAZURE_KEY_VAULT_URI
🔐 secretAZURE_OPENAI_API_KEY"": "your-key"
configAZURE_OPENAI_API_VERSION
configAZURE_OPENAI_DEPLOYMENTgpt-4o-mini
configAZURE_OPENAI_ENDPOINT"": "https://your-openai.openai.azure.com/",
configAZURE_TENANT_ID
configCACHE_TTL_SEC
configENABLE_CORS
configENABLE_METRICS
configENABLE_TRACING
configGCP_BQ_LOCATION
configGCP_IMPERSONATE_SA
configGCP_PROJECT_ID"": "your-project-id",
configGCP_SA_KEY_JSON"": "{...}",
configHELMET_CSP
configJWKS_URICheck JWT_ISSUER, JWT_AUDIENCE, and configuration
configJWT_AUDIENCEapi://your-app-id
configJWT_ISSUERCheck , JWT_AUDIENCE, and JWKS_URI configuration
🔐 secretKV_SECRET_AOAI_KEY
configKV_SECRET_BQ_SA_JSON
configLOG_LEVEL
configMAX_ROWS_ABSOLUTE
configMAX_ROWS_DEFAULT
configMCP_MODE
configOTEL_EXPORTER_OTLP_ENDPOINT
configOTEL_SERVICE_NAME
configQUERY_TIMEOUT_MS
configRATE_LIMIT_MAX_REQUESTS
configRATE_LIMIT_WINDOW_MS
🔐 secretREDIS_PASSWORD
configUSE_MANAGED_IDENTITY
Deployment configuration, supplied by whoever hosts the server. Users are not asked for these.
deployPORT
deployREDIS_URL
// quality suggestions

Tool annotations

No tools have read-only/destructive annotations

Add readOnlyHint or destructiveHint annotations to every tool so hosts can warn users before invoking.

All four hints declared on every tool

2/2 tools missing one or more hints — ask_bigquery (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); sql_query (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint). OpenAI's directory rejects tools where any of the four hints are missing or non-boolean.

For every tool, set all four hints (readOnlyHint, destructiveHint, idempotentHint, openWorldHint) to explicit true/false values that match the handler’s actual behaviour.

Tool test coverage

Only 0/2 tools referenced in tests (0%)

Write tests that reference each tool by name so every tool has at least one test.

Production dependencies are patched

0 critical, 1 high severity in production deps — @modelcontextprotocol/sdk@1.0.0 (high), @azure/identity@4.0.1 (low)

Run npm audit fix, or upgrade the affected packages to a non-vulnerable version.

Dev dependencies

2 critical/high in dev-only deps (does not ship to users)

Upgrade dev dependencies when convenient.

Claim the listing to review these findings one by one and send us a correction where you disagree, straight to the team. Claiming also means we tell you when the grade moves, and reach you first if we find anything urgent.

// full audit trail
The findings above are the summary. The full trail, every check we ran, each deduction, the network hosts observed and the dependency advisories, goes to verified publishers, along with an alert whenever a new one lands. Verified publishers can also review each finding and dispute it in one click. Publisher corrections have sharpened several of our checks this month, because the maintainer knows the codebase better than any scanner.
// improvement guidance — verified publishers only
We have 5 concrete improvements 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 Verified](https://m8ven.ai/badge/mcp/rodneyelmore-bigquery-mcp-server-09srz9?variant=verified)](https://m8ven.ai/mcp/rodneyelmore-bigquery-mcp-server-09srz9)
Shows verification status without the grade. Want the grade badge instead? Remove ?variant=verified from the URL.
commit: 2803a4b5f80481164e8fe4c495842d5a557c15d5
code hash: 77eb125446f2cb3b577d0cbcb110abc0740f0593853db314f7303370800f01ee
verified: 8/22/2026, 1:56:35 AM
view raw JSON →
Check MCPs from inside your assistant
Tool Check · MCP

Vetting this one by hand? Tool Check is an MCP that scores other MCPs. Add it once and ask Claude, ChatGPT, or any MCP client to grade a server, surface CVEs, check the publisher, and suggest safer alternatives — before you install.

https://m8ven.ai/api/mcp/tool-check
check_toolsearch_toolscompare_toolsrecommend_alternativescheck_publisherreport_concern
How to add it →Free · no account needed · works in any MCP client