Transaction Management
ACID properties, isolation levels, locks, deadlocks, and transaction design.
Install
/plugin marketplace add sethdford/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add sethdford/claude-skills --skill transaction-managementgit clone --depth 1 https://github.com/sethdford/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/engineer/database-engineering/skills/transaction-management ~/.claude/skills/transaction-managementPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Transaction Management Ensuring data consistency through proper transaction design. ## Context You are designing transactions. Use appropriate isolation level; understand lock behavior. ## Domain Context - **ACID**: Atomicity, Consistency, Isolation, Durability - **Isolation Levels**: Read Uncommitted, Read Committed, Repeatable Read, Serializable - **Locks**: Shared (read), exclusive (write); deadlock possible - **Deadlock**: Two transactions waiting for each other; database detects and rolls back - **Consistency**: Invariants maintained; foreign keys, constraints ## Instructions 1. **Identify Invariants**: What must always be true? Enforce with constraints 2. **Transaction Scope**: Minimal; only what needs to be atomic 3. **Isolation Level**: READ_COMMITTED common; SERIALIZABLE for strong consistency 4. **Lock Order**: Acquire locks in same order everywhere; prevents deadlock 5. **Timeout**: Have timeout; if hanging, something is wrong 6. **Error Handling**: Catch and retry on deadlock 7. **Monitoring**: Track transaction time, lock waits ## Anti-Patterns - Long transactions; hold locks, block other queries - Wrong isolation level; causes data anomalies - Deadlocks and retry in app; fix root cause, not symptom - Not enforcing invariants at DB; data becomes inconsistent - Ignoring SERIALIZABLE; assumes isolation level is safe ## Further Reading - Postgres transaction documentation - ACID properties (Wikipedia or C.J. Date) - PostgreSQL lock documentation
Details
- Skill name
transaction-management- Repository
- sethdford/claude-skills
- Path
engineer/database-engineering/skills/transaction-management/SKILL.md- License
- MIT
- Repo updated
- 11 March 2026
FAQ
What does the Transaction Management skill do?
ACID properties, isolation levels, locks, deadlocks, and transaction design.
How do I install the Transaction Management skill?
Claude Code plugin: /plugin marketplace add sethdford/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Transaction Management popular?
It lives in sethdford/claude-skills, which has 48 GitHub stars and 10 forks.
Related skills
A B Test Design
48sethdford/claude-skills
Design rigorous A/B tests with hypotheses, variants, metrics, and sample size calculations.
A B Test Design Pm
48sethdford/claude-skills
Analytics and experimentation skill for product managers.
Abuse Case Design
48sethdford/claude-skills
Design abuse cases (negative use cases) showing how attackers misuse system features. Use when identifying attacks that exploit intended functionality or business logic flaws.
Visual Hierarchy
48sethdford/claude-skills
Establish clear visual hierarchy through size, weight, color, spacing, and positioning.
Trade Off Analysis
48sethdford/claude-skills
Analyze architectural trade-offs systematically using decision matrices. Use when comparing design options or justifying architectural choices to stakeholders.
Bro
38jeremybrasher/grokbot-skills
Restate the last message in plain human language, with no jargon. Observe required inputs first; HOLD when they are missing rather than guessing.
Browse the most popular Claude skills, all other skills, or write your own with the skills generator.