apple-mail-search
by mneves75
Apple Apps & ServicesBrief
Fast Apple Mail search via SQLite on macOS.
Description
What This Skill Does
Searches Apple Mail emails by querying the local SQLite database directly. Returns results in ~50ms across large mailboxes. Read-only, macOS only, works with Mail.app metadata.
Queries the SQLite Envelope Index directly, bypassing AppleScript iteration and Spotlight (broken since Big Sur), making large mailbox searches ~10,000x faster.
When to Use It
- Find an invoice email by subject keyword
- List all unread emails as JSON for scripting
- Search emails from a specific sender domain
- Export last 30 days of emails to CSV
- Locate all emails with PDF attachments
Example Workflow
User asks: find all PDF attachments from bank of america in the last 30 days
- 1
Run mail-search sender "@bankofamerica.com" -n 100 to get recent sender matches
- 2
Pipe output through grep -i pdf or use mail-search attachment-type pdf separately
- 3
Combine with mail-search recent 30 to narrow date range
- 4
Format results with --json flag for structured output
List of matching emails with subject, date, and attachment metadata
Installation
clawhub install mneves75/apple-mail-searchRun the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.