← Explore all skills

DATABASES / MotherDuck

MotherDuck Migration and Validation

Plans a staged warehouse migration with SQL translation, source-to-target reconciliation, a first cutover slice and a rollback path.

“Plan or implement migrations to MotherDuck with SQL translation, source-to-target validation, cutover, and rollback.”

01 / THE REASONING

Why this made the selection.

  • Separates planning with supplied schemas from validation against a connected database.
  • Pairs the migration sequence with duplicate, aggregate and changed-record checks instead of accepting row counts alone.

02 / THE REVIEW RECORD

What we actually inspected.

Source review has boundaries.
A clear record is more useful than a “safe” badge.

Material inspected

  • skills/motherduck-migrate-to-motherduck/SKILL.md
  • skills/motherduck-migrate-to-motherduck/references/EXECUTION_REFERENCE.md
  • skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md
  • skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py
  • scripts/_lib/motherduck_artifact_utils.py
  • README.md
  • LICENSE

Our findings

  • The definition calls for validation before phased cutover and records assumptions when no server is available.
  • The example session helper defaults to local in-memory databases; enabling its MotherDuck mode creates and later drops temporary databases.
  • The validation reference covers duplicates and NULL-aware changed-column comparisons as well as counts and aggregate variance.
  • The inspected example compares count/sum/average/min/max and EXCEPT key differences; artifact_session switches to MotherDuck only with an explicit environment flag and cleans up created databases.

Not established by this review

  • No skill installation, consuming-agent workflow or external service operation was executed.
  • Source inspection does not establish runtime compatibility, security certification or workload performance.
  • Not executed: it was not installed or run.

The review applies to the material and revision named here. A newer upstream release can change its behavior.

03 / PUT IT TO WORK

Add a skill to your workflow.

Upstream setup instructions ↗

DOCUMENTED COMMAND

npx skills add motherduckdb/agent-skills/skills/motherduck-migrate-to-motherduck

Run in your terminal to choose your AI tools, project or global scope, and installation method. This short command follows the current upstream version; the review covers the revision shown above.

Optional: install the reviewed revision

Keeps the original source and installer version where recorded, while leaving your AI tools and installation scope for you to choose.

npx skills add https://github.com/motherduckdb/agent-skills/tree/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck
  1. Use the pinned command and choose the agent and installation scope interactively; keep the complete references directory.
  2. Provide source and target schemas, business metrics, acceptance thresholds and a rollback requirement. Configure a database client or MCP connection separately for live checks.
  3. To run the bundled example, use a complete checkout at the reviewed revision so scripts/_lib is available. Inspect its local/cloud mode and temporary-database behaviour before execution.
  4. Retain the root artifact utility dependencies, identify source/target grain and keys, and distinguish local fixture validation from authenticated MotherDuck execution before cutover.

Before you start

  • Node.js/npm and Git for the installer
  • Source and target schema access; a MotherDuck account and authorised connection only for live work
  • Python, uv and DuckDB for the optional example, plus the repository helpers

04 / FOLLOW THE EVIDENCE

The source trail.

Our notes are separate from the original resource.
Check upstream before adopting a new version.

  1. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md

    Supports: summary, upstreamDescription, whySelected, bestFor, limitations, review, install, compatibility, access

  2. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/EXECUTION_REFERENCE.md

    Supports: review, install, limitations, access

  3. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md

    Supports: review, install, limitations, access

  4. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py

    Supports: review, install, limitations, access

  5. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/scripts/_lib/motherduck_artifact_utils.py

    Supports: review, install, limitations, access

  6. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/README.md

    Supports: review, install, limitations, access

  7. https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/LICENSE

    Supports: license

  8. https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md

    Supports: install

  9. https://raw.githubusercontent.com/motherduckdb/agent-skills/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md

    Supports: bestFor, review.notTested, review.reviewedAt

Evidence & Ask