Skip to main content
Glama
ClearStack Data MCP server

ClearStack Data MCP server

by Wordhalm

ClearStack Data MCP server

CI License: MIT

Four research tools for Claude, Cursor, VS Code and any other MCP client:

Tool

Answers questions like

Cost per call

search_ats_jobs

"Which of Datadog, Snowflake and Databricks are hiring data engineers in Europe?"

$0.002 + $0.0015 per job

search_google_ads

"What Google Ads has notion.so run in the UK over the last 30 days?"

$0.002 + $0.0012 per ad

get_telegram_channel_posts

"Summarise this week's posts from t.me/durov."

$0.002 + $0.0015 per post

verify_eu_company

"Is FR22424761419 a valid VAT number, and which company is it?"

$0.004 per company

A fifth tool, get_run_results, collects the rest of a search that took longer than 45 seconds.

Each tool runs a ClearStack Data Actor on Apify with your own Apify API token. Costs are billed by Apify to your account; Apify's free plan is enough to try every tool. Every call sends Apify a spending cap, so a call never costs more than the price above for the number of results you asked for.

Install

You need Node.js 20 or later and an Apify API token from console.apify.com/settings/integrations.

Claude Code

claude mcp add clearstack-data -e APIFY_TOKEN=your_token -- npx -y github:Wordhalm/clearstack-data-mcp

Claude Desktop

Settings → Developer → Edit Config, then add:

{
  "mcpServers": {
    "clearstack-data": {
      "command": "npx",
      "args": ["-y", "github:Wordhalm/clearstack-data-mcp"],
      "env": { "APIFY_TOKEN": "your_token" }
    }
  }
}

Cursor and Windsurf

Same block as Claude Desktop, in .cursor/mcp.json (Cursor) or ~/.codeium/windsurf/mcp_config.json (Windsurf).

VS Code

.vscode/mcp.json (VS Code asks for the token once and stores it securely):

{
  "inputs": [
    { "type": "promptString", "id": "apify-token", "description": "Apify API token", "password": true }
  ],
  "servers": {
    "clearstack-data": {
      "type": "stdio",
      "command": "npx",
      "args": ["-y", "github:Wordhalm/clearstack-data-mcp"],
      "env": { "APIFY_TOKEN": "${input:apify-token}" }
    }
  }
}

The first start takes up to a minute while npx downloads and builds the server (41 s measured on a cold cache).

Related MCP server: webdatatools-social-mcp

Tools

search_ats_jobs

Open roles read directly from company career sites on Greenhouse, Lever, Ashby and SmartRecruiters (25,787 employers indexed; look one up at ATS Job Board Finder).

Parameter

Default

companies

[]

Names ("Stripe"), ats:slug pairs ("ashby:openai") or job board URLs. Empty: 35 well-known tech and AI employers.

keywords

[]

Match any of them in title or department.

location

""

Substring of the location: "London", "Remote", "Germany".

remoteOnly

false

maxJobs

50

1–500.

{"company":"Airbnb","ats":"greenhouse","title":"Account Executive (Hotels)","location":"Barcelona, Spain","isRemote":false,"publishedAt":"2026-11-10","applyUrl":"https://careers.airbnb.com/positions/8365363?gh_jid=8365363"}

search_google_ads

Ads from the public Google Ads Transparency Center.

Parameter

Default

targets

required

1–10 domains ("stripe.com"), advertiser IDs or Transparency Center URLs.

region

"ALL"

ISO-2 country code.

format

"ALL"

TEXT, IMAGE or VIDEO.

dateRangeDays

30

0 = all history.

maxAdsPerTarget

20

1–100.

{"target":"stripe.com","advertiserName":"Stripe, Inc.","advertiserId":"AR16951989901585285121","creativeId":"CR13805501473330561025","format":"TEXT","firstShownDate":"2026-07-31","lastShownDate":"2026-11-22","variationsCount":114,"adUrl":"https://adstransparency.google.com/advertiser/AR16951989901585285121/creative/CR13805501473330561025"}

get_telegram_channel_posts

Posts from public channels, read from Telegram's public web preview. No Telegram account or phone number.

Parameter

Default

channels

required

1–10 usernames or URLs: "durov", "@telegram", "https://t.me/bloomberg".

maxPostsPerChannel

30

1–200, newest first.

sinceDate

""

YYYY-MM-DD; older posts are skipped.

keywords

[]

Only posts containing any of them.

{"channel":"durov","channelTitle":"Pavel Durov","channelSubscribersNum":9910000,"messageId":568,"postUrl":"https://t.me/durov/568","publishedAt":"2026-11-21T22:48:52+00:00","text":"You won't look professional in 2027 if your QR is unpimped.","viewsNum":242000,"hasPhoto":false,"hasVideo":true,"hasDocument":false,"reactionsTotal":8870,"paidStars":1120}

paidStars is the number of Telegram Stars paid as reactions; it is not added to reactionsTotal.

verify_eu_company

VAT check against the European Commission's VIES service, plus the official registry record from France (SIRENE), Switzerland (Zefix), Norway (Brreg), Finland (PRH) and GLEIF.

Parameter

Default

queries

required

1–200 VAT numbers, French SIREN/SIRET, Swiss UID (CHE-105.909.036), Norwegian org numbers (NO:923609016).

defaultCountry

""

ISO-2 country for plain company names.

{"query":"FR22424761419","found":true,"kybStatus":"VERIFIED_ACTIVE","country":"FR","legalName":"OVH (OVHCLOUD)","registrationNumber":"424761419","vatNumber":"FR22424761419","vatValid":true,"leiCode":"9695007586GCAKPYJ703","status":"ACTIVE","incorporationDate":"1999-10-15","address":{"full":"2 RUE KELLERMANN 59100 ROUBAIX"}}

vatValid is null when VIES could not give a verdict (a member state's service is often busy). That means "check again later", not "invalid".

get_run_results

MCP clients usually stop waiting after 60 seconds, so each tool waits at most 45 seconds. A larger search returns the results found so far with finished: false and a runId; the model then calls get_run_results with that runId. No extra charge.

Structured output

Every tool returns structuredContent matching its declared outputSchema:

{ "actor": "clearstack-data/career-site-jobs-search", "runId": "…", "status": "SUCCEEDED", "finished": true, "itemCount": 3, "items": [] }

Empty fields are dropped from items to save tokens.

Security and privacy

  • The token is read from the APIFY_TOKEN environment variable and sent only to api.apify.com, in an Authorization header, never in a URL.

  • No telemetry, nothing written to disk. The only log line goes to stderr at startup.

  • All data comes from public sources: company career sites, Google's Ads Transparency Center, Telegram's public web preview, VIES and official company registries.

Troubleshooting

Message

Fix

APIFY_TOKEN is not set

Add the token to the env block of your client config and restart the client.

HTTP 401

The token is wrong or was revoked.

usage or spending limit

Raise the limit or upgrade at console.apify.com/billing.

may not be public yet

The Actor is not available to your account; open an issue.

finished: false

Normal for large searches: ask the model to call get_run_results.

Compared with Apify's own MCP server

Apify's MCP server can load these Actors too (https://mcp.apify.com?tools=clearstack-data/career-site-jobs-search) and exposes their full input schemas. This server wraps them with fewer parameters, trims the output, caps spending on every call and handles long runs. Use whichever fits your client.

Development

npm install                 # dev tools need Node 22+
npm test                    # unit tests on real Actor output
node scripts/smoke.mjs      # stdio check, no token needed
npm run e2e                 # one real call per tool (APIFY_TOKEN set), under $0.05
npm run pack:mcpb           # build the Claude Desktop bundle

License

MIT. Not affiliated with Greenhouse, Lever, Ashby, SmartRecruiters, Google, Telegram or the European Commission.

Available Tools

5 tools
get_run_resultsGet results of a running searchA
Read-onlyIdempotent

When another tool returned finished=false, wait for that Apify run and return its items. No extra cost: the run is already paid for.

Inputs: runId (required), maxItems. Returns: actor, items, runId, status, +2 more

get_telegram_channel_postsRead public Telegram channelsA
Read-only

Fetch recent posts from public Telegram channels without a Telegram account: text, date, views, reactions, links, hashtags. Optional keyword filter and date cutoff. Cost on the user's Apify account: $0.002 per call + $0.0015 per post returned.

Inputs: channels (required), keywords, sinceDate, maxPostsPerChannel. Returns: actor, items, runId, status, +2 more

search_ats_jobsSearch company career sitesA
Read-only

List open roles straight from company career sites on Greenhouse, Lever, Ashby and SmartRecruiters (index of 25,787 employers). Use it for job search ("remote AI engineer roles at Anthropic, OpenAI, Linear") or hiring signals ("is Datadog hiring data engineers?"). Returns title, location, team, publish date and apply URL. Cost on the user's Apify account: $0.002 per call + $0.0015 per job returned.

Inputs: maxJobs, keywords, location, companies, +1 more. Returns: actor, items, runId, status, +2 more

search_google_adsSearch Google Ads Transparency CenterA
Read-only

List the ads a company runs on Google (Search, Display, YouTube) from the public Google Ads Transparency Center: advertiser, format, first and last shown dates, ad URL and preview image. Use it for competitor research. Cost on the user's Apify account: $0.002 per call + $0.0012 per ad returned.

Inputs: targets (required), format, region, dateRangeDays, +1 more. Returns: actor, items, runId, status, +2 more

verify_eu_companyVerify EU company and VAT numberA
Read-only

Validate EU VAT numbers against the European Commission VIES service and return the official registry record (France SIRENE, Swiss Zefix, Norway Brreg, Finland PRH, GLEIF LEI): legal name, status, address, legal form, officers. Cost on the user's Apify account: $0.004 per company.

Inputs: queries (required), defaultCountry. Returns: actor, items, runId, status, +2 more

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A4.2/5.0

    Scored across 5 tools

    Disambiguation5/5

    Each tool targets a clearly distinct resource: ATS jobs, Google ads, Telegram posts, EU company verification, and Apify run results. The helper tool get_run_results is explicitly scoped to runs where another tool returned finished=false, so it should not be confused with the data-retrieval tools.

    Naming Consistency5/5

    All names use consistent snake_case with a verb_noun pattern: search_*, get_*, verify_*. The verbs are predictable and match the action performed.

    Tool Count5/5

    Five tools is a well-scoped set for a multi-source data retrieval server, and each tool has a distinct purpose. There are no redundant or filler tools.

    Completeness4/5

    The surface covers read-only retrieval for each advertised source and includes a helper for asynchronous Apify runs. Minor gaps remain around broader run management, such as listing or cancelling runs, but core data retrieval workflows are covered.

    Maintenance

    ActivityMaintained
    ResponsivenessNo recent community issues

    Related MCP Connectors

    • Your agent needs live data — a competitor's traffic, who to contact there, what people are saying, what Google and ChatGPT answer about you, a company's filings. Normally that is six vendor accounts, six sets of keys and six SDKs. This is one URL. **What you can ask for** • "How much traffic does stripe.com get, where does it come from, and who competes for the same keywords?" • "Find 20 Series-B fintech companies in Germany and the heads of marketing there, with emails." • "Does ChatGPT mention our brand when someone asks for the best CRM — and what does it cite?" • "What is X saying about $NVDA today, and what did the stock actually do?" • "Search the web for this, then scrape the three best pages into markdown." **How to use it** Point any MCP client at https://mcp.aisa.one/mcp and sign in with OAuth — there is no key to create or paste. Then just ask: the agent calls search to find the right operation and use to run it. **Why this rather than the source** 26 sources behind one account and one bill — DataForSEO, Semrush, Ahrefs, Similarweb, Apollo, X/Twitter, Instagram, Reddit, Pinterest, YouTube, Tavily, Exa, Perplexity, Firecrawl, CoinGecko, Kalshi, Polymarket, AgentMail and more, 580+ operations. tools/list returns five tools, not 580, so the introduction does not eat your context window. **What it costs** Finding and inspecting an operation is free. Running one is billed per call at API prices, with no seat and no monthly minimum, and every call takes max_price_usd so an agent cannot overspend by accident. **Where else it reaches** One slice at a time: https://mcp.aisa.one/seo/mcp · /finance/mcp · /social/mcp · /search/mcp · /sales/mcp · /mail/mcp · /gtm/mcp, or a single provider like /twitter-api/mcp. Same account, fewer tools listed, and search still reaches everything. Full list at https://mcp.aisa.one/servers

    • One MCP URL for web search, page reading, pay-per-result data tools and a browser agent.

      https://lovelyrouter.com/mcp
    • Live AI-native web search with citations. One tool for every MCP client. Flat per-request pricing.

      https://pixserp.com/api/v1/mcp
    • Pay-per-use tool marketplace for AI agents. Search, price-check, and call APIs via MCP.

      https://mcp.cralo.ai/mcp

    Related MCP Servers

    • A
      license
      A
      quality
      B
      maintenance
      One MCP server providing access to 160+ live web data APIs (search, social media, e-commerce, real estate, jobs, travel, news, finance, and more) using dynamic discovery via 4 generic tools to avoid the agent's tool limit.
      5
      4
      MIT
    • A
      license
      Not graded
      quality
      C
      maintenance
      Enables AI agents to search U.S. federal contract opportunities, verify US business registrations, analyze company hiring signals, and retrieve SEC company financials through pay-per-result remote MCP tools.
      MIT
    • A
      license
      Not graded
      quality
      B
      maintenance
      Enables AI agents to perform keyless web search, read pages past bot walls, look up product and local marketplace listings, fetch YouTube transcripts, and run multi-step research through MCP tools.
      Apache 2.0