---
title: "MotherDuck Migration and Validation: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/skills/motherduck-migrate-to-motherduck/
description: "Plans a staged warehouse migration with SQL translation, source-to-target reconciliation, a first cutover slice and a rollback path."
---

# MotherDuck Migration and Validation: review, setup & limitations · Undominated.ai

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

[← Explore all skills](/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.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/motherduckdb/agent-skills/tree/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck)

SOURCE REVIEW

 Reviewed 2026-10-15
 Evidence 9 linked sources
 Publisher MotherDuck
 Licence [MIT ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/LICENSE)
 Revision f97855858bee
 [Read what was—and wasn’t—checked ↓](#review)

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

 [MotherDuck · upstream description ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md) Our analysis follows below.

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.

### A good fit for

 - Preparing a warehouse migration validation plan
- Reviewing one migrated reporting workload before cutover
- Validate a migration with key-level differences and business metrics before a phased cutover.
- Capture validated business definitions, join rules and cutover caveats in MotherDuck Guides for post-migration agents.

### Weigh up before choosing

 - The Python example imports repository-level scripts/_lib helpers; installing only the skill directory does not provide its full executable dependency tree.
- Example metric comparisons cast values to DOUBLE and return null percentage variance for a zero source. Choose precision and acceptance rules appropriate to your actual data.
- SQL snippets are adaptation examples, not a tested migration of your schema; no source-to-target dataset was reconciled in this review.
- Matching counts and aggregates do not prove row equivalence. The helper returns null percentage variance for a zero source metric and interpolates identifier strings; use controlled identifiers and explicit absolute differences.

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 ↗](https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md)

DOCUMENTED COMMAND

 npx skills add motherduckdb/agent-skills/skills/motherduck-migrate-to-motherduck Copy command ↗

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 Copy reviewed-revision command ↗ - Use the pinned command and choose the agent and installation scope interactively; keep the complete references directory.
- Provide source and target schemas, business metrics, acceptance thresholds and a rollback requirement. Configure a database client or MCP connection separately for live checks.
- 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.
- 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

### Compatibility

Agent Skills-compatible coding agents

### Read schemas and migration data

 - Read schemas and migration data
- Write migration SQL and validation reports
- Live migration and cloud example execution can create, modify or drop databases
- The example defaults to in-memory DuckDB; opt-in MotherDuck mode creates and drops temporary databases with the configured token.

### Cost model

The skill is MIT-licensed. MotherDuck execution, data transfer, storage and agent usage have separate costs.

04 / FOLLOW THE EVIDENCE

## The source trail.

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

 - [Skill definition at reviewed revision ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md) Checked 2026-10-14 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
- [Inspected source: skills/motherduck-migrate-to-motherduck/references/EXECUTION_REFERENCE.md ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/EXECUTION_REFERENCE.md) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/EXECUTION_REFERENCE.md Supports: review, install, limitations, access
- [Inspected source: skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md Supports: review, install, limitations, access
- [Inspected source: skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py Supports: review, install, limitations, access
- [Inspected source: scripts/_lib/motherduck_artifact_utils.py ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/scripts/_lib/motherduck_artifact_utils.py) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/scripts/_lib/motherduck_artifact_utils.py Supports: review, install, limitations, access
- [Inspected source: README.md ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/README.md) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/README.md Supports: review, install, limitations, access
- [Inspected source: LICENSE ↗](https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/LICENSE) Checked 2026-10-14 https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/LICENSE Supports: license
- [Interactive Skills installer source formats ↗](https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md) Checked 2026-10-14 https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md Supports: install
- [Pinned source review C2-W11 ↗](https://raw.githubusercontent.com/motherduckdb/agent-skills/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md) Checked 2026-10-15 https://raw.githubusercontent.com/motherduckdb/agent-skills/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md Supports: bestFor, review.notTested, review.reviewedAt

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### DuckDB read file ↗ DuckDB's read-file skill: one DuckDB CLI command that picks a reader by file extension and returns a file's schema, row count and first 20 rows, for local paths or HTTPS, S3, GCS and Azure URLs.](/skills/duckdb-read-file/)[### Azure Cosmos DB for Python ↗ Use Cosmos DB NoSQL clients for partition-aware document operations and parameterized queries.](/skills/microsoft-azure-cosmos-py/)[### CockroachDB SQL ↗ Cockroach Labs skill that turns a natural-language request into CockroachDB SQL, applies the relevant rule files with 00-fundamental-principles.md first, and tells the agent to run EXPLAIN on every generated query when a cluster connection is available.](/skills/cockroachlabs-cockroachdb-sql/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Choose a toolkit](/tools/)
- [Inspect execution hosts](/agents/)
- [Check tool access](/mcp-servers/)
- [Check project dependencies](/check-repo/)
