openai-session-explorer

Read-only CLI for exploring local Codex/OpenAI session history.

ose is the Codex sibling of cse: it reads ~/.codex/state_5.sqlite as the primary thread index, then streams the rollout JSONL path recorded in SQLite for message, tool, search, and export commands.

Install

pnpm install
pnpm build
pnpm link --global

Requires the sqlite3 command-line binary. OSE opens Codex databases with sqlite3 -readonly; it does not use immutable=1 because live Codex databases are WAL-mode and can change while OSE is reading them.

Usage

ose list --pretty
ose list --project /path/to/repo --limit 20
ose show <thread-id>
ose show <thread-id> --raw
ose messages <thread-id> --user
ose tools <thread-id>
ose files <thread-id>
ose search "migration" --all --context 1
ose projects --pretty
ose stats
ose history --search deploy
ose tokens <thread-id>
ose export <thread-id> --format md --stdout

Data Sources

• state_5.sqlite: canonical thread metadata and rollout paths
• sessions/YYYY/MM/DD/*.jsonl: full session event stream
• archived_sessions/*.jsonl: archived rollout streams
• history.jsonl: narrow prompt history only
• logs_2.sqlite: optional diagnostics, not session reconstruction

Design

• JSON output by default, --pretty for tables
• Read-only SQLite access with loud failures
• No fallback to incomplete JSON indexes
• Streams JSONL instead of loading whole session files when possible