{"id":"4775e83c-8481-493b-b1bb-b4d06ca10596","shortId":"Sxk9Z7","kind":"skill","title":"Load .mbox mail archives into SQLite for offline search, audits, and dataset joins","tagline":"Use mbox-to-sqlite when an agent needs to work across an email archive as structured data instead of parsing one message at a time. The agent imports a mailbox into SQLite, then hands the resulting database to search, reporting, and cross-dataset workflows without depending on a ","description":"# Load .mbox mail archives into SQLite for offline search, audits, and dataset joins\n\nUse mbox-to-sqlite when an agent needs to work across an email archive as structured data instead of parsing one message at a time. The agent imports a mailbox into SQLite, then hands the resulting database to search, reporting, and cross-dataset workflows without depending on a live mail provider.\n\n## Prerequisites\n\nPython 3, pip, a .mbox mailbox export, and SQLite-compatible analysis tooling.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- pip install mbox-to-sqlite\n- pip install -e '.[test]'\n\nRequirements and caveats from upstream:\n- python -m venv venv\n\nBasic usage or getting-started notes:\n- Use the mbox command to import a .mbox file into a SQLite database:\n- mbox-to-sqlite mbox emails.db path/to/messages.mbox\n- You can try this out against an example containing a sample of 3,266 emails from the [Enron corpus](https://en.wikipedia.org/wiki/Enron_Corpus) like this:\n\n- Source: https://github.com/simonw/mbox-to-sqlite\n- Extracted from upstream docs: https://raw.githubusercontent.com/simonw/mbox-to-sqlite/HEAD/README.md\n\n## Documentation\n\n- https://github.com/simonw/mbox-to-sqlite\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins/)","tags":["load","mbox","mail","archives","into","sqlite","for","offline","search","audits","and","dataset"],"capabilities":["skill","source-agentskillexchange","skill-load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,384 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:11:12.746Z","embedding":null,"createdAt":"2026-05-18T13:17:35.564Z","updatedAt":"2026-05-18T19:11:12.746Z","lastSeenAt":"2026-05-18T19:11:12.746Z","tsv":"'/simonw/mbox-to-sqlite':229,240 '/simonw/mbox-to-sqlite/head/readme.md':236 '/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins/)':247 '/wiki/enron_corpus)':223 '266':215 '3':132,214 'across':25,88 'agent':21,41,84,104,242 'agentskillexchange.com':246 'agentskillexchange.com/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins/)':245 'analysi':142 'archiv':4,28,67,91 'audit':10,73 'basic':175 'caveat':168 'command':185 'compat':141 'contain':210 'corpus':220 'cross':57,120 'cross-dataset':56,119 'data':31,94 'databas':51,114,194 'dataset':12,58,75,121 'depend':61,124 'doc':233 'document':237 'e':164 'email':27,90,216 'emails.db':200 'en.wikipedia.org':222 'en.wikipedia.org/wiki/enron_corpus)':221 'enron':219 'environ':155 'exampl':209 'exchang':244 'export':137 'extract':230 'file':190 'get':179 'getting-start':178 'github.com':228,239 'github.com/simonw/mbox-to-sqlite':227,238 'hand':48,111 'import':42,105,187 'instal':144,148,157,163 'instead':32,95 'join':13,76 'like':224 'live':127 'load':1,64 'm':172 'mail':3,66,128 'mailbox':44,107,136 'match':153 'mbox':2,16,65,79,135,159,184,189,196,199 'mbox-to-sqlit':15,78,158,195 'messag':36,99 'need':22,85 'note':181 'offlin':8,71 'one':35,98 'pars':34,97 'path':151 'path/to/messages.mbox':201 'pip':133,156,162 'prerequisit':130 'provid':129 'python':131,171 'raw.githubusercontent.com':235 'raw.githubusercontent.com/simonw/mbox-to-sqlite/head/readme.md':234 'report':54,117 'requir':166 'result':50,113 'sampl':212 'search':9,53,72,116 'setup':150 'skill':243 'skill-load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins' 'sourc':226,241 'source-agentskillexchange' 'sqlite':6,18,46,69,81,109,140,161,193,198 'sqlite-compat':139 'start':180 'structur':30,93 'test':165 'time':39,102 'tool':143 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'tri':204 'upstream':147,170,232 'usag':176 'use':14,77,145,182 'venv':173,174 'without':60,123 'work':24,87 'workflow':59,122","prices":[{"id":"9423594f-903d-4912-9f69-a3b7e9d44628","listingId":"4775e83c-8481-493b-b1bb-b4d06ca10596","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:17:35.564Z"}],"sources":[{"listingId":"4775e83c-8481-493b-b1bb-b4d06ca10596","source":"github","sourceId":"agentskillexchange/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins","isPrimary":false,"firstSeenAt":"2026-05-18T13:17:35.564Z","lastSeenAt":"2026-05-18T19:11:12.746Z"}],"details":{"listingId":"4775e83c-8481-493b-b1bb-b4d06ca10596","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"e0d9137f203f26686dff2d678672615997637d16","skill_md_path":"skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Load .mbox mail archives into SQLite for offline search, audits, and dataset joins","description":"Use mbox-to-sqlite when an agent needs to work across an email archive as structured data instead of parsing one message at a time. The agent imports a mailbox into SQLite, then hands the resulting database to search, reporting, and cross-dataset workflows without depending on a live mail provider."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/load-mbox-mail-archives-into-sqlite-for-offline-search-audits-and-dataset-joins"},"updatedAt":"2026-05-18T19:11:12.746Z"}}