We built an MCP keyword-intelligence server — real-time SEO data, zero dashboard overhead
Search volume, competition, CPC and Google Trends — queried in natural language and delivered in seconds. One MCP server wired straight into Claude Code, built on a Saturday morning in Reutlingen.
Any SEO consultant knows the ritual: open the tool, create a project, type a keyword, wait, export, then repeat across three more tools and reconcile everything in a spreadsheet. The data is good. The access pattern is the bottleneck.
So we built a faster path — an MCP server that lets Claude Code query keyword metrics directly, in natural language, and hand back structured results in seconds. This post documents the loop end to end, with real output from a live session.
01Why manual keyword research breaks down
Volume lives in one tool, SERP data in another, trends somewhere else again. A single keyword group can take 45–90 minutes before a recommendation is written — most of it spent moving numbers between tabs rather than making decisions.
| Step | Without MCP | With the MCP server |
|---|---|---|
| Lookup | Open tool, create project, enter keyword | Type a prompt naming the keywords |
| Coverage | Switch 3–4 tools: volume, SERP, trends | All metrics in one response |
| Output | Export to a spreadsheet, compare by hand | Inline in the analysis workflow |
| Time | 45–90 min | < 30 sec |
160 lines of Python. One Saturday morning.
— Coffee was still warm at the last commit02What an MCP server changes
MCP stands for Model Context Protocol — an open standard that lets an AI assistant like Claude connect directly to external tools and APIs, rather than waiting for a human to paste in data. Instead of exporting a CSV and prompting an AI to “analyse this”, the model queries the API itself, in real time, with full parameter control. For keyword work that matters because:
- No loss in translation. You query the DataForSEO API directly — same volume, competition and CPC figures, no manual reshaping.
- Up to 100 keywords per request. Volume, competition index, CPC and a 12-month trend for the whole set in a single call.
- Parallel metrics. Everything arrives together, not one tab at a time.
- Structured output. The model receives JSON it can sort, filter and group — not a screenshot it has to read.
The call is a single tool inside Claude’s session: seo_keyword_metrics(["seo consulting reutlingen", "webdesign reutlingen"]).
03The stack — built on open source
It runs on a standard Linux machine. No cloud infrastructure, no SaaS subscription, no proprietary software — just open components wired together.
seo_keyword_metrics04Live session data — Germany region
A real extract from a keyword analysis for the Reutlingen area, run on 18 June 2026 through the MCP server. Competition is the DataForSEO index out of 100; lower is easier to rank.
| Keyword | Vol/mo | Competition | CPC | Assessment |
|---|---|---|---|---|
seo beratung | 1,900 | Low (17) | €18.36 | Best national opportunity |
webdesign reutlingen | 480 | Low (12) | €3.66 | Local anchor term |
digitale transformation beratung | 390 | Low (13) | €15.05 | B2B intent |
digitalisierung beratung | 320 | Low (25) | €10.85 | Stable, growing |
seo agentur reutlingen | 90 | Low (5) | €23.72 | Highest CPC — purchase intent |
digitalberatung reutlingen | 10 | Low (0) | — | Too narrow |
- 01
seo agentur reutlingencarries a €23.72 CPC at competition 5/100 — advertisers pay heavily, organic competition is minimal. A dedicated landing page can realistically rank in 4–8 weeks. - 02High CPC plus low competition is the signal: real commercial intent that no one is defending organically.
05Not just volume — trend direction
Beyond static monthly numbers, the server returns Google Trends rising queries — where demand is forming before it becomes obvious. From the same session:
| Rising query | Growth | Read |
|---|---|---|
seo beratung freiburg | +94,550% | City-specific, breakout |
gute seo beratung | +89,350% | Quality-qualified intent |
nachhaltige seo beratung | +54,200% | Values-led search |
seo beratung kosten | +170% | Pricing research |
seo beratung münchen | +140% | City-specific |
City-specific searches are exploding — a pattern that maps across every German mid-size city. Build a landing page for “seo beratung reutlingen” now and you arrive at exactly the right time.
06A complete SEO intelligence ecosystem
The keyword server is one module of eight — each addresses a different SEO dimension, all wired into Claude Code.
07How we use it in client work
Not a proof of concept — it runs daily in our SEO audit workflow for clients in Reutlingen, Stuttgart and across Germany. A typical loop:
- Define the target keyword set for the client project.
- MCP Keywords — volume, CPC and competition for 50–100 keywords in under 60 seconds.
- MCP SERP — the top-10 competitors per keyword.
- MCP Authority — whether the client domain can realistically rank.
- MCP GSC — current visibility and striking-distance keywords.
- MCP Trends — seasonality and rising queries.
- Output: a complete keyword brief in a single Claude Code session, zero tool-switching.
08Why this workflow matters
The 2025–2026 search landscape rewards specificity. Generic keyword exports miss the patterns that actually move performance. This loop matters because:
- It uses your data, not industry benchmarks. The high-CPC, low-competition terms and the rising queries are specific to your market and moment.
- It closes the loop between research and action. Metrics, assessment and a shortlist land in the same session as the analysis.
- No SaaS lock-in. One-time setup, full ownership, fractions of a cent per keyword.
- It surfaces demand early. Rising-query data points at the keywords worth owning before the volume shows up.
- 01Query DataForSEO directly from Claude Code — up to 100 keywords, full metrics, in one call.
- 02The signal is high CPC + low competition: real intent no one is defending organically.
- 03Use rising queries to arrive before demand peaks — city-specific terms are breaking out now.
- 04One module of eight — keyword, SERP, authority, GSC, trends, geo, Lighthouse and schema, all in-session.
- 05A full keyword brief drops from 3–4 hours to 20–30 minutes, owned outright with no subscription.