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

Security Hardening for Automated Migration Runners

Customize the variables below to instantly engineer your prompt.

Required Variables

security-hardening-migration-runners.txt
Act as a DevSecOps Database Specialist. Database migrations intrinsically require highly elevated, dangerous privileges. Architect a zero-trust security perimeter specifically for the [CI_CD_RUNNER_TYPE] (e.g., GitHub Actions self-hosted runner or Jenkins worker) tasked with executing these migrations. You must mandate the integration of a [SECRET_MANAGER] (e.g., HashiCorp Vault or AWS Secrets Manager) to dynamically inject short-lived database credentials at runtime. Define a ruthless 'Least Privilege' RBAC model for the migration user ([DB_PRIVILEGES]), ensuring it mathematically possesses the rights to execute `ALTER` or `CREATE` schema statements, but is fundamentally blocked from executing a catastrophic `DROP DATABASE` or `SELECT`ing from tables containing sensitive PII. Detail the exact automation required to revoke and destroy these credentials the millisecond the CI/CD job terminates.

Example Text Output

"A Vault-integrated CI/CD setup where temporary PostgreSQL roles are generated with short-lived 'ALTER' permissions and then immediately revoked upon job completion."

More Cloud & DevOps Prompts

View all →

Frequently Asked Questions

What is the "Security Hardening for Automated Migration Runners" prompt used for?

A Vault-integrated CI/CD setup where temporary PostgreSQL roles are generated with short-lived 'ALTER' permissions and then immediately revoked upon job completion.

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.