skills.rest
duboc
dubocCOMMUNITY
Explore all skills by this author →
GitHub

data-migrator

Migrate mainframe data to cloud databases with bulk load and CDC.

1|1|Updated Apr 6, 2026
Search Tags:#postgresql#etl#cdc#data-migration#bulk-load#mainframe#db2
One-click install
npx skills add https://github.com/duboc/mainframe-skills-mig --skill data-migrator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-migrator
Source: https://github.com/duboc/mainframe-skills-mig/tree/main/skills/05-data-migrator
Command: npx skills add https://github.com/duboc/mainframe-skills-mig --skill data-migrator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Move decades of mainframe data to cloud databases while the source remains operational, enabling coexistence and staged convergence.

Core Features & Use Cases

  • Bulk historical load: export and transform legacy data for cloud targets.
  • Real-time CDC: stream ongoing changes to keep cloud data current.
  • Convergence verification: validate row counts and checksums before proceeding.

Quick Start

Run the Phase 05 data-migrator workflow to start bulk load and CDC in parallel.

Frequently Asked Questions about data-migrator

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

FAQPage Schema
How do I migrate mainframe DB2 data to PostgreSQL while the source remains online?▼

Mainframe DB2 data migration to PostgreSQL uses parallel bulk historical loads and real-time Change Data Capture streams to keep the source operational. This approach enables cloud database coexistence and staged convergence without downtime.

How do I decode COMP-3 and convert EBCDIC data during a mainframe data migration?▼

Decode COMP-3 and convert EBCDIC data during mainframe data migration by applying built-in data transformation steps within the bulk extraction workflow. This ensures legacy mainframe formats are correctly translated for cloud database targets.

Can I run bulk historical load and real-time CDC in parallel for mainframe data?▼

Yes, you can run bulk historical load and real-time CDC in parallel to move mainframe data to cloud databases. This parallel execution keeps cloud data current while the initial historical transfer is still ongoing.

What is the best way to verify convergence between DB2 z/OS and PostgreSQL targets?▼

The best way to verify convergence between DB2 z/OS and PostgreSQL targets is to validate row counts and checksums. This process confirms data consistency before completing the final migration cutover.

Does this data migration process support both DB2 z/OS and PostgreSQL targets?▼

Yes, the data migration process supports DB2 z/OS and PostgreSQL targets directly. It handles bulk extraction, data transformation, and real-time CDC configuration across both database environments.

Related Skills

Explore More Data & Analytics Skills→
DauQuangThanhDauQuangThanh
14

ibm-mainframe

Consolidate IBM Mainframe administration, development, and modernization guidance.

Community
Advanced
Snowflake-LabsSnowflake-Labs
1

validate-objects

Validate data consistency between source systems and Snowflake post-migration.

Official
Intermediate
ancolemanancoleman
503

ingesting-data

Facilitates data ingestion from cloud, APIs, files, and streaming sources into databases.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-replication

Monitor Cloud SQL for PostgreSQL replication lag and role permissions.

Official
Intermediate