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.

C
Caution
64/100

BigQuery MCP Server

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

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

Suganthan-Mohanadasan

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

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.

// key findings
⚠️
Known vulnerabilities in dependencies: 3 high
Affects packages this MCP installs at runtime. Upgrade or remove the affected dependency.
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.
// tools this server exposes32 tools

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.

query
query_cost_estimate

Dry-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_datasets

List all datasets in the BigQuery project. Use this first to discover what data is available.

list_tables

List 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_table

Get detailed schema information for a specific BigQuery table including column names, types, descriptions, row count, size, partitioning, and clustering.

sample_rows

Preview sample rows from a table without writing SQL. Useful for quickly understanding what data looks like. Limited to 1GB bytes billed.

gsc_quick_wins
gsc_ctr_opportunities
gsc_content_gaps
gsc_site_snapshot
gsc_content_decay
gsc_cannibalisation
gsc_traffic_drops
gsc_topic_cluster
gsc_ctr_benchmark
gsc_alerts
gsc_content_recommendations
gsc_report
gsc_anonymous_traffic
gsc_seasonal
gsc_device_split
gsc_intent_breakdown
gsc_ngrams
gsc_new_keywords
gsc_forecast
gsc_anomalies
ga4_gsc_page_performance
ga4_gsc_query_revenue
ga4_gsc_content_roi
ga4_gsc_snippet_mismatch
ga4_gsc_position_value
ga4_gsc_branded_performance
// known CVEs in dependencies3 high

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

high@modelcontextprotocol/sdk@1.12.1GHSA-345p-7cg4-v4c7

@modelcontextprotocol/sdk has cross-client data leak via shared server/transport instance reuse

high@modelcontextprotocol/sdk@1.12.1GHSA-8r9q-7v3j-jr4g

Anthropic's MCP TypeScript SDK has a ReDoS vulnerability

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

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

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.
configBIGQUERY_DEFAULT_DATASET"": "searchconsole",
configBIGQUERY_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/).
configBIGQUERY_GA4_LOCATION
configBIGQUERY_GA4_PROJECT
configBIGQUERY_KEY_FILE"": "/path/to/service-account-key.json",
configBIGQUERY_LOCATIONNo Dataset location (default: US). Set to EU, asia-southeast1, etc. if needed.
configBIGQUERY_PROJECT_ID"": "your-project-id",
configGOOGLE_APPLICATION_CREDENTIALSBIGQUERY_KEY_FILE No Path to service account JSON key (falls back to )
// 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

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.

// 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 4 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/suganthan-mohanadasan/suganthans-bigquery-mcp-server?variant=verified)](https://m8ven.ai/mcp/suganthan-mohanadasan/suganthans-bigquery-mcp-server)
Shows verification status without the grade. Want the grade badge instead? Remove ?variant=verified from the URL.
commit: 85c25011b02d60971fe07713fec165fe89d43e90
code hash: a7beb5f38cb32a7b2fbd6166017ddd6fed7f4d1e0ec0b66369ede92196a0b9dd
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