transaction-management
Manage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.
By aj-geddes · 442 installs
npx skills add aj-geddes/useful-ai-prompts --skill transaction-management
Source repository · Upstream listing
Transaction Management
Table of Contents
[Overview]( overview)
[When to Use]( when to use)
[Quick Start]( quick start)
[Reference Guides]( reference guides)
[Best Practices]( best practices)
Overview
Implement robust transaction management with ACID compliance, concurrency control, and error handling. Covers isolation levels, locking strategies, and deadlock resolution.
When to Use
ACID transaction implementation
Concurrent data modification handling
Isolation level selection
Deadlock prevention and resolution
Transaction timeout configuration
Distributed transaction coordination
Financial transaction safety
Quick Start
Simple Transaction:
Reference Guides
Detailed implementations in the references/ directory:
Guide Contents
[PostgreSQL Transactions](references/postgresql transactions.md) PostgreSQL Transactions
[MySQL Transactions](references/mysql transactions.md) MySQL Transactions
[PostgreSQL Isolation Levels](references/postgresql isolation levels.md) PostgreSQL Isolation Levels
[MySQL Isolation Levels](references/mysql isolation levels.md) MySQL Isolation Levels
[PostgreSQL Explicit Locking](references/postgresql explicit locking.md) PostgreSQL Explicit Locking
[MySQL Locking](references/mysql locking.md) MySQL Locking
[Deadlock Prevention](references/deadlock prevention.md) PostgreSQL Deadlock Detection:
Best Practices
✅ DO
Follow established patterns and conventions
Write clean, maintainable code
Add appropriate documentation
Test thoroughly before deploying
❌ DON'T
Skip testing or validation
Ignore error handling
Hard code configuration values