skills.rest
DauQuangThanh
DauQuangThanhCOMMUNITY
Explore all skills by this author →
GitHub

database-migration

Coordinate database migrations with structured planning, schema conversion, and rollback workflows.

14|11|Updated Dec 1, 2025
Search Tags:#planning#postgresql#migrations#oracle#data-integrity#downtime#database-migration
One-click install
npx skills add https://github.com/DauQuangThanh/hanoi-rainbow --skill database-migration-dauquangthanh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-migration
Source: https://github.com/DauQuangThanh/hanoi-rainbow/tree/main/skills/database-migration
Command: npx skills add https://github.com/DauQuangThanh/hanoi-rainbow --skill database-migration-dauquangthanh

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Coordinate database migrations to minimize downtime while preserving data integrity.

Core Features & Use Cases

  • Comprehensive guidance for planning engine changes, version upgrades, and cloud migrations.
  • Step-by-step workflow covering assessment, environment setup, schema migration, data migration, cutover, testing, and rollback.
  • Real-world scenarios including Oracle to PostgreSQL, MySQL to PostgreSQL, and on-premises to cloud migrations.

Quick Start

Plan a migration scope and execute an end-to-end database migration using the defined strategy.

Frequently Asked Questions about database-migration

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

FAQPage Schema
How do I plan a database migration to minimize downtime?▼

A structured database migration workflow minimizes downtime by coordinating assessment, environment setup, schema conversion, data transfer, cutover, and rollback while preserving data integrity.

What is the best way to migrate an Oracle database to PostgreSQL?▼

Migrating Oracle to PostgreSQL requires a structured workflow that handles heterogeneous schema conversion, data transfer, and application changes, followed by testing and post-migration validation to ensure data integrity.

Can I use this workflow for both cloud migrations and engine upgrades?▼

Yes, this database migration workflow applies to homogeneous and heterogeneous migrations, database engine upgrades, and on-premises to cloud migrations, providing step-by-step guidance for each scenario.

How do I execute a database cutover and rollback safely?▼

Safe database cutover and rollback are executed by following the defined migration strategy, which includes post-migration validation and testing phases to preserve data integrity and handle failures.

Do I need specific tools for schema conversion during a heterogeneous database migration?▼

Heterogeneous database migrations require tooling for schema conversion and data transfer. The workflow provides references for best practices and tooling to ensure a successful migration.

Related Skills

Explore More Software Engineering Skills→
Datus-aiDatus-ai
1.5k

data-migration

Migrate tables between heterogeneous database engines with schema inspection and reconciliation.

Official
Advanced
oalansilvaoalansilva

zero-downtime-migration

Plan and execute zero-downtime migrations with dual-write and rollback triggers.

Community
Advanced
jasrajtulsijasrajtulsi

torch-geometric

Builds PyTorch Geometric workflows for node, link, and graph tasks with sampling and explainability.

Community
Advanced
ai-enhanced-engineerai-enhanced-engineer
3

gcp-cicd-patterns

Automate CI/CD pipeline design on Google Cloud Platform with Cloud Build and Cloud Deploy.

Official
Advanced