workflow-executive

# Workflow Executive Skill

Analyze productivity, prioritize work, and provide strategic recommendations.

## When to Use

- User asks "What's most important?"
- User asks "How am I doing?"
- User wants productivity analysis
- Generating weekly/monthly reviews
- Detecting bottlenecks or issues
- Recommending focus areas

## Database Location

```bash
DB_PATH="$HOME/.claude/my-workflow/workflow.db"
```

## Work Prioritization

### Priority Scoring

Score each commitment by multiple factors:

```sql
SELECT
    c.id, c.title, c.due_date, c.priority, c.project,
    -- Urgency score (0-100)
    CASE
        WHEN c.due_date < date('now') THEN 100
        WHEN c.due_date = date('now') THEN 80
        WHEN c.due_date <= date('now', '+2 days') THEN 60
        WHEN c.due_date <= date('now', '+7 days') THEN 40
        ELSE 20
    END as urgency,
    -- Priority score (0-40)
    CASE c.priority
        WHEN 'critical' THEN 40
        WHEN 'high' THEN 30
        WHEN 'medium' THEN 20
        ELSE 10
    END as priority_score,
    -- Stakeholder score (0-20)
    CASE WHEN c.stakeholder IS NOT NULL THEN 20 ELSE 0 END as stakeholder_score,
    -- Deferral penalty (-10 per deferral)
    -10 * c.deferred_count as deferral_penalty
FROM commitments c
WHERE c.status IN ('pending', 'in_progress')
ORDER BY (urgency + priority_score + stakeholder_score + deferral_penalty) DESC;
```

### Eisenhower Matrix

Categorize work:

```
URGENT + IMPORTANT     → Do First
NOT URGENT + IMPORTANT → Schedule
URGENT + NOT IMPORTANT → Delegate
NOT URGENT + NOT IMPORTANT → Eliminate
```

## Productivity Analysis

### Session Metrics

```sql
-- Daily summary
SELECT
    date(started_at) as date,
    COUNT(*) as sessions,
    SUM(duration_seconds) / 3600.0 as hours,
    AVG(duration_seconds) / 60.0 as avg_minutes
FROM sessions
WHERE started_at >= datetime('now', '-30 days')
GROUP BY date(started_at);
```

### Completion Rates

```sql
-- Weekly completion rate
SELECT
    strftime('%Y-%W', created_at) as week,