Skip to main content

Schema Management

Database schema version control, migration generation, rollback capability, and schema documentation for evolving data models.

Complexity: Moderate | Duration: 15-30m | Category: Devops

Tags: data-engineering schema migration database

Workflow Diagram​

Steps​

Step 1: Schema design​

Agent: database

architect - Design new tables, columns, indexes

Step 2: Migration generation​

Agent: data

engineer - Generate SQL migration (Alembic, Flyway, Liquibase)

Step 3: Migration review​

Agent: database

architect - Review for performance, safety

Step 4: Backward compatibility​

Agent: database

architect - Ensure safe migration (add before remove)

Step 5: Testing​

Agent: data

engineer - Test migration on copy of production data

Step 6: Migration application​

Agent: data

engineer - Apply migration with transaction

Step 7: Rollback testing​

Agent: data

engineer - Verify rollback script works

Step 8: Documentation​

Agent: database

architect - Update schema docs, ERD diagrams

Usage​

To execute this workflow:

/workflow devops/schema-management.workflow

See other workflows in this category for related automation patterns.