Using Claude + local MCPs for SEO reporting: context window blows up in a few thousand rows
No-Roll302 · reddit · 2026-11-14
The poster connected Google Search Console, GA4, and Shopify data into Claude Desktop via open-source local MCPs to replace weekly VLOOKUPs across exported CSVs, but hit two walls:
- Pulling more than a few thousand rows from GSC + analytics blows up the context window before Claude can cross-reference anything useful
- Setting up OAuth tokens locally across multiple repos gets brittle, especially when sharing workflows with non-technical teammates
They ask the community which multi-source questions still force a fallback to spreadsheets or BigQuery, and how people handle the data-joining layer without burning tokens.
More from coding & agent
- Pinokio Launches Create: AI Agents Package Any Project Into 1-Click Launchers — cocktailpeanut · 2026-11-15
- Dev uses two coding agents to slop together a personal portfolio site — adonis_singh · 2026-11-15
- MCP SDK Is Now the Most Imported AI Package in New PyPI Projects, Beating OpenAI's — Business-Feedback635 · 2026-11-15
- Agents can generate 3D assets but can't verify them — a visual AI infra gap — PrateekVJoshi · 2026-11-15
- A /pareto-analyze skill that finds the biggest contributors to any problem — rchardkovacs · 2026-11-15
- When your coding agent outruns your understanding, make it explain the app before building more — brandon_galang · 2026-11-15