mcpField
Q
queue

queue

github.com/mwguerraProductivity3636 installsUpdated 26w ago
Repository

About queue

queue is a skill for managing article records in a SQLite-backed queue through provided scripts. It supports filtering by author or language and tracking articles through publication statuses.

Key features

  1. 01View queue status and article details
  2. 02Filter articles by author or language
  3. 03Update article status
  4. 04Track authors, languages, and output files
  5. 05Validate author and language settings

Use cases

  1. 01Review pending articles and queue status
  2. 02Find articles for a specific author or language
  3. 03Mark an article as draft after writing
  4. 04Maintain multilingual article output records

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/mwguerra/claude-code-plugins --skill queue

After installing, type/queuein Claude Code to confirm it loaded.

Bundled filesreferences/schema-reference.md

Details

From the project README

Article Queue

Manage the article queue stored in the SQLite database (.article_writer/article_writer.db).

Data Access

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>

Schema Reference

See references/schema-reference.md for fields.

Key Fields

Author Reference

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 Files (per language)
{
  "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"
    }
  ]
}
Timestamps
  • created_at: When task was added to queue
  • written_at: When primary article was completed
  • published_at: When article went live
  • updated_at: Last modification

Operations

Status Summary
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts status
Filter by Author
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list author:mwguerra
Filter by Language
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts list lang:en_US
Update After Writing
bun run "${CLAUDE_PLUGIN_ROOT}"/scripts/queue.ts update <id> status:draft
Add Translation

Update the output_files JSON column with additional language entries.

Status Flow

pending -> in_progress -> draft -> review -> published
               |
           archived

Default Author

When adding tasks without author:

  1. Query default author: SELECT * FROM authors ORDER BY sort_order ASC LIMIT 1
  2. Store author_id, author_name, author_languages in article record

Validation

Before processing:

  • Verify author_id exists in authors table
  • Validate languages are subset of author's languages
  • Check all required fields present

Comments

Markdown supported