What problem does it solve? Standard SQL CREATE TABLE knowledge does not cover MariaDB's extensions, and LLMs frequently generate non-idiomatic or subtly wrong statements — such as using utf8 instead of utf8mb4, DROP plus CREATE instead of atomic CREATE OR REPLACE, or expecting foreign keys to work on Aria tables. This Skill supplies the exact MariaDB-specific syntax and behavioral rules needed to write correct CREATE TABLE statements. ## Core Features & Use Cases - MariaDB Syntax Delta Reference: Covers CREATE OR REPLACE, atomic DDL semantics, PERIOD FOR temporal clauses, and WITH SYSTEM VERSIONING for system-versioned, application-time, and bitemporal tables. - Column and Index Extensions: Documents INVISIBLE and COMPRESSED columns, expression defaults, PERSISTENT/VIRTUAL generated columns, VECTOR(N) columns, and IGNORED/INVISIBLE index options. - Table Options Guide: Explains per-table encryption, PAGE_COMPRESSED versus ROW_FORMAT=COMPRESSED, Aria options like TRANSACTIONAL, and engine-specific behaviors. - Use Case: When asked to create a table with audit history and compressed storage, produce CREATE TABLE t (...) WITH SYSTEM VERSIONING, PAGE_COMPRESSED=1, CHARSET=utf8mb4 instead of manual audit columns and the legacy compressed row format. ## Quick Start Ask the AI to write a MariaDB CREATE TABLE statement for your use case, such as a system-versioned table with an invisible column and page compression, and it will apply the correct MariaDB-specific syntax.
