weekly-reviewlisted

# /weekly-review — Weekly Dashboard Update ## Trigger User writes `/weekly-review` (typically on Mondays or Fridays). ## Behavior ### 1. Read sessions from the last 7 days ```bash find $DQIII8_ROOT/sessions/ -name "*.md" -newer <(date -d '7 days ago' +%Y-%m-%d) | sort ``` For each session: extract frontmatter (project, date) and "What we did" section (first bullet). ### 2. Read status of all projects Read `projects/*.md` — extract: title, status from YAML frontmatter, section "Next step". ### 3. Query week metrics ```sql SELECT COUNT(*), SUM(total_actions), SUM(total_errors), MAX(end_time) FROM sessions WHERE start_time >= datetime('now', '-7 days'); SELECT agent_name, COUNT(*) as n FROM agent_actions WHERE timestamp >= datetime('now', '-7 days') GROUP BY agent_name ORDER BY n DESC LIMIT 3; ``` ### 4. Regenerate `00_DASHBOARD.md` ```markdown --- title: DQIII8 Dashboard date_updated: YYYY-MM-DD HH:MM week_number: W[N] YYYY --- # DQIII8 Dashboard ## Project Status | Project | Status | Latest progress | Next step | |---------|--------|-----------------|-----------| ## Sessions this week - YYYY-MM-DD · [project] — [1-liner] ## Metrics | Metric | Value | |--------|-------| | Total sessions | N | | Success rate | N% | | Most used agent | [name] (N actions) | ``` ### 5. Git push ```bash git -C $DQIII8_ROOT add 00_DASHBOARD.md sessions/ git -C $DQIII8_ROOT commit -m "docs: weekly review week W[N]" git -C $DQIII8_ROOT push origin main ``` ### 6. Feedback ``` [WEEKLY] Das