devops-database-migration

Purpose

Design and execute database schema migrations with zero-downtime using Flyway, Liquibase, or Alembic — backward-compatible changes, expand-contract pattern, and CI/CD integration.

Agent Protocol

Trigger

Any user message referencing database migration, schema change, Flyway, Liquibase, Alembic, zero-downtime migration, expand-contract, or rollback.

Input Context

Database type, current schema version, desired change, tool preference, zero-downtime requirement, CI/CD pipeline details.

Output Artifact

Migration scripts (SQL or changeset XML/YAML), rollback scripts, CI/CD pipeline config for migration steps, expand-contract execution plan.

Response Format

SQL scripts, tool-specific config (Flyway V-style, Liquibase changeset). Pipeline YAML with migration stage.