molt-replicator
Guide for using the CockroachDB replicator to continuously replicate changes from PostgreSQL, MySQL, or Oracle to CockroachDB after an initial molt fetch data load. Use when setting up CDC replication, configuring pglogical/mylogical/oraclelogminer, or managing the fetch → replicator cutover workflow.
Install
With your agent
Install OMGSkills skill "cockroachdb/claude-plugin:skills/cockroachdb-onboarding-and-migrations/molt-replicator" 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-replicator ~/.claude/skills/molt-replicatorFrom README
molt replicator Continuous change-data-capture (CDC) replication from source databases to CockroachDB. Run after molt fetch completes the initial bulk load. Important: replicator is a separate binary from molt. It is not invoked by molt fetch. The data-load-and-replication mode in molt fetch is deprecated — use replicator directly instead. Architecture Replicator reads changes from the source, buffers them in a staging schema on the target CRDB cluster, and applies them to the target tables. Subcommands by Source | Source | Command | |--------|---------| | PostgreSQL | replicator pglogical | | MySQL | replicator mylogical | | Oracle | replicator oraclelogminer | | Kafka | replicator kafka | | Cloud storage | replicator objstore | | CockroachDB CDC | replicator start | Full Fetch → Replicator Workflow Step 1: Initial bulk load with molt fetch drop-on-target-and-recreate drops any existing target tables first; run this only against a fresh or empty target.
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-verify
Guide for using molt verify to compare source and target databases for schema and row-level consistency after a...