content-workflow: Skill for Claude Code

Review -- Morning Batch Content Review

Interactive morning review workflow for KEEP/SKIP/STAR decisions on discovered content ideas. One focused pass through the backlog, ~5 minutes, then hand off to content generation.

Workflow

When /review is invoked, execute the following steps in order.

---

Step 1: Check for today's review file

Run:

cat data/review/$(date +%Y-%m-%d).md 2>/dev/null

If the file exists, display a brief summary to Robin:

"Today's pulse found {N} ideas. Here's the overview:"

Then show the file content (or a condensed version with titles and sources).

If no file exists, tell Robin:

"No pulse has run today. Run /pulse first, or I can review ideas from previous days."

Continue to Step 2 regardless — there may be pending ideas in the DB from earlier pulse runs.

---

Step 2: Query pending ideas from the database

Run:

node -e "
  const db = require('better-sqlite3')('data/content.db');
  const ideas = db.prepare(\"SELECT id, title, summary, source_url, source_type, score, status, transcript FROM ideas WHERE status IN ('new', 'starred') ORDER BY score DESC\").all();
  console.log(JSON.stringify(ideas));
  db.close();
"

Parse the JSON output. If the array is empty, tell Robin:

"No pending ideas to review. All caught up! Run /pulse to discover new ideas."

Stop here if nothing to review.

---

Step 3: Present ideas and collect decisions

Initialize counters: kept=0, skipped=0, starred=0, remaining=total_count.

For each idea (iterate in order, score DESC):

Display this format:

--- Idea {N}/{total} ---

{title}

Source: {source_type} | {source_url}
Angle:  {content_angle_suggestion}

> {summary}

[Transcript available: yes/no]

Content angle suggestion logic (evaluate in order, first match wins):

• source_type === 'changelog' → "News reaction"
• title contains (case-insensitive) "tutorial", "how to", "guide", or "learn" → "Tutorial breakdown"
• title contains (case-insensitive) "wrong", "actually", "unpopular", "hot take", or "controversial" → "Hot take"
• title contains (case-insensitive) "vs", "compare", "comparison", or "better" → "Comparison"
• default → "Topic breakdown"