本文へスキップ
Kitbay
MCPサーバー

Suganthan's BigQuery MCP Server

ローカルで動作Apache-2.02026年8月27日 更新44GitHubスターAPIキーが必要

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.

このサーバーについて

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.

できること

  • 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