Terminal
Terminal/Skill
Write, execute, or optimize analytical DuckDB SQL against MotherDuck data.
By MotherDuck
Works with
npx skills add motherduckdb/agent-skills --skill motherduck-queryget_query_guide before writing SQL. Traverse only relevant topics and validate Guide claims against the live schema."database"."schema"."table" names.ATTACH, DETACH, recovery commands such as CREATE SNAPSHOT, ALTER DATABASE ... SET SNAPSHOT, UNDROP DATABASE, and lifecycle commands such as SHUTDOWN as writes. Use the MotherDuck MCP query_rw tool when the user's change request authorizes the write. Ask for confirmation only when the action is destructive, externally visible, or outside the stated scope.custom_user_agent when the connection path supports it.Read only the reference sections needed for the current task.
references/QUERY_PLAYBOOK.md for DuckDB query patterns, exploration SQL, performance rules, common analytical shapes, and common mistakesLoad related skills only for missing capabilities; reuse established context.
motherduck-connect for session setupmotherduck-duckdb-sql for syntax and function referencemotherduck-explore for understanding the source schema before writing queriesmotherduck-manage-guides when semantic definitions or reusable query rules need to be read or maintained