From article-writer
Manages SQLite article task queue: add tasks, filter by author/language, update status, track multi-language outputs via Bun CLI scripts.
How this skill is triggered — by the user, by Claude, or both
Slash command
/article-writer:queueThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Manage the article queue stored in the SQLite database (`.article_writer/article_writer.db`).
Manage the article queue stored in the SQLite database (.article_writer/article_writer.db).
All data is stored in the articles table of the SQLite database. Use the provided scripts for all operations:
# Queue summary
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts status
# List articles (with filters)
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list [filter]
# Show article details
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts show <id>
# Stats and operations
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --summary
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --get <id>
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/article-stats.ts --set-status <status> <id>
See references/schema-reference.md for fields.
Articles reference authors via author_id, author_name, and author_languages columns:
{
"author_id": "mwguerra",
"author_name": "MW Guerra",
"author_languages": ["pt_BR", "en_US"]
}
If author not specified, the default author (lowest sort_order) is used.
{
"output_folder": "content/articles/2025_01_15_rate-limiting/",
"output_files": [
{
"language": "pt_BR",
"path": "content/articles/2025_01_15_rate-limiting/rate-limiting.pt_BR.md",
"translated_at": "2025-01-15T14:00:00Z"
},
{
"language": "en_US",
"path": "content/articles/2025_01_15_rate-limiting/rate-limiting.en_US.md",
"translated_at": "2025-01-15T16:00:00Z"
}
]
}
created_at: When task was added to queuewritten_at: When primary article was completedpublished_at: When article went liveupdated_at: Last modificationbun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts status
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list author:mwguerra
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list lang:en_US
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts update <id> status:draft
Update the output_files JSON column with additional language entries.
pending -> in_progress -> draft -> review -> published
|
archived
When adding tasks without author:
SELECT * FROM authors ORDER BY sort_order ASC LIMIT 1Before processing:
npx claudepluginhub mwguerra/claude-code-plugins --plugin article-writerManage a deferred task queue — add, list, process, remove, batch-execute, schedule, prioritize, and browse history of tasks stored in the vault.
Guides sqlite3 CLI usage to build composable SQLite knowledge databases, design schemas, query data, manage relationships, and output for agent parsing.
Guides usage of bunqueue job queue for Bun with SQLite persistence, covering Queue, Worker, Bunqueue simple mode, FlowProducer, cron, DLQ, and embedded/TCP modes.