Optimized for: Gemini / ChatGPT / Claude
Advanced AI Prompt for Database Migration Synchronization CI
Use this engineered prompt to drastically optimize your workflow and output.
Required Variables
- ✦
[DB_ENGINE] - ✦
[MIGRATION_PATH] - ✦
[DB_URL_SECRET]
database-migration-synchronization-ci.txt
Architect a GitHub Actions workflow to handle database migrations for [DB_ENGINE]. The workflow should: 1) Trigger on a merge to the 'release' branch. 2) Set up a temporary service container (e.g., Postgres/MySQL) for validation. 3) Run migration scripts located in [MIGRATION_PATH] against the service container to ensure they are valid. 4) On success, execute the migrations against the production database using [DB_URL_SECRET]. 5) Implement a slack notification for migration success or failure.
Example Output
"A database-aware YAML using 'docker-compose' or 'services' in GitHub Actions to validate SQL/ORM migrations before production."