Terminal
Terminal/Skill
Look up or repair DuckDB SQL syntax and verify MotherDuck-specific command and feature support.
By MotherDuck
Works with
npx skills add motherduckdb/agent-skills --skill motherduck-duckdb-sql"database"."schema"."table" names once more than one database or share is in scope.GROUP BY ALL, QUALIFY, UNION BY NAME, arg_max, EXCLUDE, and REPLACE.VARIANT, native GEOMETRY, MERGE INTO, or date_trunc return-type changes.UNDROP DATABASE statements as operational SQL with plan-specific retention behavior, not ordinary analytical syntax.INCLUDE_PATTERN as whole-table/view filtering on a Share, not row-level or column-level security. Use ALTER SHARE only for include-pattern changes.CREATE DATABASE ... FROM '<file-url>') from zero-copy clone sources, and reject filtered shares as clone sources.SHOW ... statements; do not preserve ACCESS ORGANIZATION as the preferred RBAC pattern.references/SYNTAX_REFERENCE.md.Read only the reference sections needed for the current task.
references/SYNTAX_REFERENCE.md for DuckDB data types, friendly SQL features, functions, complex types, and common MotherDuck-specific gotchas.Load related skills only for missing capabilities; reuse established context.
motherduck-query for writing and validating analytical SQL against live MotherDuck datamotherduck-connect when syntax support depends on PG endpoint versus native DuckDB behaviormotherduck-explore when the problem is really missing schema context rather than missing syntax knowledge