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

Automated Deadlock Prevention and Migration Performance Guardrails

Customize the variables below to instantly engineer your prompt.

Required Variables

deadlock-prevention-migration-guardrails.txt
Write a 'Database Migration Policy' script to be executed as a linting step in a [CI_CD_PIPELINE]. The script should analyze SQL migration files for 'dangerous' operations (e.g., adding a column with a default value in older PostgreSQL versions, or large index creations). It must enforce the use of [MAX_LOCK_TIMEOUT] and suggest non-blocking alternatives. Specifically, focus on [DATABASE_ENGINE] best practices for online DDL.

Example Text Output

"A shell-based linter that scans SQL files for 'ALTER TABLE' statements without 'CONCURRENTLY' keywords and rejects the Pull Request automatically."

More Cloud & DevOps Prompts

View all →

Frequently Asked Questions

What is the "Automated Deadlock Prevention and Migration Performance Guardrails" prompt used for?

A shell-based linter that scans SQL files for 'ALTER TABLE' statements without 'CONCURRENTLY' keywords and rejects the Pull Request automatically.

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.