DB="$HOME/Library/Mail/V10/MailData/Envelope Index"
SINCE=$(($(date +%s) - 604800))  # 7 days; 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
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 (
    s.subject LIKE '%invitation%'
    OR s.subject LIKE '%invite%'
    OR s.subject LIKE '%meeting%'
    OR s.subject LIKE '%standup%'
    OR s.subject LIKE '%retro%'
    OR s.subject LIKE '%sync%'
    OR s.subject LIKE '%call%'
    OR s.subject LIKE '%agenda%'
    OR s.subject LIKE '%(Updated invitation)%'
    OR s.subject LIKE '%has invited you%'
    OR s.subject LIKE '%calendar%'
    OR s.subject LIKE '%@ %'
    OR a.address LIKE '%calendar%'
    OR a.address LIKE '%gemini-notes%'
    OR a.address LIKE '%meet-recordings%'
  )
ORDER BY m.date_received DESC;" 2>/dev/null

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