Transaction Management

This handles database transactions with proper ACID compliance and concurrency control. You'd reach for it when building anything that needs to coordinate multiple database operations atomically, like transferring money between accounts or ensuring inventory updates don't conflict. The skill covers isolation levels, locking strategies, and deadlock prevention across both PostgreSQL and MySQL. The reference guides are thorough on the mechanics, though the best practices section is surprisingly generic given how many footguns exist in transaction management. Still, having patterns for explicit locking and isolation levels in one place beats piecing together Stack Overflow answers when your transactions start stepping on each other.