Help us improve
Share bugs, ideas, or general feedback.
From my-workflow
Generates weekly (default), monthly, or custom-period workflow reviews summarizing sessions, commitments, decisions, goals progress, activity timeline, and commits from local SQLite database.
npx claudepluginhub mwguerra/claude-code-pluginsHow this command is triggered — by the user, by Claude, or both
Slash command
/my-workflow:reviewThis command is limited to the following tools:
The summary Claude sees in its command listing — used to decide when to auto-load this command
# Workflow Review Command Generate comprehensive reviews of your workflow activity. ## Usage ## Database Location ## Data to Gather ### Sessions ### Commitments ### Decisions ### Goals Progress ### Activity Timeline ### Commits (from sessions) ## Output Format ## Vault Sync If vault integration is enabled, save the review:
/reviewGenerates weekly, monthly, or custom productivity reviews with session metrics, commitment progress, accomplishments, active items, and recommendations from the secretary database.
/SKILLConducts weekly review: reads project data and git log for last 7 days, analyzes tasks/goals, reports accomplishments, progress, Eisenhower matrix, stale items, and next-week recommendations.
/my-weekGenerates a markdown summary of your accomplishments, collaborations, and key activities over an optional time period (default: past week).
/lavra-retroGenerates a markdown retrospective report analyzing git commits, PRs, team performance, shipping stats, and knowledge synthesis for a specified time window. Saves JSON snapshot for trend tracking.
/weekly-summaryGenerates markdown weekly git activity summary with commits, PRs, lines changed, files touched, categorized accomplishments by features/bugs/maintenance/projects across multiple repos.
/reviewInvokes external AI CLIs (Gemini, Claude, Codex, OpenCode, Qwen, Cursor) to peer review specified phase plans, producing structured REVIEWS.md with feedback.
Share bugs, ideas, or general feedback.
Generate comprehensive reviews of your workflow activity.
/workflow:review # Weekly review (default)
/workflow:review weekly # Explicit weekly review
/workflow:review monthly # Monthly review
/workflow:review custom 14 # Custom period (days)
DB_PATH="$HOME/.claude/my-workflow/workflow.db"
SELECT
COUNT(*) as total_sessions,
SUM(duration_seconds) as total_duration,
AVG(duration_seconds) as avg_duration,
COUNT(DISTINCT project) as projects_touched,
COUNT(DISTINCT date(started_at)) as days_active
FROM sessions
WHERE started_at >= datetime('now', '-7 days');
-- Completed this period
SELECT COUNT(*) as completed
FROM commitments
WHERE completed_at >= datetime('now', '-7 days');
-- Created this period
SELECT COUNT(*) as created
FROM commitments
WHERE created_at >= datetime('now', '-7 days');
-- Still pending (created before period)
SELECT COUNT(*) as carryover
FROM commitments
WHERE created_at < datetime('now', '-7 days')
AND status NOT IN ('completed', 'canceled');
SELECT id, title, category, project, created_at
FROM decisions
WHERE created_at >= datetime('now', '-7 days')
ORDER BY created_at DESC;
SELECT
id, title, goal_type,
progress_percentage as current_progress,
-- Calculate progress delta (would need history table for accuracy)
progress_percentage as progress_delta
FROM goals
WHERE status = 'active'
ORDER BY progress_percentage DESC;
SELECT
activity_type,
COUNT(*) as count
FROM activity_timeline
WHERE timestamp >= datetime('now', '-7 days')
GROUP BY activity_type
ORDER BY count DESC;
SELECT
project,
COUNT(*) as session_count,
SUM(json_array_length(commits)) as commit_count
FROM sessions
WHERE started_at >= datetime('now', '-7 days')
AND commits IS NOT NULL
GROUP BY project
ORDER BY commit_count DESC;
# Weekly Workflow Review
**Period:** Jan 20 - Jan 27, 2024
**Generated:** Jan 27, 2024 10:30 AM
## Summary
| Metric | This Week | Previous |
|--------|-----------|----------|
| Sessions | 15 | 12 |
| Time Invested | 24h 30m | 20h 15m |
| Commitments Completed | 8 | 6 |
| Decisions Made | 5 | 3 |
| Projects | 3 | 2 |
## Commitments
### Completed (8)
- [C-0012] Implemented user auth
- [C-0011] Fixed pagination bug
- [C-0010] Updated API docs
- ... (5 more)
### Created (12)
- [C-0020] Add caching layer
- [C-0019] Refactor services
- ... (10 more)
### Carryover (5)
*Items from previous periods still pending:*
- [C-0005] Review architecture proposal - 14 days old
- [C-0003] Update deployment scripts - 21 days old
## Decisions Made
| ID | Decision | Category | Project |
|----|----------|----------|---------|
| D-0015 | Use Redis for caching | technology | api-service |
| D-0014 | Adopt conventional commits | process | (global) |
## Goal Progress
- [G-0001] MVP Launch [==========-] 95% (+15%)
- [G-0002] Test Coverage [======----] 60% (+10%)
- [G-0003] Documentation [===-------] 30% (+5%)
## Project Breakdown
### claude-code-plugins
- Sessions: 8
- Duration: 14h 20m
- Commits: 23
### api-service
- Sessions: 5
- Duration: 8h 10m
- Commits: 15
### website
- Sessions: 2
- Duration: 2h
- Commits: 5
## Productivity Patterns
### Most Productive Times
- Morning (9-12): 45% of sessions
- Afternoon (13-17): 35% of sessions
- Evening (18+): 20% of sessions
### Session Length Distribution
- Short (<30m): 5 sessions
- Medium (30m-2h): 7 sessions
- Long (>2h): 3 sessions
## Recommendations
Based on this week's activity:
1. **Address Carryover** - 5 items have been pending for 2+ weeks
2. **Goal Focus** - Documentation goal is lagging, consider prioritizing
3. **Time Boxing** - Average session is 1h 38m, consider shorter focused sessions
---
*Review generated by my-workflow plugin*
If vault integration is enabled, save the review:
VAULT_PATH=$(jq -r '.vaultPath' ~/.claude/obsidian-vault.json)
WORKFLOW_FOLDER="$VAULT_PATH/workflow/reviews"
mkdir -p "$WORKFLOW_FOLDER"
FILENAME="review-$(date +%Y-%m-%d).md"
# Write review content to file