Audits database transaction patterns to ensure data integrity, optimal scope, and proper error handling.
The Transaction Correctness Auditor is a specialized L3 worker designed to analyze codebases for critical database transaction anti-patterns. It evaluates transaction boundaries to prevent issues like 'scope too wide' (holding connections during slow network calls) or 'scope too narrow' (breaking atomicity). By scanning migrations for triggers and NOTIFY semantics, it identifies missing intermediate commits that can break real-time progress features. It provides structured feedback with severity levels, exact code locations, and remediation effort, serving as an essential quality gate for high-concurrency and data-critical applications.
Key Features
01Flags missing rollback handling in ORM and raw SQL transaction blocks
02Identifies atomic operations incorrectly split across multiple commits
03Detects transactions holding connections during external API calls or file I/O
04Calculates a compliance score based on transaction duration and complexity
05147 GitHub stars
06Analyzes database migrations to map trigger and NOTIFY dependencies
Use Cases
01Automated code reviews for backend services with complex data persistence logic
02Performance tuning for applications experiencing database lock contention or pool exhaustion
03Reliability auditing for real-time notification systems driven by database events
