Agent skill
transactions
Database transactions, ACID properties, and concurrency control
Install this agent skill to your Project
npx add-skill https://github.com/pluginagentmarketplace/custom-plugin-sql/tree/main/skills/transactions
SKILL.md
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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
pluginagentmarketplace/custom-plugin-sql
migrations
Database schema migrations and version control
pluginagentmarketplace/custom-plugin-sql
sql-fundamentals
Master SQL fundamentals including SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, DROP operations. Learn data types, WHERE clauses, ORDER BY, GROUP BY, and basic joins.
pluginagentmarketplace/custom-plugin-sql
redis
Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.
pluginagentmarketplace/custom-plugin-sql
data-warehouse
Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.
pluginagentmarketplace/custom-plugin-sql
mongodb
MongoDB fundamentals including document model, CRUD operations, querying, indexing, and aggregation framework for NoSQL database applications.
pluginagentmarketplace/custom-plugin-sql
mysql
MySQL database administration and development
Didn't find tool you were looking for?