tasks

/tasks — Task Management (SQLite-backed)

First: Read LEARNINGS.md (in this skill's directory) before proceeding.

Primary store: tasks.db (in workspace root). Markdown export at state/backlog.md (read-only, regenerated on changes).

Arguments: $ARGUMENTS

---

Routing

Input	Action
(empty) or status	Show Status
add <description>	Add Task
review	Review & Reprioritize
done T###	Complete Task
metrics	Show Metrics

---

Show Status

# Active tasks sorted by priority
sqlite3 ~/claude-assistant/tasks.db -header -column \
  "SELECT id, name, priority, status, effort, problems FROM tasks WHERE status != 'done' ORDER BY CASE priority WHEN 'P1' THEN 1 WHEN 'P2' THEN 2 WHEN 'P3' THEN 3 ELSE 4 END, id"

# Blocked tasks
sqlite3 ~/claude-assistant/tasks.db -header -column \
  "SELECT id, name, blocked_by, blocked_reason FROM tasks WHERE blocked_by IS NOT NULL AND status != 'done'"

# Counts
sqlite3 ~/claude-assistant/tasks.db \
  "SELECT (SELECT COUNT(*) FROM tasks WHERE status NOT IN ('done')) AS active, (SELECT COUNT(*) FROM tasks WHERE status='done') AS completed, (SELECT COUNT(*) FROM tasks WHERE blocked_by IS NOT NULL AND status != 'done') AS blocked"

Flag:

• Any P1 task not in_progress -- prompt to start it
• Any task in_progress for 7+ days (check updated_at) -- suggest reviewing

---

Add Task

1. Parse <description> from arguments
2. Get next ID: sqlite3 ~/claude-assistant/tasks.db "SELECT value FROM config WHERE key='next_id'"
3. Read knowledge/problems/00-overview.md to know the user's problems
4. Ask: which problems (by number) does this relate to? Effort (S/M/L)? Which subgoal?
5. Evaluate priority:
   • Problems >= 3 -- strong P1 candidate
   • Problems >= 2 + urgency -- P2
   • Problems == 1 or no urgency -- P3
   • Problems == 0 -- flag: "Is this drift?"
6. On approval, insert via sqlite3:

sqlite3 ~/claude-assistant/tasks.db "INSERT INTO tasks (id, name, priority, problems, effort, status, subgoal, created_at, updated_at) VALUES ('T###', 'Name', 'P2', '1,4', 'M', 'pending', 'S1', '$(date +%Y-%m-%d)', '$(date -u +%Y-%m-%dT%H:%M:%SZ)')"