Fast SQLite-based search for Apple Mail.app with full body content support.
SKILL.md
Fruitmail (Fast & Safe)
Fast SQLite-based search for Apple Mail.app with full body content support.
Installation
bash
npm install -g fruitmail
Usage
bash
# Complex search
fruitmail search --subject "invoice" --days 30 --unread
# Search by sender
fruitmail sender "@amazon.com"
# List unread emails
fruitmail unread
# Read full email body (supports --json)
fruitmail body 94695
# Open in Mail.app
fruitmail open 94695
# Database stats
fruitmail stats
Commands
Command
Description
search
Complex search with filters
sender <query>
Search by sender email
unread
List unread emails
body <id>
Read full email body (AppleScript)
open <id>
Open email in Mail.app
stats
Database statistics
Search Options
text
--subject <text> Search subject lines
--days <n> Last N days
--unread Only unread emails
--limit <n> Max results (default: 20)
--json Output as JSON
--copy Copy DB before query (safest mode)
Examples
bash
# Find bank statements from last month
fruitmail search --subject "statement" --days 30
# Get unread emails as JSON
fruitmail unread --json | jq '.[] | .subject'
# Find emails from Amazon
fruitmail sender "@amazon.com" --limit 50
Performance
Method
Time for 130k emails
AppleScript (full iteration)
8+ minutes
SQLite (this tool)
~50ms
Technical Details
Database:~/Library/Mail/V{9,10,11}/MailData/Envelope Index
Run “clawhub install gumadeiras/apple-mail-search-safe” in your terminal. The skill is added to your agent's skills directory and picked up automatically on the next run — no restart or extra configuration needed.
What does the SQLite skill do?
Fast SQLite-based search for Apple Mail.app with full body content support. The SKILL.md section on this page shows the exact instructions the skill gives your agent.
Is the SQLite skill free?
Yes. SQLite is a free, open-source skill by gumadeiras. As with any third-party skill, review the source repository before installing it into an agent with sensitive access.
Does SQLite work with Claude Code and OpenClaw?
Yes. Skills use the portable SKILL.md format, so SQLite works with Claude Code, OpenClaw, Codex, Hermes, and any other agent that reads SKILL.md skills.