molt-fetch
Guide for using molt fetch to migrate data from PostgreSQL, MySQL, Oracle, or MSSQL to CockroachDB. Use when running molt fetch commands, configuring storage backends, handling fetch failures/resumption, or chaining fetch with verify.
Install
With your agent
Install OMGSkills skill "cockroachdb/claude-plugin:skills/cockroachdb-onboarding-and-migrations/molt-fetch" into this agent's normal skills directory: use the OMGSkills MCP get_skill tool, install only the pinned_install commit and path, verify SKILL.md against pinned_install.skill_md_sha, 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-fetch ~/.claude/skills/molt-fetch
From README
molt fetch Bulk data migration from source databases (PostgreSQL, MySQL, Oracle, MSSQL) to CockroachDB. Basic Structure Storage Backends (pick one) | Option | When to use | |--------|-------------| | --bucket-path "s3://..." | AWS S3 (also gs:// for GCS, azure:// for Azure) | | --direct-copy | No intermediate storage; fastest for accessible networks | | --local-path "/tmp/molt" + --local-path-listen-addr "0.0.0.0:9005" | CRDB must reach the listen addr | Cloud auth: pass --use-implicit-auth for IAM/ADC/managed identity, or set AWSACCESSKEYID/GOOGLEAPPLICATIONCREDENTIALS env vars. Table Handling (--table-handling) | Value | Behavior | |-------|----------| | none (default) | Append to existing tables | | drop-on-target-and-recreate | Drop + recreate from source schema; enables auto schema creation.
More from this repo
cockroachdb-sql
Used when writing, generating, or optimizing SQL for CockroachDB, designing CockroachDB schemas, or when the user asks...
molt-replicator
Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to...
molt-verify
Guide for using molt verify to compare source and target databases for schema and row-level consistency after a...
