skills.rest
williamzujkowski
williamzujkowskiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-migration-script-generator
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
RaNDoM6913RaNDoM6913
1

new-migration

Scaffold paired up/down database migration files with tool detection.

Community
Advanced
patrikboroschpatrikborosch
14

dataflows-save-as-authoring-cli

Migrate Power BI Gen1 dataflows to Gen2.1 via CLI-based REST API calls.

Community
Advanced
Patasse97Patasse97

senior-devops

Automate DevOps workflows for CI/CD, infrastructure as code, and deployment orchestration.

Community
Advanced
a53alia53ali

database-migration

Guide database schema migrations with expand/contract patterns and rollback strategies.

Community
Advanced