social-autoposter

Automated social posting pipeline for Reddit, X/Twitter, LinkedIn, and Moltbook. Install as an AI agent skill or use the standalone Python scripts.

The current storage backend is Neon Postgres via DATABASE_URL in ~/social-autoposter/.env. Any legacy database key in old local configs or leftover *.db files are not used by the current scripts.

Install as a skill

npx social-autoposter init

Then tell your agent: "set up social autoposter" — the setup skill walks you through config, DB creation, browser logins, and a test run.

To update scripts without touching your config or database:

npx social-autoposter update

Or set up manually:

cp config.example.json config.json   # edit with your accounts
psql "$DATABASE_URL" -f schema-postgres.sql  # initialize the Neon DB
bash setup.sh                        # symlinks + launchd (macOS)

How it works

SKILL.md (the playbook)
    │
    ├── /social-autoposter        → find thread, draft, post, log
    ├── /social-autoposter stats  → update engagement via API
    ├── /social-autoposter engage → scan replies, respond
    └── /social-autoposter audit  → browser-based full audit
    │
    ├── scripts/find_threads.py   → thread discovery (no browser)
    ├── scripts/scan_replies.py   → reply scanning (no browser)
    └── scripts/update_stats.py   → stats fetching (no browser)
    │
    ├── skill/run.sh              → launchd wrapper (hourly)
    ├── skill/stats.sh            → launchd wrapper (6-hourly)
    └── skill/engage.sh           → launchd wrapper (2-hourly)

Structure

social-autoposter/
├── SKILL.md               <- skill playbook (generic, publishable)
├── config.example.json    <- config template (accounts, subreddits, content angle)
├── schema-postgres.sql    <- Neon Postgres DB schema
├── setup.sh               <- creates symlinks, loads launchd agents
├── setup/
│   └── SKILL.md           <- interactive setup wizard skill
├── scripts/
│   ├── db.py              <- Neon Postgres connection wrapper
│   ├── find_threads.py    <- find candidate threads via Reddit/Moltbook API
│   ├── scan_replies.py    <- scan for new replies to our posts via API
│   └── update_stats.py    <- fetch engagement stats via API
├── skill/
│   ├── SKILL.md           <- personal skill (hardcoded accounts)
│   ├── run.sh             <- hourly posting (launchd wrapper)
│   ├── stats.sh           <- 6-hourly stats (launchd wrapper)
│   ├── engage.sh          <- 2-hourly engagement (launchd wrapper)
│   └── logs/              <- runtime logs (gitignored)
└── launchd/               <- macOS LaunchAgent plists

For other AI agents

The skill is designed to work with any agent that has:

• Shell access (to run Python scripts and psql)
• Browser automation (Playwright, Selenium, etc. for posting)
• An LLM (for drafting comments in the right tone)

The Python scripts handle thread discovery, reply scanning, and stats updates without needing a browser or LLM. The SKILL.md is the playbook — any agent reads it and executes the workflows with its own tools.

Accounts

• Reddit: u/Deep_Ad1959
• X/Twitter: @m13v_
• LinkedIn: Matthew Diakonov
• Moltbook: matthew-autoposter