Session Review

Tiny local-first TypeScript CLI for ingesting AI coding agent sessions into SQLite FTS and querying them.

Supported MVP sources:

• Pi: ~/.pi/agent/sessions/**/*.jsonl
• Claude Code: ~/.claude/projects/**/*.jsonl
• Codex CLI: ~/.codex/sessions/**/*.jsonl
• Cursor readable/exported sessions: $CURSOR_SESSION_ROOT, ~/.cursor/session-review, ~/.cursor/sessions

Usage

npm install
npm run build
npm start -- ingest
npm start -- search "sqlite FTS"
npm start -- status
npm run derive
npm run app

Override DB path:

npm start -- --db /tmp/sessions.sqlite search "auth"

Web app

npm run app
# open http://localhost:8765

If you are launching from another directory, use either a one-line cd or npm's prefix flag so npm finds this project's package.json:

cd /Users/alexsouthwell/Personal/Projects/session-review && PORT=8999 npm run app
# or
PORT=8999 npm --prefix /Users/alexsouthwell/Personal/Projects/session-review run app

The app supports session search, provider/cwd/path/date filters, grouping by working directory, agent/provider, or primary session + subagents, syntax-highlighted transcript code blocks/shell output, model input/output badges, per-turn estimated token counts, transcript expand/collapse controls by item or item type, a configurable default transcript line limit with per-item “show more”, a right-hand Pi chat sidebar, and tool/skill usage charts over time. Use the Batch runs filter to include all sessions, exclude likely batch/orchestration/subagent sessions, or show only those batch sessions. The primary-session grouping detects Pi nested run-* sessions and Claude subagents/ sidechains, linking them to indexed parent logs when available and otherwise grouping them under a synthetic primary key from the path.

The Pi chat sidebar writes a screen-context JSON bundle under output/pi-chat/ and calls pi --print --thinking xhigh --session-dir output/pi-chat-sessions/<chat-id> --continue after the first message, so follow-up questions share a persistent high-quality Pi session. Each turn attaches the current screen context plus the full contents of every transcript/source file loaded for the current screen. Click a search result, group, or transcript turn to attach it as the selected item chip for the next chat message. The visual design follows the ChatGPT image-generation mockup direction: dark developer cockpit, polished glass panels, blue/purple accents, and Cursor/VS Code-style chat ergonomics. Override the Pi binary with SESSION_REVIEW_PI_BIN.

Run this after large ingests or code changes to rebuild tool/skill analytics for already-indexed sessions:

npm run derive

Cursor exports

CURSOR_SESSION_ROOT=/path/to/cursor/exports npm start -- ingest --provider cursor