Name: Apple Mail Search
Author: mneves75

據 AlphaMoat 統計,截至 2026-09,Apple Mail Search 累計下載 4,879 次、獲 2 個星標,在全部 5,078 個 AI 技能中排名第 1,916 位,在「辦公效率」分類(435 個)中排名第 171 位。

累計安裝

316

累計下載

4879

星標

全站排名

#1,916

全站前 38% · 「辦公效率」前 40%

平台	累計安裝	累計下載	星標	評論
ClawHub ↗	147	4601	2	3
SkillHub ↗	316	4879	2	—

各平台的計數口徑不同,統計時間不一致。

這個技能是做什麼的

可搜尋主題、發件人、收件人、日期、未讀狀態或附件名，可選 JSON 或 CSV 輸出。需 sqlite3 和郵件索引訪問許可權。不讀取正文，不撰寫或傳送郵件。使用窄範圍查詢，分享前審閱；匯出可能在 Mail 外儲存敏感後設資料。

資料釋出於 2026-10-27

可以用來做什麼

查詢本地郵件後設資料

什麼時候用

Apple Mail 郵件需要限定範圍的後設資料查詢時

示例提示詞

以下是根據技能文件生成的示例,不代表實際執行結果。

小範圍查詢匹配郵件後設資料，只展示本任務需要的欄位。

月度資料趨勢

累計下載4879

星標2

2026-09 起統計方法調整:同名技能按作者分別統計,並覆蓋全部技能。圖中虛線為調整前的月份,與之後的資料不直接比較,也不計算跨越調整的增長。

月份	累計下載	環比	星標
2026-09	4879	—	2
2026-08	4422	+6.2%	2
2026-07	4163	+8.6%	2
2026-06	3834	+4.0%	2
2026-05	3685	—	2
2026-03	3180	—	2

SKILL.md 原文

以下是作者釋出的原始檔案,按純文字顯示,本站未做修改或稽核;其中的連結不可點選,命令請核實後再執行。抓取於 2026-10-23。

2.9 KB · ClawHub v1.0.0

---
name: apple-mail-search
description: Fast Apple Mail search via SQLite on macOS. Search emails by subject, sender, date, attachments - results in ~50ms vs 8+ minutes with AppleScript. Use when asked to find, search, or list emails.
homepage: https://github.com/steipete/clawdbot
metadata: {"clawdbot":{"emoji":"📬","os":["darwin"],"requires":{"bins":["sqlite3"]}}}
---

# Apple Mail Search

Search Apple Mail.app emails instantly via SQLite. ~50ms vs 8+ minutes with AppleScript.

展開全部(共 107 行)


## Installation

```bash
# Copy mail-search to your PATH
cp mail-search /usr/local/bin/
chmod +x /usr/local/bin/mail-search
```

## Usage

```bash
mail-search subject "invoice"           # Search subjects
mail-search sender "@amazon.com"        # Search by sender email
mail-search from-name "John"            # Search by sender name
mail-search to "[email protected]"  # Search sent mail
mail-search unread                      # List unread emails
mail-search attachments                 # List emails with attachments
mail-search attachment-type pdf         # Find PDFs
mail-search recent 7                    # Last 7 days
mail-search date-range 2025-01-01 2025-01-31
mail-search open 12345                  # Open email by ID
mail-search stats                       # Database statistics
```

## Options

```
-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
```

## Examples

```bash
# Find bank statements from last month
mail-search subject "statement" -n 50

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

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

# Export recent emails to CSV
mail-search 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:**
- Read-only (cannot compose/send)
- Metadata only (bodies in .emlx files)
- Mail.app only (not Outlook, etc.)

## 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