aashari/mail-thread

Mail Thread — Read a Full Email Conversation

Thread: $ARGUMENTS

Step 1: Find the thread

Option A: Search by subject keyword

DB="$HOME/Library/Mail/V10/MailData/Envelope Index"
QUERY="<extracted from $ARGUMENTS>"

sqlite3 "$DB" "
SELECT m.ROWID, m.conversation_id, s.subject,
       datetime(m.date_received,'unixepoch','localtime') as dt,
       a.address as sender
FROM messages m
JOIN subjects  s ON m.subject = s.ROWID
JOIN addresses a ON m.sender  = a.ROWID
WHERE s.subject LIKE '%${QUERY}%' AND m.deleted=0
ORDER BY m.date_received DESC LIMIT 10;" 2>/dev/null

Option B: If ROWID provided directly

sqlite3 "$DB" "
SELECT conversation_id FROM messages WHERE ROWID = <ROWID>;" 2>/dev/null

Step 2: Get all messages in the thread by conversation_id

CONV_ID=<from step 1>

sqlite3 "$DB" "
SELECT m.ROWID,
       datetime(m.date_received,'unixepoch','localtime') as dt,
       a.address as sender, a.comment as name,
       s.subject, mb.url as mailbox, m.read
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.conversation_id = ${CONV_ID}
  AND m.deleted = 0
ORDER BY m.date_received ASC;" 2>/dev/null

Step 3: Read all message bodies

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

Step 4: Reconstruct the conversation

Present chronologically:

• Who sent each message and when
• Key content of each message (summarize long ones, quote short ones)
• Reply chain structure

Step 5: Summarize the thread

After showing the conversation:

• What was the original question/issue?
• What was discussed/debated?
• What was decided or concluded?
• Are there any open questions or pending actions?
• Who is waiting on whom?

Output Format

Thread: [Subject] [N messages | started: date | participants: list]

---

[Date] [Sender Name] [→ Reply to: ...]

[message content, summarized if long]

---

[repeat for each message]

---

Summary: [2-3 sentence summary of the thread outcome]

Status: [Resolved / Ongoing / Waiting for response] Next action: [if any]