What problem does it solve? Standard SQL DELETE knowledge is not enough for MariaDB: agents often miss MariaDB-specific features like RETURNING, multi-table ORDER BY/LIMIT, DELETE HISTORY, and FOR PORTION OF, or fall into traps like expecting DELETE to reset AUTO_INCREMENT. This Skill provides the exact delta between standard SQL and MariaDB DELETE behavior. ## Core Features & Use Cases - MariaDB DELETE syntax reference: Covers single-table DELETE with PARTITION, aliases, index hints, ORDER BY/LIMIT, and the QUICK/LOW_PRIORITY/IGNORE modifiers with their engine limits. - Multi-table and RETURNING forms: Documents both multi-table syntaxes (DELETE ... FROM and DELETE FROM ... USING) with ORDER BY/LIMIT since 11.8, plus single-table RETURNING of deleted rows. - Temporal table deletion: Explains DELETE HISTORY for system-versioned tables and FOR PORTION OF for application-time-period tables, plus DELETE-vs-TRUNCATE differences. - Use Case: When asked to write a query that deletes stale sessions and returns the deleted IDs in one round trip, the agent produces DELETE FROM sessions WHERE expires_at < NOW() RETURNING id, user_id instead of a two-statement SELECT-then-DELETE approach. ## Quick Start Ask the agent to write or review a MariaDB DELETE statement, such as deleting rows with RETURNING or pruning history from a system-versioned table.
