aashari/mail-triage

Mail Triage — Smart Priority Overview

Triaging: $ARGUMENTS (default: last 48 hours)

Step 1: Pull all candidate emails

DB="$HOME/Library/Mail/V10/MailData/Envelope Index"
SINCE=$(($(date +%s) - 172800))  # 48 hours; adjust per $ARGUMENTS

sqlite3 "$DB" "
SELECT datetime(m.date_received,'unixepoch','localtime') as dt,
       s.subject, a.address as sender, a.comment as name,
       mb.url as mailbox, m.ROWID,
       m.read, m.flagged, m.is_urgent, m.size, m.conversation_id,
       m.automated_conversation, m.unsubscribe_type
FROM messages m
JOIN subjects  s  ON m.subject = s.ROWID
JOIN addresses a  ON m.sender  = a.ROWID
JOIN mailboxes mb ON m.mailbox = mb.ROWID
WHERE m.date_received >= ${SINCE}
  AND m.deleted = 0
  AND mb.url NOT LIKE '%Spam%' AND mb.url NOT LIKE '%Trash%'
  AND mb.url NOT LIKE '%Junk%' AND mb.url NOT LIKE '%Sent%'
ORDER BY m.date_received DESC;" 2>/dev/null

Step 2: Score each email for priority

High priority signals (+points):

• is_urgent = 1: +10
• flagged = 1: +8
• read = 0: +3
• Subject contains: urgent, ASAP, action required, critical, deadline, review, approve: +5 each
• automated_conversation = 0 AND unsubscribe_type = 0 (likely real person): +4
• From work/EWS account: +2
• Large message (>50KB): +1 (likely real content)
• Subject contains reply indicators (RE:, FW:): +2

Low priority signals (−points):

• automated_conversation = 2 (bulk automated — newsletters, monitoring, CI/CD): −8
• unsubscribe_type > 0 (has List-Unsubscribe header — mailing list): −5
• Subject starts with PROBLEM:, OK:, ALARM:, CRIT: −8 (monitoring)
• Already read: −5

Compute a score per email, then bucket:

• Score ≥ 10: Critical
• Score 5–9: Important
• Score 1–4: Normal
• Score ≤ 0: Noise

Step 3: Read bodies for top-priority items

For Critical and Important emails (score ≥ 5):

python3 ~/.claude/skills/_mail-shared/parser.py <ROWID1> <ROWID2> ...

Extract key info: what is being asked, any deadlines, any amounts.

Step 4: Check for conversation context

For unread replies, check if it's a continuation of a thread you started:

sqlite3 "$DB" "
SELECT COUNT(*) FROM messages m
JOIN mailboxes mb ON m.mailbox=mb.ROWID
WHERE m.conversation_id=<CONV_ID>
  AND mb.url LIKE '%Sent%';" 2>/dev/null

If you sent something in this thread → higher priority (someone replied to you).

Output Format

Critical — Act Now: [list with 1-line context from body]

Important — Handle Today: [list with subject and sender]

Normal — Read When Convenient: [count + brief list]

Noise (filtered): X emails [breakdown: Y monitoring alerts, Z newsletters, W CI/CD]

Total: X emails in window. Estimated action time: [estimate based on count]. Offer to read any specific email or start replying.