Database Migration Script Generator

Generate database migration scripts for Liquibase, Flyway, or Alembic.

6|Updated Oct 25, 2025

Search Tags:#rollback #database #migration #zero-downtime #alembic #flyway #liquibase

Ready to run

npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-migration-script-generator

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Database Migration Script Generator
Source: https://github.com/williamzujkowski/cognitive-toolworks/tree/main/skills/database-migration-generator
Command: npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-migration-script-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Generating robust database migrations for Liquibase, Flyway, and Alembic with built-in rollback safety and zero-downtime patterns to minimize risk and downtime during deployments.

Core Features & Use Cases

Schema migrations (add/drop columns, tables, indexes, and constraints)
Data migrations with backfill and transformation logic
Zero-downtime deployment patterns (expand/contract, online DDL)
Rollback script generation and validation checks
Deployment guides and sanity validation queries for post-migration checks
Tool-agnostic templates with tool-specific syntax

Quick Start

Run the generator with your database, tool preference, and change description to produce a ready-to-run migration script.

Frequently Asked Questions about Database Migration Script Generator

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

FAQPage Schema

How do I generate zero-downtime database migration scripts for PostgreSQL?▼

To generate zero-downtime database migration scripts for PostgreSQL, you provide the database type, migration tool, and change description to apply expand/contract patterns and online DDL operations safely.

Can I create rollback scripts for Flyway and Liquibase migrations automatically?▼

Yes, you can create rollback scripts for Flyway and Liquibase migrations automatically by inputting the schema change description, which enforces strict validation and generates corresponding rollback procedures.

What is the best way to handle data backfill and transformations during a schema migration?▼

The best way to handle data backfill and transformations during a schema migration is to specify the data migration logic in the change description, which generates safe, production-ready scripts with validation checks.

Does this migration generator support SQL Server and Oracle schema changes?▼

Yes, this migration generator supports SQL Server and Oracle schema changes, producing tool-specific syntax for Liquibase, Flyway, or Alembic alongside deployment guides and sanity validation queries.

How do I validate database changes after running a zero-downtime deployment?▼

To validate database changes after running a zero-downtime deployment, you use the generated post-migration sanity validation queries and machine-readable metadata to verify schema integrity and automation outputs.