Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
SUBSTACK_PUBLICATION_URLYesThe base URL of the Substack publication to archive (e.g., https://your-publication.substack.com).
SUBSTACK_INSIGHTS_DB_PATHYesFilesystem path to the SQLite database file (e.g., ./data/substack-insights.sqlite).

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Latest Blog Posts

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