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

Post-Migration Data Integrity Validation Framework

Customize the variables below to instantly engineer your prompt.

Required Variables

post-migration-data-integrity-validation.txt
Act as a Data Quality Assurance Lead. Create an uncompromising, fully automated post-migration data validation suite. This Python/Bash framework must execute in a blocking state immediately after a CI/CD database migration script completes, but strictly *before* the global load balancer is allowed to switch application traffic to the new version. The script must programmatically query and mathematically compare the [SOURCE_SCHEMA] against the new [TARGET_SCHEMA], evaluating exact row counts, generating MD5 hash checksums on highly critical columns (like balances or passwords), and executing complex [VALIDATION_LOGIC] (e.g., ensuring zero nulls were introduced during a type cast). If any mathematical parity validation fails, the script must return a non-zero exit code to the CI runner, instantly aborting the release and triggering an idempotent database rollback.

Example Text Output

"An automated data-auditor script that uses SQL MD5 aggregates to verify that sensitive financial data remained intact during a column-type conversion."

More Cloud & DevOps Prompts

View all →

Frequently Asked Questions

What is the "Post-Migration Data Integrity Validation Framework" prompt used for?

An automated data-auditor script that uses SQL MD5 aggregates to verify that sensitive financial data remained intact during a column-type conversion.

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.