# substack-insights-mcp

> substack-insights-mcp — jakewlittle-cs-substack-insights-mcp. Use this tool when you need to analyze and track a Substack publication's performance and content patterns without requiring credentials. It solves problems related to data accessibility and analysis by turning public RSS archives and analytics snapshots into a queryable local SQLite ledger. The tool provides 12 MCP tools with inputs of RSS archives and analytics snapshots, and outputs durable and queryable data for informed decision-making.

Canonical page: https://skillsregistry.net/skills/jakewlittle-cs-substack-insights-mcp  
JSON: https://api.skillsregistry.net/v1/skills/jakewlittle-cs-substack-insights-mcp

## Description

A credential-free MCP server that turns a Substack publication's public RSS archive and official analytics snapshots into a durable, queryable local SQLite ledger. It provides 12 MCP tools for browsing posts, tracking versions, recording metric snapshots, and analyzing content patterns.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-09-03

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-03

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/z82rffe6jk)
- **Repository:** <https://github.com/jakewlittle-cs/substack-insights-mcp>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "jakewlittle-cs-substack-insights-mcp"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/jakewlittle-cs-substack-insights-mcp` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/jakewlittle-cs-substack-insights-mcp/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt