taskslisted

# /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 ```bash # 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