Suganthans BigQuery MCP Server banner
Suganthan-Mohanadasan Suganthan-Mohanadasan

Suganthans BigQuery MCP Server

Data community

Description

BigQuery MCP server for Claude — query any BigQuery dataset in natural language, with built-in SEO analysis tools for GSC bulk export data

Installation

This entry records only its repository, not the path inside it, so there is no exact command to give. Open the source below and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

README

Google Search Console → BigQuery → Claude

BigQuery MCP Server

An MCP server for BigQuery that lets you ask Claude questions about your search and analytics data warehouse and get real answers. Not raw query results. Actual analysis with verdicts and recommendations.

32 tools. GA4 + GSC revenue attribution. ML forecasting. Anomaly detection. Anonymous query analysis. Free and open source.

**Full setup guide with screenshots:** [suganthan.com/blog/bigquery-mcp-server/](https://suganthan.com/blog/bigquery-mcp-server/)

**New in v4.0 (GA4 integration):** [suganthan.com/blog/google-analytics-bigquery-mcp-server/](https://suganthan.com/blog/google-analytics-bigquery-mcp-server/)

See it in action

**"How much of my traffic is hidden behind anonymous queries?"**

![Anonymous traffic analysis showing the ~46% of clicks the GSC API hides](screenshots/anonymous-traffic.jpg)

**"Forecast my traffic for the next 90 days"**

![ARIMA_PLUS traffic forecasting with daily predictions and confidence intervals](screenshots/forecast.jpg)

**"Are there any traffic anomalies I should investigate?"**

![ML anomaly detection flagging unusual traffic patterns](screenshots/anomalies.jpg)

**"Show me year over year seasonal trends"**

![Year over year monthly comparison with YoY percentage changes](screenshots/seasonal.jpg)

**"Show me queries where mobile and desktop rank different pages"**

![Device split analysis showing ranking discrepancies](screenshots/device-split.jpg)

**"Break down my queries by search intent"**

![Intent classification: informational, transactional, commercial, navigational](screenshots/intent.jpg)

**"What are the most common terms in my queries?"**

![N-gram extraction showing recurring themes](screenshots/ngrams.jpg)

**"What new keywords appeared this week?"**

![New keyword discovery: queries appearing for the first time](screenshots/new-keywords.jpg)

What you can ask