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.
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 - 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
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
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 ↗Checked
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 ↗Checked
https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/references/MIGRATION_VALIDATION.md
Supports: review, install, limitations, access
https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/artifacts/migration_validation_example.py
Supports: review, install, limitations, access
https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/scripts/_lib/motherduck_artifact_utils.py
Supports: review, install, limitations, access
https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/README.md
Supports: review, install, limitations, access
- Inspected source: LICENSE ↗Checked
https://github.com/motherduckdb/agent-skills/blob/f97855858bee6cff552031358666824cf01754c5/LICENSE
Supports: license
https://github.com/vercel-labs/skills/blob/7407f3893ad4dceab546ac002c3ef806e4000c73/README.md
Supports: install
https://raw.githubusercontent.com/motherduckdb/agent-skills/f97855858bee6cff552031358666824cf01754c5/skills/motherduck-migrate-to-motherduck/SKILL.md
Supports: bestFor, review.notTested, review.reviewedAt