molt-verify
Guide for using molt verify to compare source and target databases for schema and row-level consistency after a migration. Use when running verify commands, tuning concurrency/sharding, handling schema mismatches, or validating data integrity post-migration.
Install
With your agent
Install OMGSkills skill "cockroachdb/claude-plugin:skills/cockroachdb-onboarding-and-migrations/molt-verify" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
git clone https://github.com/cockroachdb/claude-plugin /tmp/claude-plugin && ln -s /tmp/claude-plugin/skills/cockroachdb-onboarding-and-migrations/molt-verify ~/.claude/skills/molt-verifyFrom README
molt verify Compares source and target databases for schema (DDL) and row (data) consistency. Run after molt fetch to confirm migration integrity. Basic Structure Verification Phases Phase 1 — Schema: Compares table presence, columns, types, NOT NULL constraints, and primary key structure. Phase 2 — Rows (default, --rows=true): Iterates source rows in PK order and compares against target. Reports missing, extraneous, and mismatched rows per shard. Modes | Mode | Command | Use When | |------|---------|----------| | Full (default) | molt verify --source "..." --target "..." | Post-migration integrity check | | Schema-only | molt verify ... --rows=false | Fast DDL check; no data I/O | Concurrency & Sharding Sharding splits a table's PK range across workers. Supported PK types: INT, FLOAT, DECIMAL, UUID. Falls back to a single full-scan for unsupported types.
More from this repo
cockroachdb-sql
Used when writing, generating, or optimizing SQL for CockroachDB, designing CockroachDB schemas, or when the user asks...
molt-fetch
Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB.
molt-replicator
Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to...