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

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)')"

7. Increment next_id: sqlite3 ~/claude-assistant/tasks.db "UPDATE config SET value='T###' WHERE key='next_id'"
8. Re-export: python3 ~/claude-assistant/scripts/db.py export

Review & Reprioritize

1. Show all active tasks
2. Read knowledge/problems/00-overview.md and knowledge/user/goals.md
3. For each task: priority still correct? Stale? Blocking others? Connected to active subgoal?
4. Present proposed changes: | ID | Current P | Proposed P | Reason |
5. On approval, update and re-export

Complete Task

1. Parse task ID
2. Update:

sqlite3 ~/claude-assistant/tasks.db "UPDATE tasks SET status='done', completed_at='$(date +%Y-%m-%d)', updated_at='$(date -u +%Y-%m-%dT%H:%M:%SZ)' WHERE id='T###'"

3. Re-export: python3 ~/claude-assistant/scripts/db.py export
4. Show: task name, problems addressed, days from created to done
5. Suggest next task based on priority

Show Metrics

# Completed this week
sqlite3 ~/claude-assistant/tasks.db "SELECT COUNT(*) as done_this_week FROM tasks WHERE status='done' AND completed_at >= date('now', '-7 days')"

# Active count by priority
sqlite3 ~/claude-assistant/tasks.db "SELECT priority, COUNT(*) as count FROM tasks WHERE status != 'done' GROUP BY priority ORDER BY priority"

# Average days to complete
sqlite3 ~/claude-assistant/tasks.db "SELECT ROUND(AVG(julianday(completed_at) - julianday(created_at)), 1) as avg_days FROM tasks WHERE status='done' AND completed_at IS NOT NULL"

Task Conventions

• IDs: T + 3-digit counter (T001, T002, ...), monotonic, never reused
• Priority: P1 (now), P2 (this week), P3 (this month), BL (backlog)
• Effort: S (< 1 session), M (2-3 sessions), L (4+ sessions)
• Status: pending, in_progress, done, blocked
• Problems: comma-separated numbers referencing the user's 12 problems
• Subgoal: S1, S2, etc. from goals.md

Before Substantive Work

When the user requests work that will take more than ~5 minutes:

1. Check active tasks -- does this map to one?
2. If NO -- flag: "This doesn't map to an active task. Want to add it, or continue anyway?"
3. If the work touches zero problems -- flag: "This isn't connected to any of your problems. Proceed?"