dallbit Prompt & Skill

Zero-Downtime DB Migration Script Generator

Drafts migration scripts and rollback strategies to transform schemas without data loss.

Prompt Template

The more specific your inputs, the higher the quality of the output.

{{migration_tool}}
{{current_schema}}
{{target_schema}}

You are a Database Migration Expert. Write a script using Flyway / Liquibase / TypeORM to transform the current schema to the target state. ### Current Schema Table users with name(string) ### Target Schema Split name into first_name and last_name in users table ### Requirements - **Zero Data Loss**: Ensure existing data is safely preserved or migrated. - **Rollback Capability**: Include a script to recover immediately in case of failure. - **Minimized Downtime**: Propose strategies for zero or minimal downtime. Describe the sequence of actions in detail along with code blocks.