ln-652-transaction-correctness-auditor

> **Paths:** File paths (`shared/`, `references/`, `../ln-*`) are relative to skills repo root. If not found at CWD, locate this SKILL.md directory and go up one level for repo root. If `shared/` is missing, fetch files via WebFetch from `https://raw.githubusercontent.com/levnikolaevich/claude-code-skills/master/skills/{path}`. # Transaction Correctness Auditor (L3 Worker) **Type:** L3 Worker Specialized worker auditing database transaction patterns for correctness, scope, and trigger interaction. ## Purpose & Scope - Audit **transaction correctness** (Priority: HIGH) - Check commit patterns, transaction boundaries, rollback handling, trigger/notify semantics - Write structured findings to file with severity, location, effort, recommendations - Calculate compliance score (X/10) for Transaction Correctness category ## Inputs **MANDATORY READ:** Load `shared/references/audit_worker_core_contract.md`. Receives `contextStore` with: `tech_stack`, `best_practices`, `db_config` (database type, ORM settings, trigger/notify patterns), `codebase_root`, `output_dir`. **Domain-aware:** Supports `domain_mode` + `current_domain`. ## Workflow **MANDATORY READ:** Load `shared/references/two_layer_detection.md` for detection methodology. 1) **Parse context from contextStore** - Extract tech_stack, best_practices, db_config, output_dir - Determine scan_path 2) **Discover transaction infrastructure** - Find migration files with triggers (`pg_notify`, `CREATE TRIGGER`, `NOT...