session-indexer
Per-project semantic search over Claude Code session history stored in SQLite.
Tested on Linux
Use it
Linux x86_64
You need first
- Runtimes:
Go 1.26.9+ - System packages:
jq
Download prebuilt linux_amd64 binary to ~/.local/bin
mkdir -p ~/.local/bin && curl -fsSL -o ~/.local/bin/session-indexer https://github.com/valpere/session-indexer/releases/download/v0.3.0/session-indexer_v0.3.0_linux_amd64 && chmod +x ~/.local/bin/session-indexer
Check that it works
session-indexer --helpThe output should contain “Available Commands:”.
First thing to try
mkdir -p .claude && cat > sample.jsonl <<'EOF'
{"type":"user","sessionId":"test-session-1","timestamp":"2026-08-25T10:00:00Z","message":{"role":"user","content":"We discussed the config validation approach using a schema validator with strict mode enabled for the project"}}
{"type":"assistant","sessionId":"test-session-1","timestamp":"2026-08-25T10:00:05Z","message":{"role":"assistant","content":[{"type":"text","text":"For config validation approach we decided to use a ring buffer style validator with strict schema checks and detailed error messages."}]}}
{"type":"user","sessionId":"test-session-1","timestamp":"2026-08-25T10:01:00Z","message":{"role":"user","content":"What did we decide about the event queue implementation for handling background tasks?"}}
EOF
cat sample.jsonlsession-indexer mine sample.jsonl --db .claude/sessions.dbRun session-indexer mine <file> --db .claude/sessions.db to index a session transcript into a project database.
What it does
- Index JSONL transcripts into a SQLite databaseTested
How to use it
- Run
session-indexer mine <file> --db .claude/sessions.dbwith your JSONL transcript. - Check the output line for how many chunks were inserted.
- Run
- Search past Claude Code sessions by meaningNot shown working
- Add relevant past context automaticallyNot tested
How far pickfit got
Linux x86_64
- Installs
- Starts
- 1 of 3 features work
- Works offline
macOS and Windows: the project says it runs there; pickfit hasn’t tried it.
Good for
- find what was decided about a topic across past sessions
- inject relevant past context at session start
- index JSONL transcripts into per-project SQLite store
- query distilled facts about implementation status
- browse what is in the index by day without a query
An alternative to mempalace, agentmemory and MemMachine.
How pickfit tested it
Each run starts from a clean machine and follows the steps above. How pickfit verifies
Linux x86_64
Its main function works
- Replayed from scratch
- Works offline
- Checked on 30 Oct 2026
Differences the test machine hit
- README: go install ./cmd/session-indexer (needs Go 1.26.9+)
In the test: download prebuilt session-indexer_v0.3.0_linux_amd64 binary from GitHub Releases to ~/.local/bin and chmod +x; no Go toolchain needed - README: retrieves via bge-m3 embeddings (Ollama) with FTS5 BM25 fallback
In the test: search prints '(embedding unavailable — FTS5 keyword results only)' and still returns keyword hits with no Ollama running