What problem does it solve? Generated SQL for MariaDB views often fails or misbehaves because standard SQL assumptions do not match MariaDB's actual semantics — mutually exclusive OR REPLACE and IF NOT EXISTS clauses, the SQL SECURITY DEFINER default, updatability restrictions, and frozen-at-creation column definitions. This Skill encodes those deltas so view DDL is correct on the first attempt. ## Core Features & Use Cases - Correct view DDL generation: Produces CREATE VIEW statements with valid clause ordering, proper ALGORITHM selection (MERGE vs TEMPTABLE), and explicit SQL SECURITY settings. - Updatability and CHECK OPTION guidance: Determines whether a view is updatable or insertable and applies WITH CASCADED or LOCAL CHECK OPTION correctly for layered views. - ALTER VIEW and DROP VIEW handling: Covers atomic redefinition via CREATE OR REPLACE or ALTER VIEW, and notes that RESTRICT/CASCADE in DROP VIEW are parsed but ignored. - Use Case: When asked to create a view that filters active users and rejects out-of-scope writes, the Skill produces a MERGE-algorithm view with WITH CHECK OPTION and SQL SECURITY INVOKER instead of silently defaulting to DEFINER privileges. ## Quick Start Write a MariaDB CREATE VIEW statement for an updatable view over the users table that only exposes active rows and rejects inserts that violate that filter.
