BigQuery MCP Server (Suganthan-Mohanadasan/Suganthans-BigQuery-MCP-Server) is an MCP server listed on the M8ven Trust Index. It scores 64 out of 100, grade C. It declares 32 tools. No publisher has claimed this listing.
An MCP server for BigQuery that lets Claude answer questions about your search and analytics data, providing real analysis with verdicts and recommendations, not just raw query results.
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
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
Suganthan-Mohanadasan
Source: Glama
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
The grade above is for the source repository. Registries can serve a different version, so we mark the ones we were not able to read.
These names and descriptions are the publisher's own, read from the source code. We print them as written. Our assessment is the findings above, not this list.
queryquery_cost_estimateDry-run a SQL query to see how many bytes it would scan without actually executing it. Use this before running expensive queries to check cost.
list_datasetsList all datasets in the BigQuery project. Use this first to discover what data is available.
list_tablesList all tables in a BigQuery dataset with their schemas. Uses INFORMATION_SCHEMA for efficiency. Use this to understand what tables and columns are available before writing queries.
describe_tableGet detailed schema information for a specific BigQuery table including column names, types, descriptions, row count, size, partitioning, and clustering.
sample_rowsPreview sample rows from a table without writing SQL. Useful for quickly understanding what data looks like. Limited to 1GB bytes billed.
gsc_quick_winsgsc_ctr_opportunitiesgsc_content_gapsgsc_site_snapshotgsc_content_decaygsc_cannibalisationgsc_traffic_dropsgsc_topic_clustergsc_ctr_benchmarkgsc_alertsgsc_content_recommendationsgsc_reportgsc_anonymous_trafficgsc_seasonalgsc_device_splitgsc_intent_breakdowngsc_ngramsgsc_new_keywordsgsc_forecastgsc_anomaliesga4_gsc_page_performancega4_gsc_query_revenuega4_gsc_content_roiga4_gsc_snippet_mismatchga4_gsc_position_valuega4_gsc_branded_performanceDisclosed vulnerabilities in this server's declared npm dependencies (via OSV). Whether each is reachable depends on the installed versions.
@modelcontextprotocol/sdk has cross-client data leak via shared server/transport instance reuse
Anthropic's MCP TypeScript SDK has a ReDoS vulnerability
Model Context Protocol (MCP) TypeScript SDK does not enable DNS rebinding protection by default
BIGQUERY_DEFAULT_DATASET"": "searchconsole",BIGQUERY_GA4_DATASETRequire the GA4 BigQuery export running alongside GSC in the same project. Set (or pass ga4_dataset per call). [Full setup guide](https://suganthan.com/blog/google-analytics-bigquery-mcp-server/).BIGQUERY_GA4_LOCATIONBIGQUERY_GA4_PROJECTBIGQUERY_KEY_FILE"": "/path/to/service-account-key.json",BIGQUERY_LOCATIONNo Dataset location (default: US). Set to EU, asia-southeast1, etc. if needed.BIGQUERY_PROJECT_ID"": "your-project-id",GOOGLE_APPLICATION_CREDENTIALSBIGQUERY_KEY_FILE No Path to service account JSON key (falls back to )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
32/32 tools missing one or more hints — query (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); query_cost_estimate (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint); list_datasets (missing: readOnlyHint, destructiveHint, idempotentHint, openWorldHint), +29 more. 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.
Tests exist
No test files found
Add tests that exercise each declared tool.
Production dependencies are patched
0 critical, 3 high severity in production deps — @modelcontextprotocol/sdk@1.12.1 (high), @modelcontextprotocol/sdk@1.12.1 (high)
Run npm audit fix, or upgrade the affected packages to a non-vulnerable version.
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.
[](https://m8ven.ai/mcp/suganthan-mohanadasan/suganthans-bigquery-mcp-server)?variant=verified from the URL.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