What problem does it solve? Agents and checkers need a durable, queryable record of hook events and code findings across sessions, but raw transcripts and checker output are ephemeral and unstructured. This Skill defines the SQLite sink schema, views, finding state machine, and scripts that let agents read event rows and write finding rows consistently. ## Core Features & Use Cases - Event Sink & Views: Read hook event rows (SessionStart, PostToolUse, SubagentStop, turn steps) through prepared views like agent_cost, turn_cost, denials, and session_audit using parameterized sqlite3 queries. - Finding Lifecycle Management: Propose, confirm, move, close, and waive findings through transactional scripts (lifecycle.sql, transition.sql, batch.sql) with hash-based staleness detection. - Checker Integration: Confirm diagnostics from ast-grep, ruff, biome, and Roslyn SARIF output as site rows via dedicated mapping scripts. - Use Case: After a Stop hook delivers open findings on a branch, an agent reads the ids through confirmed_findings, fixes the sites, and writes one fixed transition per id with the edit's tool_use_id. ## Quick Start Use the observation skill to read the open findings for this worktree and write a transition for each one you resolve.