Executive Skill

Analyze productivity, prioritize work, detect patterns, and generate strategic recommendations.

When to Use

• User asks "What's most important?" or "What should I focus on?"

• User asks "How am I doing?" or "How productive have I been?"

• User wants productivity analysis (daily, weekly, monthly)

• Generating weekly or monthly strategic reviews

• Detecting bottlenecks, stagnation, or work distribution issues

• Recommending focus areas or schedule adjustments

• User asks about patterns or trends in their work

• User wants goal progress assessment or risk analysis

Database Location

SECRETARY_DB_PATH="$HOME/.claude/secretary/secretary.db"

Work Prioritization

Priority Scoring

Score each commitment by multiple weighted factors:

SELECT c.id, c.title, c.due_date, c.priority, c.project, c.stakeholder, -- Urgency (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 weight (0-40) CASE c.priority WHEN 'critical' THEN 40 WHEN 'high' THEN 30 WHEN 'medium' THEN 20 ELSE 10 END as priority_score, -- Stakeholder factor (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

-- Daily summary (last 30 days) SELECT date(started_at) as date, COUNT(*) as sessions, SUM(duration_seconds) / 3600.0 as hours, AVG(duration_seconds) / 60.0 as avg_minutes, COUNT(DISTINCT project) as projects FROM sessions WHERE started_at >= datetime('now', '-30 days') AND status = 'completed' GROUP BY date(started_at) ORDER BY date DESC;

Completion Rates

-- Weekly completion rate (last 90 days) SELECT strftime('%Y-%W', created_at) as week, COUNT() as created, SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) as completed, ROUND(100.0 * SUM(CASE WHEN status = 'completed' THEN 1 ELSE 0 END) / COUNT(), 1) as rate, SUM(CASE WHEN status = 'deferred' THEN 1 ELSE 0 END) as deferred, SUM(CASE WHEN status = 'canceled' THEN 1 ELSE 0 END) as canceled FROM commitments WHERE created_at >= datetime('now', '-90 days') GROUP BY week ORDER BY week DESC;

Time Distribution

-- Where is time going? (last 7 days) SELECT project, SUM(duration_seconds) / 3600.0 as hours, ROUND(100.0 * SUM(duration_seconds) / ( SELECT SUM(duration_seconds) FROM sessions WHERE started_at >= datetime('now', '-7 days') AND status = 'completed' ), 1) as percentage, COUNT(*) as sessions FROM sessions WHERE started_at >= datetime('now', '-7 days') AND status = 'completed' GROUP BY project ORDER BY hours DESC;

Decision Velocity

-- How often decisions are being made SELECT strftime('%Y-%W', created_at) as week, COUNT(*) as total, SUM(CASE WHEN category = 'architecture' THEN 1 ELSE 0 END) as architecture, SUM(CASE WHEN category = 'technology' THEN 1 ELSE 0 END) as technology, SUM(CASE WHEN category = 'process' THEN 1 ELSE 0 END) as process, SUM(CASE WHEN category = 'design' THEN 1 ELSE 0 END) as design FROM decisions WHERE created_at >= datetime('now', '-90 days') GROUP BY week ORDER BY week DESC;

Goal Tracking

Progress Velocity

SELECT g.id, g.title, g.goal_type, g.progress_percentage, g.target_date, g.target_value, g.current_value, g.target_unit, -- Days remaining ROUND(julianday(g.target_date) - julianday('now'), 0) as days_remaining, -- Required daily progress ROUND((100 - g.progress_percentage) / NULLIF(julianday(g.target_date) - julianday('now'), 0), 2) as required_daily, -- Risk status CASE WHEN g.target_date < date('now') AND g.progress_percentage < 100 THEN 'overdue' WHEN (100 - g.progress_percentage) / NULLIF(julianday(g.target_date) - julianday('now'), 0) > 5 THEN 'at_risk' WHEN (100 - g.progress_percentage) / NULLIF(julianday(g.target_date) - julianday('now'), 0) > 2 THEN 'needs_attention' ELSE 'on_track' END as risk_status FROM goals g WHERE g.status = 'active' AND g.target_date IS NOT NULL ORDER BY days_remaining ASC;

Bottleneck Detection

Long-Pending Items

SELECT id, title, priority, project, ROUND(julianday('now') - julianday(created_at), 0) as days_pending FROM commitments WHERE status = 'pending' ORDER BY days_pending DESC LIMIT 10;

Frequently Deferred

SELECT id, title, deferred_count, priority, project FROM commitments WHERE deferred_count >= 2 AND status NOT IN ('completed', 'canceled') ORDER BY deferred_count DESC;

Blocked Work

-- Items that have been in_progress for a long time SELECT id, title, priority, project, ROUND(julianday('now') - julianday(updated_at), 0) as days_stale FROM commitments WHERE status = 'in_progress' AND updated_at < datetime('now', '-7 days') ORDER BY days_stale DESC;

Pattern Integration

Use detected patterns to inform recommendations:

SELECT id, title, pattern_type, category, confidence, evidence_count, recommendations, frequency FROM patterns WHERE status = 'active' AND confidence >= 0.6 ORDER BY confidence DESC, evidence_count DESC;

Apply insights:

• Productivity timing - Schedule important work during peak hours

• Work style - Recommend process improvements

• Completion patterns - Adjust estimation and scheduling

• Context switching - Recommend focus blocks

• Deferral patterns - Flag items that need attention or elimination

Output Guidelines

Priority Report

Work Priorities

Do Today

1. [C-0001] Fix auth bug - Overdue, critical

   • Stakeholder: Product team
   • Estimated: 2 hours

2. [C-0003] Review PR - Due today

   • Impact: Team velocity

Schedule This Week

3. [G-0002] API integration - Goal at risk (60%)
   • Required: +8%/day
4. [C-0005] Update docs - Low urgency, high value

Consider Dropping

• [C-0010] Research task - 3x deferred, low impact

Strategic Review

Weekly Review

Metrics

Concerns

1. Carryover growing - 8 items >2 weeks
2. Goal G-0003 at risk - needs 20%/week
3. Context switching - 5 projects in 7 days

Recommendations

1. Clear backlog tomorrow (2h)
2. Documentation sprint Wednesday
3. Weekly planning Friday

Wins

• Morning productivity pattern continues
• Test coverage improving steadily

Review Types

Weekly Focus

• Top 3 priorities for the week

• Carryover items analysis

• Goal trajectory check

• Time allocation review

• Pattern-based scheduling suggestions

Monthly Strategy

• Progress on major objectives

• Decision patterns analysis (categories, reversal rate)

• Productivity trends (velocity, efficiency)

• Knowledge graph growth

• Recommendation adjustments

Recommendation Categories

• Immediate Actions - What to do right now

• Scheduling - When to do what, based on data

• Process Changes - How to improve workflows

• Risk Mitigation - What to watch for

• Celebration - What went well (motivation matters)

Error Handling

• Handle empty datasets gracefully ("Not enough data yet for analysis")

• Provide default recommendations when data is sparse

• Note when analysis is based on limited data

• Degrade gracefully if specific tables have no rows

Related Commands

• /secretary:review

• Generate weekly or monthly review

• /secretary:patterns

• View detected work patterns

• /secretary:goals

• Manage and track goals

• /secretary:status

• Full dashboard with metrics

• /secretary:priorities

• Ranked priority list