explainx.ainewsletter3.02k
Productivity

transaction-management▌

aj-geddes/useful-ai-prompts · updated Apr 8, 2026

$npx skills add https://github.com/aj-geddes/useful-ai-prompts --skill transaction-management
0 commentsdiscussion
summary

Implement robust transaction management with ACID compliance, concurrency control, and error handling. Covers isolation levels, locking strategies, and deadlock resolution.

skill.md

Transaction Management

Table of Contents

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:

-- Start transaction
BEGIN;

-- Multiple statements
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;

-- Commit changes
COMMIT;

-- Or rollback
ROLLBACK;

Reference Guides

Detailed implementations in the references/ directory:

Guide Contents
PostgreSQL Transactions PostgreSQL Transactions
MySQL Transactions MySQL Transactions
PostgreSQL Isolation Levels PostgreSQL Isolation Levels
MySQL Isolation Levels MySQL Isolation Levels
PostgreSQL Explicit Locking PostgreSQL Explicit Locking
MySQL Locking MySQL Locking
Deadlock Prevention 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

Discussion

Product Hunt–style comments (not star reviews)
  • No comments yet — start the thread.
general reviews

Ratings

4.8★★★★★48 reviews
  • ★★★★★Dhruvi Jain· Dec 12, 2024

    transaction-management has been reliable in day-to-day use. Documentation quality is above average for community skills.

  • ★★★★★Aarav Singh· Dec 12, 2024

    transaction-management reduced setup friction for our internal harness; good balance of opinion and flexibility.

  • ★★★★★Naina Iyer· Dec 8, 2024

    Solid pick for teams standardizing on skills: transaction-management is focused, and the summary matches what you get after install.

  • ★★★★★Arjun Choi· Dec 4, 2024

    We added transaction-management from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.

  • ★★★★★Arya Kapoor· Nov 27, 2024

    Registry listing for transaction-management matched our evaluation — installs cleanly and behaves as described in the markdown.

  • ★★★★★Arjun Abebe· Nov 23, 2024

    transaction-management fits our agent workflows well — practical, well scoped, and easy to wire into existing repos.

  • ★★★★★Kofi Harris· Nov 23, 2024

    transaction-management is among the better-maintained entries we tried; worth keeping pinned for repeat workflows.

  • ★★★★★Oshnikdeep· Nov 3, 2024

    Keeps context tight: transaction-management is the kind of skill you can hand to a new teammate without a long onboarding doc.

  • ★★★★★Ganesh Mohane· Oct 22, 2024

    We added transaction-management from the explainx registry; install was straightforward and the SKILL.md answered most questions upfront.

  • ★★★★★Meera Johnson· Oct 18, 2024

    Useful defaults in transaction-management — fewer surprises than typical one-off scripts, and it plays nicely with `npx skills` flows.

showing 1-10 of 48

1 / 5