What problem does it solve? Standard SQL knowledge is not enough to write correct SELECT statements for MariaDB: its optimizer hints, LIMIT extensions, locking modifiers, and file-output clauses differ from both the SQL standard and other databases, and LLMs frequently generate wrong or legacy forms. This Skill provides the exact MariaDB delta so generated or reviewed SELECT statements are syntactically valid and idiomatic. ## Core Features & Use Cases - Optimizer hints: Covers the /*+ ... */ hint-comment form (MAX_EXECUTION_TIME, JOIN_ORDER, JOIN_FIXED_ORDER, JOIN_PREFIX, JOIN_SUFFIX) and legacy keyword hints like STRAIGHT_JOIN and SQL_CALC_FOUND_ROWS, including which to avoid. - Pagination and locking: Documents LIMIT comma-form vs OFFSET keyword, OFFSET ... FETCH ... WITH TIES, ROWS EXAMINED, and FOR UPDATE / LOCK IN SHARE MODE with WAIT, NOWAIT, and SKIP LOCKED for worker-queue patterns. - File output and temporal queries: Explains SELECT INTO OUTFILE, INTO DUMPFILE, INTO @var, WITH ROLLUP, PARTITION pruning, and FOR SYSTEM_TIME on system-versioned tables. - Use Case: When asked to write a paginated queue-consumer query for MariaDB, produce SELECT ... FOR UPDATE SKIP LOCKED with LIMIT ... OFFSET instead of the non-portable or blocking forms an LLM would otherwise emit. ## Quick Start Ask the AI to write or review a MariaDB SELECT statement, such as a paginated query with row locking or an export using INTO OUTFILE, and it will apply the MariaDB-specific syntax from this Skill.
