transactions

Database transactions, ACID properties, and concurrency control

Safety Notice

This listing is imported from skills.sh public index metadata. Review upstream SKILL.md and repository scripts before running.

Copy this and send it to your AI assistant to learn

Install skill "transactions" with this command: npx skills add pluginagentmarketplace/custom-plugin-sql/pluginagentmarketplace-custom-plugin-sql-transactions

Database Transactions Skill

Overview

Understand and implement database transactions with ACID properties and proper concurrency control.

Topics Covered

ACID Properties

  • Atomicity
  • Consistency
  • Isolation
  • Durability
  • Trade-offs

Isolation Levels

  • Read uncommitted
  • Read committed
  • Repeatable read
  • Serializable
  • Snapshot isolation

Concurrency

  • Locking mechanisms
  • Deadlock handling
  • Optimistic locking
  • MVCC concepts
  • Lock monitoring

Transaction Patterns

  • Savepoints
  • Nested transactions
  • Distributed transactions
  • Two-phase commit
  • Saga pattern

Prerequisites

  • SQL fundamentals
  • Database concepts

Learning Outcomes

  • Implement ACID transactions
  • Choose isolation levels
  • Handle deadlocks
  • Design concurrent systems

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Related Skills

Related by shared tags or category signals.

Automation

postgresql

No summary provided by upstream source.

Repository SourceNeeds Review