From sundial-org-awesome-openclaw-skills-4
Searches Apple Mail.app SQLite database for fast email queries by subject, sender, unread status, recency; reads full bodies via AppleScript, opens in Mail.app. macOS CLI.
npx claudepluginhub joshuarweaver/cascade-ai-ml-agents-misc-2 --plugin sundial-org-awesome-openclaw-skills-4This skill uses the workspace's default tool permissions.
Fast SQLite-based search for Apple Mail.app with full body content support.
Guides Next.js Cache Components and Partial Prerendering (PPR) with cacheComponents enabled. Implements 'use cache', cacheLife(), cacheTag(), revalidateTag(), static/dynamic optimization, and cache debugging.
Guides building MCP servers enabling LLMs to interact with external services via tools. Covers best practices, TypeScript/Node (MCP SDK), Python (FastMCP).
Generates original PNG/PDF visual art via design philosophy manifestos for posters, graphics, and static designs on user request.
Fast SQLite-based search for Apple Mail.app with full body content support.
npm install -g apple-mail-search-cli
# 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
| 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 |
--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)
# 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
| Method | Time for 130k emails |
|---|---|
| AppleScript (full iteration) | 8+ minutes |
| SQLite (this tool) | ~50ms |
~/Library/Mail/V{9,10,11}/MailData/Envelope Index--copy mode availablehimalaya skill (IMAP/SMTP)