What problem does it solve? AI agents and developers default to generic MySQL advice, missing MariaDB-specific capabilities like system-versioned tables, sequences, RETURNING clauses, and instant ALTER TABLE that simplify application code and operations. ## Core Features & Use Cases - Feature Discovery: Maps common patterns (manual audit columns, LAST_INSERT_ID follow-ups, VARCHAR IP storage) to native MariaDB features such as WITH SYSTEM VERSIONING, RETURNING, and INET4/INET6 types. - Version-Aware Guidance: Tags every capability with its minimum MariaDB version (10.3 through 13.0) and assumes an 11.8 LTS baseline unless specified. - Operational Correctness: Covers current mariadb- prefixed tool names, unix_socket root authentication, mariadb-upgrade after binary upgrades, and Galera rolling upgrade procedures. - Use Case: When reviewing a schema that stores IP addresses as VARCHAR and maintains manual updated_at triggers, this Skill recommends INET6 columns and system versioning with correct syntax and version requirements. ## Quick Start Ask the AI to review your database schema or SQL code for MariaDB-specific improvements and feature opportunities.
