Blenra LogoBlenra
Optimized for: Gemini / ChatGPT / Claude
#Database

Pre-Deployment 'Dry Run' Framework for SQL Migrations

Customize the variables below to instantly engineer your prompt.

Required Variables

sql-migration-dry-run-framework.txt
Act as a Database CI/CD Pipeline Architect. Engineer a highly advanced 'Dry Run' simulation stage deeply embedded within the [CI_CD_TOOL] pipeline that executes a proposed database migration entirely within an isolated SQL transaction that is mathematically guaranteed to `ROLLBACK` upon completion. The simulation framework must actively intercept and capture all generated database warnings, calculate precise execution duration times, and aggressively monitor total lock acquisition counts generated by the [DATABASE_ENGINE]. You must script the logic to compile this raw telemetry data and output it into a highly readable, structured [REPORT_FORMAT] (e.g., Markdown table with Red/Green highlights). This report must be automatically injected as a sticky comment directly on the developer's Pull Request, explicitly visualizing the exact performance impact the migration will have on the production cluster without making a single permanent data mutation.

Example Text Output

"A custom GitHub Action that wraps SQL execution in a 'BEGIN; ... ROLLBACK;' block and extracts the 'pg_stat_statements' data to predict production impact."

More Cloud & DevOps Prompts

View all →

Frequently Asked Questions

What is the "Pre-Deployment 'Dry Run' Framework for SQL Migrations" prompt used for?

A custom GitHub Action that wraps SQL execution in a 'BEGIN; ... ROLLBACK;' block and extracts the 'pg_stat_statements' data to predict production impact.

Which AI tools work with this prompt?

This prompt is optimized for Gemini / ChatGPT / Claude, but works great with ChatGPT, Claude, Gemini, and other large language models. Simply copy it and paste it into your preferred AI tool.

How do I customize this prompt?

Use the variable fields above to fill in your specific details. The prompt will auto-update as you type, ready to copy instantly.

Is this prompt free?

Yes! All prompts on Blenra are free to copy and use immediately. No account required.