mail-top-senders
Show who sends the most email, communication frequency analysis, and relationship mapping. Use when user asks who emails them most, top contacts, communication patterns, or wants to understand their email social graph. Arguments: optional time range (default: last 90 days), account filter, or "humans only" to exclude automated senders.
npx skills add majiayu000/claude-skill-registry --skill mail-top-senders --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Mail Top Senders — Communication Frequency Analysis Analysis period: **$ARGUMENTS** (default: last 90 days) ## Step 1: All senders ranked by volume ```bash DB="$HOME/Library/Mail/V10/MailData/Envelope Index" SINCE=$(($(date +%s) - 7776000)) # 90 days sqlite3 "$DB" " SELECT a.address, a.comment as name, COUNT(*) as total, SUM(CASE WHEN m.read=0 THEN 1 ELSE 0 END) as unread, MIN(datetime(m.date_received,'unixepoch','localtime')) as first, MAX(datetime(m.date_received,'unixepoch','localtime')) as latest FROM messages m 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 '%Sent%' GROUP BY a.address ORDER BY total DESC LIMIT 50;" 2>/dev/null ``` ## Step 2: Separate humans from automated senders Use `automated_conversation` and `unsubscribe_type` columns (more reliable than address-pattern matching): - `automated_conversation = 0` + `unsubscribe_type = 0` → real humans - `automated_conversation = 1` → transactional (Jira, Slack, alerts) - `automated_conversation = 2` OR `unsubscribe_type > 0` → bulk/newsletters (noise) ```bash #
- Step 1: All senders ranked by volume
- Step 2: Separate humans from automated senders
- Step 3: Domain-level analysis
- Step 4: Thread participation (two-way communication)
- Output Format
sqlite3 "$DB" "
SELECT a.address, a.comment as name,
FROM messages m
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 '%Sent%'
GROUP BY a.addressWhat does the mail-top-senders skill do?
Show who sends the most email, communication frequency analysis, and relationship mapping. Use when user asks who emails them most, top contacts, communication patterns, or wants to understand their email social graph. Arguments: optional time range (default: last 90 days), account filter, or "humans only" to exclude automated senders.
How do I install it?
Run `npx skills add majiayu000/claude-skill-registry --skill mail-top-senders --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From majiayu000/claude-skill-registry, a repository with 534 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.