What problem does it solve? Writing SQL for MotherDuck requires knowing exact DuckDB syntax, which differs from PostgreSQL, plus MotherDuck-only commands like shares, secrets, snapshots, and UNDROP that are documented separately. This Skill gives you a verified reference so your statements work on the first try. ## Core Features & Use Cases - DuckDB SQL Reference: Covers data types, string, numeric, date/time, aggregate, window, JSON, list, spatial, and H3 functions, plus friendly SQL features like QUALIFY, GROUP BY ALL, and UNNEST. - MotherDuck-Specific Commands: Documents operational SQL such as CREATE SNAPSHOT, UNDROP DATABASE, SHUTDOWN, and version-lifecycle caveats for features like VARIANT, GEOMETRY, and MERGE INTO. - SQL Repair and Porting: Translates PostgreSQL-style SQL into DuckDB SQL by fixing functions, date arithmetic, identifier quoting, and type casts. - Use Case: You are porting a PostgreSQL dashboard query to MotherDuck and it fails on date_trunc behavior and identifier quoting. Use this Skill to rewrite it with DuckDB-native constructs like GROUP BY ALL and QUALIFY and verify MotherDuck version support. ## Quick Start Ask the assistant to check whether your SQL statement uses valid DuckDB syntax and will run correctly on MotherDuck.
