Agent-Skills.md

Agent Skills: Database Transactions

Define transaction boundaries, locking, and consistency guarantees for multi-step writes. Use when designing atomic operations, retries, idempotency, or concurrent write behavior.

UncategorizedID: hoangnguyen0403/agent-skills-standard/database-transactions

Repository

hoangnguyen0403/agent-skills-standard
HoangNguyen0403License: MIT
567164

Install this agent skill to your local

pnpm dlx add-skill https://github.com/HoangNguyen0403/agent-skills-standard/tree/HEAD/skills/database/database-transactions

Skill Files

Browse the full folder contents for database-transactions.

Download Skill

Loading file tree…

skills/database/database-transactions/SKILL.md

Skill Metadata

Name
database-transactions
Description
Define transaction boundaries, locking, and consistency guarantees for multi-step writes. Use when designing atomic operations, retries, idempotency, or concurrent write behavior.

Database Transactions

Priority: P0 (CRITICAL)

One business action should have one clear consistency strategy.

Rules

  • Define the unit of work before choosing transaction scope.
  • Keep transaction bodies short and purposeful.
  • Record isolation, lock, retry, and idempotency expectations for contested writes.
  • Split eventually consistent workflows from truly atomic ones.

Verify

  • [ ] Transaction boundary matches one business action.
  • [ ] Isolation or locking tradeoff is explicit.
  • [ ] Retry and idempotency behavior is defined for duplicate or concurrent requests.
  • [ ] External side effects are not hidden inside a DB transaction without compensation.

Anti-Patterns

  • No giant transaction scripts: long units increase contention and failure blast radius.
  • No retry without idempotency: duplicate writes become correctness bugs.
  • No mixed atomicity story: define what is immediate vs eventual.

References