Skip to content
Kitbay
MCP server

Suganthan's BigQuery MCP Server

Runs locallyApache-2.0Updated on Aug 27, 202644GitHub starsNeeds an API key

An SEO-focused local MCP server by Suganthan Mohanadasan that works on the Google Search Console bulk export in BigQuery, with optional GA4 export data.

What it does

An SEO-focused local MCP server by Suganthan Mohanadasan that works on the Google Search Console bulk export in BigQuery, with optional GA4 export data. Its 33 tools run prepared analyses rather than raw SQL: quick-win keywords, CTR gaps, content decay, cannibalisation, traffic drops, anonymous-query share, intent and n-gram breakdowns, forecasts and anomaly detection with BigQuery ML, and revenue per keyword when GA4 is linked. Six general tools work on any dataset. Only SELECT queries are allowed, with an automatic row limit, a bytes-billed cap and dry-run cost previews. It is built from source with npm and needs a service account with BigQuery roles.

Capabilities

  • Find keyword opportunities and CTR gaps from Search Console data
  • Detect content decay, cannibalisation and traffic drops
  • Forecast traffic and flag anomalies with BigQuery ML
  • Join GA4 conversions to search queries
  • Run read-only SQL on any BigQuery dataset