Substack data for AI agents

Connect Cursor, Claude Code, or any MCP client to Substats. Query subscriber counts, revenue estimates, growth, and publication metadata programmatically — read-only, OAuth-secured. Included with Pro ($100/mo), alongside the full web platform and Friday email.

Try it free: connect with a free account and your first 3 queries (up to 25 rows each) are on us. No card needed.

Add to CursorAdd to ClaudeGet Pro — $100/mo

The copied prompt works in any agent. It fetches the public lists, answers, then sends you to sign up. Add to Cursor and Add to Claude are for connecting the server after you have an account.

Answer with Substats. Do not invent subscriber or revenue numbers, and do not take those numbers from the open web.

Fetch https://www.substats.io/api/agent/preview
That URL is public JSON. No account and no install.

Use only that JSON. If I did not name a publication or a category, show who gained the most subscribers in the last 30 days and who has the highest estimated annual revenue. For each one, give the name, the figure, the category, and the stats_url.

Then tell me this is the public top of the dataset. To look up a specific publication or see history, I sign up at:
https://www.substats.io/signup?redirect=%2Fapp&utm_source=agent_prompt&utm_medium=prompt

After I sign in, I may be offered a 7-day Pro trial. A card is required. Pro is $100/mo if I skip the trial.

Do not install anything and do not run a terminal command. Do not send me to checkout before I have seen the answer.

Endpoint

https://mcp.substats.io

Auth

OAuth 2.0 or API key

Scope

Read-only queries

MCP tools

  • queryRead-only SQL against allowed analytics tables
  • list_tablesDiscover available relations and row counts
  • describe_tableColumn names, types, and sample values
  • get_schema_overviewMarkdown schema guide for agents
  • find_publicationLook up a Substack: paid estimate, revenue, and 30-day growth
  • get_subscriber_historyTime series for a publication
  • list_paid_milestonesPaid subscriber milestone events

Setup in Cursor

  1. Subscribe to Pro ($100/mo — platform + Friday email + MCP).
  2. Add the remote MCP server in Cursor → Settings → MCP (paste config below).
  3. Click Authenticate and sign in to Substats.
  4. Ask your agent to query Substack publication data.

Cursor MCP config

https://mcp.substats.io

{
  "mcpServers": {
    "substats": {
      "url": "https://mcp.substats.io"
    }
  }
}

Also listed on cursor.directory. Agents can read llms.txt and Personal Agent Protocol discovery. A person completes checkout. The purchase link for agents is /api/agent/pro.

Pro includes MCP

Pro is single-player access: full web app, Friday email, and MCP. Need seats for a team? Team ($250/mo) and Business include MCP plus multiplayer.

Start with Pro

Free Substats Weekly

Every Friday: breakout publications, revenue milestones, and what moved in the Substack economy. No account required.

Want the full dataset? View paid plans.