motherduck-migrate-to-motherduck

Guides execution of DuckDB SQL queries against MotherDuck databases, covering analytics, aggregations, CTEs, window functions, QUALIFY, and performance optimization with best practices for grain preservation and early filtering.

Part of the MotherDuck Skills Plugin — a three-layer skill catalog (utility, workflow, use-case) teaching AI agents how to connect, query, and build with MotherDuck and DuckDB SQL, including data loading, sharing, Dives, DuckLake, and production analytics patterns.

A skill that builds multi-section live analytics dashboards as MotherDuck Dives, composing KPI rows, trend charts, and breakdown views into a single saved and shareable workspace artifact backed by validated DuckDB SQL queries.

A skill that explains MotherDuck's security, governance, and access-control patterns for teams evaluating its compliance and deployment requirements, covering data residency, service accounts, isolation boundaries, sharing, and RBAC. Guides users through identifying credential locations, defining isolation scope, and validating security posture against publicly documented guarantees.

Designs end-to-end MotherDuck data pipelines covering raw ingestion, staging, and analytics boundaries, with bulk ingestion paths, transformation sequencing, idempotent stage rebuilds, and DuckLake integration when needed.

Helps decide when DuckLake is the right storage pattern on MotherDuck instead of native storage, covering fully managed, BYOB, and own-compute modes along with data inlining, compaction, and object-storage layout considerations.

Orchestrates self-serve analytics rollout on MotherDuck by guiding teams through dataset curation, Dive/share publishing, ownership boundaries, and governed access expansion from a first audience to broader adoption.

Guides the design of MotherDuck-backed customer-facing analytics applications, handling tenant isolation, backend routing, service-account boundaries, read scaling, and Hypertenancy-style patterns for embedded or product analytics.

Creates and manages MotherDuck data shares for zero-copy, read-only database distribution with configurable access control, visibility, and update modes for internal or external recipients.

Guides database connectivity setup to MotherDuck via the Postgres endpoint, native DuckDB API, or JDBC, covering connection strings, authentication, SSL configuration, and runtime selection for ad-hoc and pipeline workloads.