View Categories

How to Query Google Search Console with Claude or Cursor via MCP

22 min read

MCP SERVER SEARCH CONSOLE

Query Google Search Console with Claude or Cursor via MCP.

A 5-minute setup that lets your AI tool ask plain-English questions about your SEO data — clicks, impressions, CTR, top queries, underperforming pages — without exposing GSC OAuth tokens to the AI vendor or opening firewall ports on your network.

No firewall holes One key, every connector Live data, no cache lag Bring your own AI tool

Query Streams is a secure, real-time data integration platform that brings every database and SaaS API in your account into Claude, Cursor, ChatGPT, and Grok — through a single MCP key with no firewall changes. This guide walks through wiring up the Google Search Console connector specifically, so your AI tool can answer plain-English questions about clicks, impressions, CTR, and ranking pages without you copy-pasting CSV exports out of the GSC web UI. Learn more at QueryStreams.com and sign up for free to start asking your AI tool real SEO questions.

What Query Streams MCP gives you for Google Search Console

Other “Google Search Console MCP” servers on the open-source landscape connect the AI tool directly to the GSC API. That works, but it pushes a Google OAuth token into your AI client’s config, scopes the AI tool to only Search Console, and gives you no audit trail of what the AI actually asked. Query Streams MCP solves a wider problem: one key, every connector, full audit trail, and the AI tool never holds your Google credentials.

Zero inbound firewall holes

The Network Agent opens a single outbound encrypted cloud link to Query Streams. Your AI client connects to the cloud, never to your network. No port to open, no IP to allowlist, no VPN.

One key, every connector

The same MCP key reaches every database and SaaS API your account has connected. Add a Stripe or PostgreSQL connector tomorrow and the AI tool sees it without re-keying.

Schema Intelligence baked in

The AI sees AI-curated descriptions, semantic types, enum value lists, and discovered foreign keys for every column — not just bare information_schema output. It writes accurate SQL the first try.

Read-only enforced at the agent

Even a hallucinating LLM can’t issue DELETE or UPDATE through Query Streams MCP. The Network Agent rejects anything that isn’t SELECT, WITH, or EXPLAIN before it reaches the data source.

Per-key rate limits

Default 60 requests per minute and 10 execute calls per minute, configurable per key. A runaway AI tool-call loop hits a token bucket, not your GSC quota or your wallet.

How it works without opening firewall ports

The Query Streams Network Agent installs once on any machine that can reach Google Search Console and dials one outbound TLS link to the cloud — when the AI asks a question, the agent calls the GSC API, caches the response in a local DuckDB so the AI can run SQL against it, and streams the result back out the same channel, with nothing inbound exposed and the AI tool never seeing your Google OAuth token. how the outbound-only connection works →

AI Client

Cursor, Claude,
ChatGPT, Grok

QS MCP Server

Streamable HTTP
X-MCP-Key auth

Network Agent

On your network
Cloud link out

Google Search Console

OAuth held by
the agent

No inbound port required — the agent dials out, never the other way around

The MCP key you give Cursor or Claude is scoped (read / analyze / execute), revocable at any time, and rate-limited per-key. The AI tool calls these MCP tools to do its work:

querystreams-mcp · tool catalog
qs_list_organizationsread
Returns the org bound to the calling key.
qs_list_agentsread
Lists Network Agents and online state.
qs_list_connectorsread
Lists data connectors (one entry per database server or API).
qs_get_connector_schemaread
Returns the GSC tables and columns the AI can query, with Schema Intelligence enrichment when available.
qs_profile_tableanalyze
Sample values, distributions, enum detection, semantic types — on demand.
qs_list_saved_queriesread
Pre-built parameterized SQL templates the team trusts. The AI runs them without ever seeing the SQL.
qs_run_saved_queryexecute
Executes a saved query by pattern_key with optional parameter overrides.
qs_run_queryexecute
Executes a SELECT against a connector. Read-only validator runs at the agent, before the database sees the SQL.

Why Schema Intelligence makes Query Streams MCP different

Most “MCP for X” servers in the open-source landscape hand your AI tool the same information_schema your database hands a stranger. Column names. Data types. Maybe a primary key. The LLM is left to guess what status_id = 3 means, what usr_eml stores, or whether customer_orders.cust_id actually joins to customers.id (no foreign key was ever declared either way). That’s why the first SQL most LLMs write against a bare schema is wrong — not because the LLM is bad, but because it doesn’t have the data it needs to be right.

Query Streams MCP returns that same schema enriched with what we call Schema Intelligence (SI) — AI-curated metadata that’s generated by running profiling queries against your actual data before the AI client ever asks. When SI is enabled on a connector and database, every schema tool the AI calls (qs_get_connector_schema, qs_get_table_schema, qs_profile_table, qs_get_relationships) returns the bare schema plus six layers of curated knowledge. The LLM stops guessing.

To make this concrete, here is what the AI client gets back from a single qs_get_table_schema call against the GSC connector’s search_analytics table — first without Schema Intelligence, then with it.

Without Schema Intelligence data_source: captured_schema
// what the LLM sees == TABLE: search_analytics == Columns: – id int [PK, NOT NULL] – site_url varchar(500) NOT NULL – keys varchar(2000) – country char(3) – device varchar(20) – clicks int NOT NULL – impressions int NOT NULL – position decimal(8,2) – date int NOT NULL Indexes: ix_date, ix_site_url Foreign Keys: (none declared) si_recommendation: state: “not_run” what_youre_missing_for_this_call: – AI-discovered foreign keys – Per-column sample values + enum detection – Table and column descriptions – Semantic type classifications – Business domain tagging
With Schema Intelligence data_source: schema_intelligence
// what the LLM sees == TABLE: search_analytics [FACT, domain:seo] == “Daily aggregated GSC search performance metrics per query, page, country, and device combination.” ai_analyzed_at: 2026-04-30 · ~487,233 rows Columns: – id int [PK] identifier – site_url varchar(500) url Sample: “sc-domain:querystreams.com” FK -> sites.url (97% overlap, 0.9 conf) – keys varchar(2000) text_content “Pipe-separated query|page|country|device” – country char(3) location Sample: [‘usa’,’gbr’,’can’,’aus’,’deu’] – device varchar(20) status_code (enum) DESKTOP (61%) | MOBILE (34%) | TABLET (5%) – clicks int counter Range: 0 – 9,432 – impressions int counter Range: 0 – 124,510 – position decimal(8,2) ranking_position Range: 1.00 – 100.00 – date int date_yyyymmdd ⚠ NOT a SQL DATE – integer YYYYMMDD encoded Sample: 20260428, 20260427, 20260426

The six layers Schema Intelligence adds

Each layer addresses a specific class of question the LLM would otherwise have to guess at. SI is opt-in per (connector, database) pair and runs as a one-time profiling pass against your data — it does not change your schema, does not write to your database, and refreshes incrementally when your schema changes.

AI-curated descriptions

Plain-English purpose for every database, schema, table, and column — generated once, refreshed when your schema changes. Confidence-scored; user-authored descriptions always win.

search_analytics: “Daily aggregated GSC
search performance per query/page.”

Table classifications

Each table tagged FACT (transactional events), DIM (descriptive reference), or LOOKUP (small code maps), plus a business domain — sales, hr, seo, finance, support, and 14 more.

search_analytics [FACT, domain:seo]
sites [DIM, domain:seo]

Semantic types per column

Eighteen types — currency, email, date_yyyymmdd, status_code, percentage, ranking_position, identifier, url, person_name, and more. The AI generates dialect-correct SQL appropriate to each type.

position: ranking_position
clicks: counter · date: date_yyyymmdd

Sample values from real data

Random rows surfaced to the LLM so it recognises patterns no schema can show — formatting conventions, encoded values, abbreviation styles, and the actual shape of your strings.

country: [‘usa’, ‘gbr’, ‘can’, ‘aus’, ‘deu’]

Enum detection with distributions

Low-cardinality columns (50 or fewer distinct values, at most 5% of rows unique) mapped to their full value list with row counts. The AI never guesses casing or spelling.

device: DESKTOP (61%) | MOBILE (34%)
| TABLET (5%)

Implicit foreign-key discovery

Cross-table data overlap analysis finds joins that aren’t declared as DDL constraints. Stored alongside formal FKs with confidence scores, returned by qs_get_relationships.

search_analytics.site_url -> sites.url
(97% overlap, conf 0.9)

Same prompt, different SQL

The proof is in the SQL the AI tool actually writes. Same Cursor session, same Claude model, same prompt — “Show me the top 10 GSC queries with the highest CTR last month, where impressions are over 100.” Without Schema Intelligence the LLM has to guess. With it, the LLM knows.

Without Schema Intelligence
— LLM’s first attempt against bare schema: SELECT TOP 10 keys, clicks, impressions, (clicks * 1.0 / impressions) AS ctr FROM search_analytics WHERE date BETWEEN ‘2026-04-01’ AND ‘2026-04-30’ AND impressions > 100 ORDER BY ctr DESC ERROR: “Conversion failed when converting date” date is integer YYYYMMDD, not a SQL DATE no GROUP BY — many rows per query/page divide-by-zero risk on rows w/o impressions
With Schema Intelligence
— LLM’s first attempt with SI enabled: SELECT TOP 10 keys, SUM(clicks) AS total_clicks, SUM(impressions) AS total_impressions, ROUND(SUM(clicks) * 100.0 / NULLIF(SUM(impressions), 0), 2) AS ctr_pct FROM search_analytics WHERE date BETWEEN 20260401 AND 20260430 AND impressions > 100 GROUP BY keys ORDER BY ctr_pct DESC 10 rows. Correct first try. date saw semantic type = date_yyyymmdd clicks/impressions saw semantic type = counter NULLIF guards against divide-by-zero
Don’t want to run Schema Intelligence? MCP still works — schema tools return bare metadata (types, primary keys, formal foreign keys, indexes) and every degraded response carries an si_recommendation block telling the AI what it’s missing, including a one-call option to enable SI mid-conversation via qs_request_si_analysis. how Schema Intelligence runs and how long it takes →
Nova AI

MCP not for you? Try Nova AI instead.

Skip the JSON config entirely: Nova AI is built into the Query Streams web portal and asks the same plain-English questions against your Google Search Console data — “what were my top 10 GSC queries last week?” — same agent, same read-only enforcement, same Schema Intelligence, no MCP plumbing.

Meet Nova AI

Prerequisites

Before you start, make sure you have:

  1. A free Query Streams account at my.querystreams.com.
  2. The Query Streams Network Agent installed on a machine with internet access — see Download the Query Streams Agent.
  3. A Google Search Console connector configured against the agent — see the existing API Connector Setup guides for OAuth pairing. The agent holds the Google OAuth token; the AI tool never touches it.
  4. Any MCP-capable AI client. We’ll show Cursor, Claude Desktop, ChatGPT, and Grok in this guide; if you use Windsurf, Zed, Continue, Cline, VS Code Copilot, Codex, or Goose, the config block is essentially the same.
  5. Five minutes.
You only set up the agent once. The same agent that powers Query Streams’ Excel and Google Sheets add-ons, the web Query Builder, and Nova AI also serves MCP. Adding MCP to an existing Query Streams account is just generating a key — the agent and connectors are already running.
1

Generate an MCP key

From the /mcp page in Query Streams, mint a key with the scopes you want.

2

Drop it into your AI client

One JSON snippet for Cursor, Claude, ChatGPT, or Grok. Same key everywhere.

3

Ask a question

“What pages lost the most clicks last month?” — the AI calls the right tools, you get the answer.

Step 1: Generate an MCP key in Query Streams

Sign in to Query Streams and open the MCP page (or sign in first at my.querystreams.com and click MCP in the left navigation). Click Generate key, give the key a recognizable name (something like cursor-laptop or claude-desktop), and pick the scopes you want this key to have:

  • read — the AI can browse connectors and read schema. Required for everything else.
  • analyze — the AI can profile tables and discover relationships (sample values, distributions, semantic types). Optional but strongly recommended for SEO work, where understanding the shape of your queries matters.
  • execute — the AI can actually run SQL. Without this, the AI is read-only against schema metadata only.

For a typical “let Claude analyse my Search Console data” workflow, all three scopes are appropriate. For a key you’re handing to a teammate or a less-trusted client, drop execute and let them browse only. You can revoke any key at any time from the same page; the AI client will see MCP_KEY_REVOKED on its next call and stop working immediately. There’s no propagation delay.

Copy the key now — Query Streams shows it once, then stores only a hash. If you lose it, generate a new one. The key looks like qsmcp_ followed by 48 random characters and is what your AI client sends in the X-MCP-Key request header.

Step 2: Add Query Streams MCP to your AI client

The configuration is the same shape across every MCP-capable client — an MCP server entry pointing at https://mcp.querystreams.com with your key in the X-MCP-Key header. Pick your client below.

Cursor
Cursor ~/.cursor/mcp.json
// Edit ~/.cursor/mcp.json
{
  "mcpServers": {
    "querystreams": {
      "url": "https://mcp.querystreams.com",
      "headers": {
        "X-MCP-Key": "qsmcp_PASTE_KEY_HERE"
      }
    }
  }
}
Claude Desktop
Claude Desktop claude_desktop_config.json
// Settings → Developer → Edit Config
{
  "mcpServers": {
    "querystreams": {
      "url": "https://mcp.querystreams.com",
      "headers": {
        "X-MCP-Key": "qsmcp_PASTE_KEY_HERE"
      }
    }
  }
}
ChatGPT
ChatGPT Apps & Connectors
// Settings → Apps & Connectors → Add MCP
Server URL  https://mcp.querystreams.com
Auth header X-MCP-Key
Header value qsmcp_PASTE_KEY_HERE

// Requires a paid ChatGPT plan
// (Plus / Pro / Team / Enterprise).
Grok
Grok Remote MCP Tools
// Grok → Settings → Tools
{
  "mcp_servers": [{
    "name": "querystreams",
    "url": "https://mcp.querystreams.com",
    "auth_header": "X-MCP-Key",
    "auth_value": "qsmcp_..."
  }]
}

Restart your AI client. On its next start it will discover the eight Query Streams MCP tools listed above and surface them in its tool palette. In Cursor and Claude Desktop you can verify by typing “list connectors” — the AI should call qs_list_connectors and return your Google Search Console connector along with anything else you have configured.

Step 3: Ask the AI a Google Search Console question

You don’t write SQL — the AI does. You ask a question, the AI picks the right MCP tool, the agent runs the query against your GSC data, and the answer comes back as text plus tables. Three example prompts to try first:

“Which 10 of my pages had the biggest drop in clicks last month compared to the month before?”
SEO Audit
The AI will call qs_get_connector_schema to discover the GSC tables, then qs_run_query with a SELECT that aggregates clicks by page and date range, joins to the previous month, sorts by delta, and returns the top 10. You’ll see the result table inline, plus a written interpretation of which pages declined and possible causes (CTR drop, ranking position drop, query mix shift) the AI inferred from the data.
“What queries drove clicks last week, and which of them have a CTR below the site average?”
Opportunity
The AI computes the site-wide CTR from the GSC data, then filters to queries below it. Below-average-CTR queries are usually title and meta-description rewrite candidates — you’re already ranking, the click-through is the problem. The AI will typically flag the top 5–10 candidates and explain why each is a CTR concern (position too low to attract clicks, title doesn’t include the search query verbatim, etc.).
“Compare last 28 days CTR by country for queries containing ‘database’.”
Geo
A pivot by country with clicks, impressions, position, and CTR. The AI tool will usually highlight the geo splits that diverge most from the site mean, and propose a follow-up query — “want me to break this down by query for the top three countries?” — if you want to drill in. Replies are conversational; you don’t need to reset context.

The first time the AI calls a tool, your client may pop up a confirmation prompt asking you to approve the tool call — that’s MCP’s standard consent flow, not anything Query Streams adds. Approve once and the AI proceeds with the rest of the conversation freely. You can revisit the consent at any time in your client’s settings.

Honest billing notice: MCP usage is charged on uncompressed bytes

Query Streams’ Excel add-in, Google Sheets add-on, web Query Builder, and Nova AI all run over our compressed cloud link — we measure and bill compressedBytes against your data realm. The MCP transport (Streamable HTTP per the official MCP spec) does not reliably support compression end-to-end across every client and intermediate proxy, so we measure and bill uncompressedBytes for MCP traffic.

  • What this means: a 1 MB GSC result row set costs ~1 MB of your data realm when fetched via MCP, vs. ~150–250 KB via Excel / Sheets / Nova / the Query Builder. Same data, different transport, different billable size.
  • What this isn’t: a markup or a punishment for using MCP. We pass through actual bytes shipped. The other clients are cheaper because compression works reliably on those transports; we don’t punish you for the protocol choice, but we have to be transparent about the cost shape.
  • What you can do: for very large recurring queries (e.g. 100K+ row exports), prefer the Excel / Sheets / Nova path. For interactive AI tool calls (the typical 100–5,000 row response that fits in an LLM context), MCP is the right choice and the cost difference is in cents.

Frequently asked questions

Do I need to open ports or run a VPN to use this? +
No inbound rules, port-forwarding, NAT punchthrough, or VPN. The Network Agent makes one outbound TLS connection (port 443) and your AI client reaches https://mcp.querystreams.com from the public internet — if outbound HTTPS works on the agent host, MCP works. See how the outbound-only connection works →
Which AI tools can I use with Query Streams MCP? +
Any client that speaks the open Model Context Protocol — Claude Desktop, Claude Code, Cursor, ChatGPT (paid), Grok, Gemini CLI, Windsurf, Zed, and 500+ more. Bring your own AI tool; you don’t have to switch. Full list of supported AI clients →
Can I revoke an MCP key? +
Yes — three independent kill-switches (per-key from the /mcp page, per-org via plan settings, and platform-level), none of which need a database password rotation or agent restart. More on MCP key security →
How is MCP usage billed against my data realm? +
All access methods draw on one data-realm budget; only the measured size differs — the compressed clients (Excel, Sheets, Query Builder, Nova AI) bill compressedBytes, while MCP over Streamable HTTP bills uncompressedBytes (a 1 MB result is ~150–250 KB via the compressed clients vs. ~1 MB over MCP). How MCP usage is metered →
Does Query Streams MCP work with my Google Workspace account? +
Yes. The Google Search Console connector authenticates with the same Google credentials any GSC user already has — the standard OAuth grant Google uses for Search Console API access. The OAuth token lives on the Network Agent host (encrypted at rest), refreshes automatically, and is never sent to the AI vendor. If you’ve already set up Search Console for any other Query Streams workflow (Excel reports, Sheets sync, scheduled queries), the connector is already paired and MCP simply rides along.
How does this differ from running an open-source GSC MCP server myself? +
A direct GSC MCP server (community projects on GitHub do exist) is one MCP per data source. To get Claude reading from GSC + your PostgreSQL + your Stripe account + your Snowflake warehouse you’d need four MCP servers configured separately in every AI client, each with its own credentials, each with its own scope model, each with its own audit story. Query Streams MCP is one key reaching every connector your account has paired. You also pick up Schema Intelligence, agent-layer read-only enforcement, per-key rate limits, audit trail in event_logs, and the same data-realm billing pipeline you already use — none of which a direct MCP gives you.
What happens if the AI tries to write or delete data? +
It’s rejected at the agent before the data source sees the SQL. Every qs_run_query call is parsed by a hardcoded read-only validator that allows only SELECT, WITH, and EXPLAIN statements; anything else returns READONLY_VIOLATION and never reaches Google Search Console. The validator runs in the agent process on your network, not in the cloud, so a compromised cloud surface couldn’t bypass it. (Search Console’s API itself is read-only too, but the same protection applies to every other connector you might add — PostgreSQL, MySQL, etc.)
Can I see what the AI actually asked? +
Yes. Every MCP tool call writes a row to event_logs with the org, user, key, scope, latency, and result code. The org-admin can answer “who used MCP last week, which connector, and what did they ask?” with a single query. Note that we log the tool name and metadata, not the SQL text or returned rows — those flow through the cloud link and never land in cloud logs. If you want full SQL audit, enable database-side audit on the underlying engine; for GSC specifically that’s a Google Workspace audit log entry.
Do I have to run Schema Intelligence to use Query Streams MCP? +
No — Schema Intelligence is opt-in per (connector, database) pair, and MCP works fine without it. The AI gets bare schema (types, primary keys, formal foreign keys, indexes) and writes basic queries. With SI enabled, the AI gets six additional layers of curated metadata: (1) AI-curated descriptions on every database, table, and column; (2) table classifications (FACT for transactional events, DIM for descriptive reference, LOOKUP for small code maps) plus a business domain tag (sales, hr, seo, finance, support, and 14 more); (3) a semantic type on every column (currency, email, date_yyyymmdd, status_code, percentage, ranking_position, identifier, url, person_name, and 9 more) that drives dialect-correct SQL generation; (4) sample values from your real data so the LLM recognises patterns no schema can show; (5) enum detection with full value distributions for low-cardinality columns; and (6) AI-discovered foreign keys based on cross-table data overlap, surfaced through qs_get_relationships. Without SI, every schema-tool response also carries an si_recommendation block listing exactly what’s missing for the call — the AI can read this and offer to trigger SI mid-conversation via qs_request_si_analysis. Run time scales with table count: a small database under 100 tables completes in around 10 minutes; a typical mid-size database (a few hundred tables) finishes in 15–25 minutes; a large enterprise database with 1,500+ tables can take 45–60 minutes for a full scan. SI runs through your Network Agent against your data (never in the cloud), never writes to your database, never changes your schema, and refreshes incrementally when your schema changes — so subsequent runs after you add or alter tables are much faster than the first one. The end-to-end effect: with SI enabled, your AI client writes correct SQL on the first try far more often than it does against any “MCP for X” server that just hands the LLM information_schema.
What if I add another connector later, like Stripe or PostgreSQL? +
Nothing changes client-side — the same key reaches the new connector the moment the agent pairs it (qs_list_connectors picks it up automatically). One config block buys your whole account, present and future. Why one key covers every connector →
Do I have to set up MCP just to chat with my data? +
No — Nova AI is built into the Query Streams portal and works against every connector (Google Search Console included) with no MCP setup or config files. Use Nova to chat with your data inside Query Streams; use MCP when you want your own AI client (Claude, Cursor, ChatGPT, …) to reach the same data — same agent, same connectors, same Schema Intelligence underneath. Learn more about Nova AI →

Get started

Connect your AI tool to your SEO data in five minutes.

One MCP key reaches Google Search Console, every database, and every other API connector in your Query Streams account — with full audit trail, per-key rate limits, and zero firewall changes. Claude, Cursor, ChatGPT, and Grok all work out of the box.

Related guides: Download the Query Streams Agent | API Connector Setup | All MCP Server guides | Nova AI text-to-SQL

Category: MCP Server

Tags: mcp, claude, cursor, chatgpt, grok, google-search-console, gsc, seo, ai

Meta Description: Connect Claude or Cursor to Google Search Console via MCP. Query SEO data with AI in plain English. Free.

Updated on June 16, 2026

Powered by BetterDocs