Manage Apple Reminders via the `remindctl` CLI on macOS (list, add, edit, complete, delete)....
transactions
2
0
# Install this skill:
npx skills add pluginagentmarketplace/custom-plugin-sql --skill "transactions"
Install specific skill from multi-skill repository
# Description
Database transactions, ACID properties, and concurrency control
# SKILL.md
name: transactions
description: Database transactions, ACID properties, and concurrency control
sasmp_version: "1.3.0"
bonded_agent: 01-sql-fundamentals
bond_type: PRIMARY_BOND
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
# Related Skills
Query Google Places API (New) via the goplaces CLI for text search, place details, resolve, and...
Notion API for creating and managing pages, databases, and blocks.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme;...
# Supported AI Coding Agents
This skill is compatible with the SKILL.md standard and works with all major AI coding agents:
Amp
Antigravity
Claude Code
Clawdbot
Codex
Cursor
Droid
Gemini CLI
GitHub Copilot
Goose
Kilo Code
Kiro CLI
OpenCode
Roo Code
Trae
Windsurf
Learn more about the SKILL.md standard and how to use these skills with your preferred AI coding agent.