What problem does it solve? LLMs frequently generate transaction-control SQL that is valid in standard SQL but wrong or misleading in MariaDB — such as using BEGIN inside stored routines, wrapping DDL in transactions expecting rollback, or assuming autocommit is off by default. This Skill provides the exact MariaDB delta so generated transaction statements behave correctly. ## Core Features & Use Cases - MariaDB-specific syntax reference: Covers START TRANSACTION / BEGIN, WITH CONSISTENT SNAPSHOT, READ ONLY / READ WRITE, COMMIT / ROLLBACK with AND CHAIN and RELEASE, SAVEPOINT, and RELEASE SAVEPOINT. - Implicit commit and autocommit rules: Documents which statements commit implicitly before execution, autocommit defaults, the in_transaction session variable, and completion_type behavior. - LLM trap table: Maps common incorrect patterns (e.g., DDL rollback attempts, nested START TRANSACTION, LOCK TABLES interactions) to the correct MariaDB forms. - Use Case: When asked to write a retry loop that commits and immediately starts a new transaction, the agent uses COMMIT AND CHAIN instead of separate COMMIT and START TRANSACTION statements, preserving isolation level and access mode. ## Quick Start Ask the agent to write or review MariaDB transaction-control statements, such as generating a stored procedure that starts a transaction with START TRANSACTION and rolls back to a savepoint on error.
