molt-replicator

Replicate database changes from PostgreSQL, MySQL, and Oracle to CockroachDB.

3|3|Updated Mar 11, 2026
One-click install
npx skills add https://github.com/cockroachdb/claude-plugin --skill molt-replicator-cockroachdb
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: molt-replicator
Source: https://github.com/cockroachdb/claude-plugin/tree/main/skills/onboarding-and-migrations/molt-replicator
Command: npx skills add https://github.com/cockroachdb/claude-plugin --skill molt-replicator-cockroachdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Continuous change-data-capture (CDC) replication from source databases to CockroachDB after an initial molt fetch, keeping targets synchronized with minimal downtime.

Core Features & Use Cases

  • Reads changes from PostgreSQL, MySQL, Oracle and buffers them in a staging area before applying to the target CockroachDB.
  • Supports multiple source modes (pglogical, mylogical, oraclelogminer) and helper workflows for cutover, monitoring, and error handling.
  • Use case: after performing a bulk load with molt fetch, enable continuous replication to maintain up-to-date data consistency across systems.

Quick Start

Start the replicator with your source and target configurations to begin continuous replication.

Frequently Asked Questions about molt-replicator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I set up CDC replication from PostgreSQL to CockroachDB?

To set up CDC replication from PostgreSQL to CockroachDB, you must enable logical replication on the source and use the pglogical mode to continuously apply changes after completing an initial bulk load.

Can I replicate data from MySQL and Oracle to CockroachDB?

Yes, you can replicate data from MySQL and Oracle to CockroachDB using mylogical and oraclelogminer modes respectively, which capture changes and buffer them in a staging database before applying them to the target.

Do I need a separate binary for continuous data migration to CockroachDB?

Yes, continuous data migration to CockroachDB requires a separate replicator binary along with a staging database to buffer changes before applying them to the target cluster.

What is the best way to keep CockroachDB synchronized after a bulk data load?

The best way to keep CockroachDB synchronized after a bulk data load is to enable continuous CDC replication, which applies source database changes in near real-time to maintain data consistency across systems.

Does CockroachDB CDC replication support cutover and monitoring workflows?

Yes, CockroachDB CDC replication supports cutover and monitoring workflows, providing configurable flags for parallelism, pooling, retry, and error handling to manage the replication process.

Can I use Kafka or object stores as sources for CockroachDB replication?

Yes, you can use Kafka and object stores as optional sources for CockroachDB replication, allowing you to stream data changes into your target cluster alongside PostgreSQL, MySQL, and Oracle sources.