Jesse Vincent ce18442159 Add enhanced schema with full conversation metadata ...

Captures all available JSONL fields for rich search capabilities.

New fields in exchanges table:
- parent_uuid - Conversation tree structure
- is_sidechain - Distinguish main thread vs subagent conversations
- session_id, cwd, git_branch, claude_version - Session context
- thinking_level, thinking_disabled, thinking_triggers - Thinking metadata

New tool_calls table:
- Tracks every tool use (Read, Edit, Bash, etc.)
- Searchable by tool name and parameters
- Enables queries like "times I edited package.json"

New exclusion: Skip conversations containing "Only use NO_INSIGHTS_FOUND"

Migration:
- Automatic schema migration for existing databases
- Runs on first access after upgrade
- Idempotent - safe to run multiple times

Captured tool usage so far: 1,674 tool calls across Bash, Edit, Read, etc.

Tests: 67/67 passing including migration verification

2025-10-14 13:26:06 -07:00

..

SCHEMA.md

Add enhanced schema with full conversation metadata

2025-10-14 13:26:06 -07:00