Transaction Management

ACID properties, isolation levels, locks, deadlocks, and transaction design.

48 stars 10 forksOther Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add sethdford/claude-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add sethdford/claude-skills --skill transaction-management
Manual install
git 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-management

Personal 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
Read the full skill on GitHub

Details

Skill name
transaction-management
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

Browse the most popular Claude skills, all other skills, or write your own with the skills generator.