Apple Mail (Fast & Safe)

Fast SQLite search for Apple Mail.app emails with body content support.

✨ Highlights:

•Safe DB access: Copies database to temp file before querying — won't corrupt if Mail.app is running
•Body content support: Read full email bodies via AppleScript (slow for thousands, but instant for a few)
•~50ms queries: SQLite vs 8+ minutes with pure AppleScript
•Note: This tool searches/reads Apple Mail.app only. Use himalaya skill to send emails.

Installation

Get the script: apple-mail-search-cli/fruitmail

Option 1: Copy to PATH (standard)

bash

# Download and copy to your PATH
cp fruitmail /usr/local/bin/
chmod +x /usr/local/bin/fruitmail

Option 2: Clone and symlink (recommended)

bash

# Clone the repo and symlink the script
git clone https://github.com/gumadeiras/apple-mail-search-cli.git
sudo ln -sf $(pwd)/apple-mail-search-cli/fruitmail /usr/local/bin/fruitmail
# Pull updates with: cd apple-mail-search-cli && git pull

Usage

bash

fruitmail search --subject "invoice" --unread # Unified search
fruitmail subject "invoice"          # Shortcut
fruitmail sender "@amazon.com"       # Shortcut
fruitmail from-name "John"           # Shortcut
fruitmail to "recipient@example.com" # Shortcut
fruitmail unread                     # Shortcut
fruitmail attachments                # Shortcut
fruitmail attachment-type pdf        # Shortcut
fruitmail recent 7                   # Shortcut
fruitmail date-range 2025-01-01 2025-01-31
fruitmail open 12345                 # Open email in Mail.app
fruitmail body 12345                 # Read full email body (AppleScript)
fruitmail stats                      # Database statistics

Options

code

-n, --limit N     Max results (default: 20)
-j, --json        Output as JSON
-c, --csv         Output as CSV
-q, --quiet       No headers
--db PATH         Override database path
--copy            Force database copy (slower safe mode)

Examples

bash

# Find bank statements from last month
fruitmail subject "statement" -n 50

# Get unread emails as JSON for processing
fruitmail unread --json | jq '.[] | .subject'

# Find all PDFs from a specific sender
fruitmail sender "@bankofamerica.com" -n 100 | grep -i statement

# Export recent emails to CSV
fruitmail recent 30 --csv > recent_emails.csv

Why This Exists

Method	Time for 130k emails
AppleScript iteration	8+ minutes
Spotlight/mdfind	Broken since Big Sur
SQLite (this tool)	~50ms

Apple removed the emlx Spotlight importer in macOS Big Sur. This tool queries the Envelope Index SQLite database directly.

Technical Details

Database: ~/Library/Mail/V{9,10,11}/MailData/Envelope Index

Key tables:

•messages - Email metadata (dates, flags, FKs)
•subjects - Subject lines
•addresses - Email addresses and display names
•recipients - TO/CC mappings
•attachments - Attachment filenames

Limitations:

•Apple Mail.app only — this tool queries Mail.app's local database
•Read-only for Mail.app — can search/read but cannot compose/send
•To send emails: Use the separate himalaya skill (IMAP/SMTP)
•SQLite queries: metadata only (subjects, senders, dates)
•Body content: AppleScript (fast for a few emails, slow for thousands)

Reading Email Bodies

For full email body content, use the body command:

bash

fruitmail body 94695                 # Read single email by ID

This uses AppleScript to fetch the full content from Mail.app. It's:

•Fast for 1-10 emails (~100ms each)
•Slow for hundreds/thousands (use sparingly)

The SQLite database only stores metadata; actual body content lives in Mail.app's internal cache.

Advanced: Raw SQL

For custom queries, use sqlite3 directly:

bash

sqlite3 -header -column ~/Library/Mail/V10/MailData/Envelope\ Index "
SELECT m.ROWID, s.subject, a.address 
FROM messages m 
JOIN subjects s ON m.subject = s.ROWID 
LEFT JOIN addresses a ON m.sender = a.ROWID 
WHERE s.subject LIKE '%your query%' 
ORDER BY m.date_sent DESC 
LIMIT 20;
"

License

MIT