What problem does it solve? Writing conditional logic in MariaDB SQL is error-prone because agents and developers confuse expression-level functions (IF(), CASE ... END) with stored-program statements (IF ... END IF, CASE ... END CASE), misuse DECODE outside Oracle mode, and hit type-aggregation gotchas in COALESCE. This Skill provides a verified catalog of every MariaDB control-flow function with signatures, semantics, and the mistakes LLMs most often make. ## Core Features & Use Cases - Complete function catalog: Covers IF(), IFNULL()/NVL(), NULLIF(), COALESCE(), NVL2(), the CASE operator (simple and searched forms), and DECODE/DECODE_ORACLE with one-line semantics per entry. - Common-mistake correction table: Maps wrong patterns (e.g., CASE ... END CASE in a SELECT list) to the correct MariaDB syntax with explanations. - Version awareness: Defaults to MariaDB 11.8 LTS context and annotates functions only available from specific versions. - Use Case: When writing a query like SELECT with a NULL-safe division, the Skill directs you to x / NULLIF(y, 0) instead of relying on error-prone division, and clarifies that DECODE_ORACLE works in any SQL mode while plain DECODE is the two-argument decryption function. ## Quick Start Ask the AI to write a MariaDB query that branches on a condition or substitutes for NULL values, such as categorizing orders with a CASE expression.
