Load .mbox mail archives into SQLite for offline search, audits, and dataset joins

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.

Prerequisites

Python 3, pip, a .mbox mailbox export, and SQLite-compatible analysis tooling.

Installation

Use the upstream install or setup path that matches your environment:

• pip install mbox-to-sqlite
• pip install -e '.[test]'

Requirements and caveats from upstream:

• python -m venv venv

Basic usage or getting-started notes:

• Use the mbox command to import a .mbox file into a SQLite database:

• mbox-to-sqlite mbox emails.db path/to/messages.mbox

• You can try this out against an example containing a sample of 3,266 emails from the Enron corpus like this:

• Source: https://github.com/simonw/mbox-to-sqlite

• Extracted from upstream docs: https://raw.githubusercontent.com/simonw/mbox-to-sqlite/HEAD/README.md

Documentation

• https://github.com/simonw/mbox-to-sqlite

Source

• Agent Skill Exchange