substack-insights-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SUBSTACK_PUBLICATION_URL | Yes | The base URL of the Substack publication to archive (e.g., https://your-publication.substack.com). | |
| SUBSTACK_INSIGHTS_DB_PATH | Yes | Filesystem path to the SQLite database file (e.g., ./data/substack-insights.sqlite). |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| connection_statusA | Show publication configuration, local ledger counts, and synchronization freshness. |
| sync_publicationA | Import the publication's public RSS archive into the local immutable ledger. No credentials are used. |
| list_postsA | List canonical post records and content-version digests. This omits full bodies; use get_post for exact content. |
| get_postA | Return the canonical record and latest immutable content version for a local id, remote id, slug, canonical URL, or exact title. |
| list_post_versionsA | Return the stored content-version history for one post, newest first, including exact bodies and SHA-256 digests. |
| list_audit_eventsA | Return timestamped RSS imports and local content changes, optionally scoped to one post. |
| record_metric_snapshotA | Store timestamped metrics obtained from Substack's official MCP against an existing post. Never enter estimates. |
| get_post_performanceA | Return the latest derived performance rates plus every stored raw metric snapshot for one post. |
| compare_postsA | Rank posts using normalized, deterministic rates from each post's latest stored snapshot. |
| analyze_content_patternsA | Calculate correlations between performance and word count, title length, and UTC send hour. Requires at least three measured posts. |
| create_local_draftA | Create local Markdown content in the immutable ledger. This never contacts or publishes to Substack. |
| update_local_draftA | Update selected local draft fields by appending an immutable version. Existing sent versions cannot be changed. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/jakewlittle-cs/substack-insights-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server