Query MotherDuck

Use this skill when executing SQL queries for analytics, aggregations, transformations, or data exploration against MotherDuck databases.

Prerequisites

• MotherDuck connection established via connect
• Target database and tables identified via explore

Default Posture

• Write DuckDB SQL, not PostgreSQL SQL, even when using the PG endpoint.
• Always use fully qualified "database"."schema"."table" names.
• Filter early, aggregate early, and prefer serving tables or summaries for repeated reads.
• Keep SQL obvious, multi-line, and explicit about grain, filters, and output shape.
• Tag long-lived integrations with custom_user_agent when the connection path supports it.

Workflow