Ln 652 Transaction Correctness Auditor
This is a specialized auditor that hunts down database transaction bugs before they bite you in production. It checks for the stuff that code review misses: missing commits that break real-time notifications when pg_notify events get deferred, transactions held open during HTTP calls that starve your connection pool, and rollback handling that assumes the happy path. The two-layer detection approach (candidate scan then context verification) is smart, especially for tracing whether updates to trigger-affected tables actually have intermediate commits for progress tracking. It calculates a compliance score and writes structured findings with severity ratings. Best used when you're running Postgres with triggers and asyncio, or when you've had "why didn't the webhook fire" incidents that turned out to be transaction scope issues.
- skills.sh installs
- 370
- GitHub stars
- 591
- last updated
- Aug 21, 2026
Install
$ npx -y skills add levnikolaevich/claude-code-skills --skill ln-652-transaction-correctness-auditor --agent claude-codeInstalls into .claude/skills of the current project.
Files
This is a specialized auditor that hunts down database transaction bugs before they bite you in production. It checks for the stuff that code review misses: missing commits that break real-time notifications when pg_notify events get deferred, transactions held open during HTTP calls that starve your connection pool, and rollback handling that assumes the happy path. The two-layer detection approach (candidate scan then context verification) is smart, especially for tracing whether updates to trigger-affected tables actually have intermediate commits for progress tracking. It calculates a compliance score and writes structured findings with severity ratings. Best used when you're running Postgres with triggers and asyncio, or when you've had "why didn't the webhook fire" incidents that turned out to be transaction scope issues.
Browse the repository on GitHubSponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/levnikolaevich/claude-code-skills
- Category
- Design & UI/UX
- First seen
- Jun 3, 2026
More from levnikolaevich/claude-code-skills
All 128- Ln 650 Persistence Performance Auditor369
- Ln 724 Artifact Cleaner364
- Ln 523 Auto Test Planner362
- Ln 1000 Pipeline Orchestrator360
- Ln 512 Tech Debt Cleaner360
- Ln 520 Test Planner360
- Ln 723 Seed Data Generator360
- Ln 510 Quality Coordinator357
- Ln 521 Test Researcher356
- Ln 626 Dead Code Auditor354
- Ln 621 Security Auditor337
- Ln 625 Dependencies Auditor324
- Ln 627 Observability Auditor316
- Ln 628 Concurrency Auditor316
- Ln 610 Docs Auditor315
- Ln 623 Code Principles Auditor315
- Ln 622 Build Auditor313
- Ln 629 Lifecycle Auditor313
- Ln 644 Dependency Graph Auditor302
- Ln 641 Pattern Analyzer295
- Ln 642 Layer Boundary Auditor293
- Ln 645 Open Source Replacer282
- Ln 613 Code Comments Auditor259
- Ln 611 Docs Structure Auditor256
Recommended
More Design & UI/UX
domain-analysistech-leads-club/agent-skillsMaps business domains and suggests service boundaries in any codebase using DDD Strategic Design. Use when asking "what are the domains in this codebase?", "whe368skills.sh installs
ci-cdahmedasmar/devops-claude-skillsCI/CD pipeline design, optimization, DevSecOps security scanning, and troubleshooting. Use this skill whenever the user mentions CI/CD, GitHub Actions, GitLab C366skills.sh installs
tooluniverse-gwas-trait-to-genemims-harvard/tooluniverseDiscover causal genes for diseases/traits from GWAS data using Open Targets L2G (locus-to-gene) scoring — integrates eQTL, chromatin interaction, and distance e365skills.sh installs
evaluatesharpdeveye/maestroUse when the user wants a quality review, interaction audit, or to test the workflow against realistic scenarios.363skills.sh installs
boss-clijackwener/boss-cliUse boss-cli for ALL BOSS 直聘 operations — searching jobs, viewing recommendations, managing applications, chatting with recruiters, and batch greeting. Invoke w362skills.sh installs
linkedin-post-formattergithub/awesome-copilotFormat and draft compelling LinkedIn posts using Unicode bold/italic styling, visual separators, structured sections, and engagement-optimized patterns. USE FOR361skills.sh installs