Suganthans BigQuery MCP Server
UnclaimedBigQuery MCP server for Claude — query any BigQuery dataset in natural language, with built-in SEO analysis tools for GSC bulk export data
Unclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverTools (33)
describe_table
Column types, row counts, partitioning, size.
ga4_gsc_branded_performance
How does branded vs non-branded traffic convert?
ga4_gsc_content_roi
Which pages have the biggest gap between rankings and conversions? Diagnoses each page.
ga4_gsc_page_performance
Full page-level search + analytics metrics joined per landing page.
ga4_gsc_position_value
What is each search position worth on your site? Conversion rate and revenue per click by position bucket.
ga4_gsc_query_revenue
Which search queries actually drive revenue and conversions? Proportional attribution by click share.
ga4_gsc_snippet_mismatch
Which pages have misleading or underselling snippets?
gsc_alerts
Position drops, CTR collapses, click losses, disappeared pages. Severity rated
gsc_anomalies
ML anomaly detection. Flags genuinely unusual traffic patterns, not just threshold breaches.
gsc_anonymous_traffic
How much traffic is hidden behind anonymous queries? The API hides ~46% of clicks entirely.
gsc_cannibalisation
Keywords where multiple pages compete against each other
gsc_content_decay
Pages declining across three consecutive 30 day periods
gsc_content_gaps
Topics with search demand but no real content targeting them
gsc_content_recommendations
Prioritised actions: pages to update, content to create, pages to consolidate
gsc_ctr_benchmark
Your actual CTR per position vs industry benchmarks
gsc_ctr_opportunities
Pages with high impressions but CTR below expected for their position
gsc_device_split
Queries where mobile and desktop rank entirely different pages from your site.
gsc_forecast
ARIMAPLUS traffic forecasting via BigQuery ML. Predict clicks up to 365 days out.
gsc_genai_conversation_queries
Which queries are AI conversation fragments? Seven kinds sorted, no API row limits, plus the anonymised split the API can't see.
gsc_intent_breakdown
Classify all queries by search intent: informational, transactional, commercial, navigational.
gsc_new_keywords
Queries appearing in recent data that weren't present before.
gsc_ngrams
Extract recurring terms from queries. Find themes your content should cover.
gsc_quick_wins
Keywords at positions 4 to 15 with high impressions, scored by opportunity
gsc_report
Full markdown performance report
gsc_seasonal
Year over year monthly comparison. Spot seasonal patterns with YoY percentage changes.
gsc_site_snapshot
How is the site doing overall? Clicks, impressions, CTR, position with period comparison
gsc_topic_cluster
Aggregated performance for all pages matching a URL path pattern
gsc_traffic_drops
What lost traffic, and whether it's a ranking loss, CTR collapse, or demand decline
list_datasets
Discover available datasets in your project.
list_tables
All tables and schemas in a dataset.
query
Run any SELECT query. Claude writes the SQL for you.
query_cost_estimate
Dry run to see bytes scanned before executing.
sample_rows
Preview rows without writing SQL.