database-migration

Conditional rollback for database migration reverts schema changes if deployment fails, ensuring data integrity. This Skill executes local tests to validate migrations before deployment and performs rollbacks when failures occur during the automated process.

Database migration tools supported include golang-migrate and goose. This Skill automates generation, review, testing, and deployment of SQL schema migrations using these tools, requiring PostgreSQL for execution to manage schema changes safely.

PostgreSQL is required for database migration execution. This Skill requires a PostgreSQL setup to automate the generation, review, testing, and deployment of schema migrations, ensuring changes are validated locally before CI/CD integration.

Automated database migration generation creates scripts for common SQL schema changes like adding columns or creating tables. This Skill generates these migrations, applies safety rules to prevent pitfalls, and prepares them for local testing and deployment.

Safety rules and guardrails for database migrations prevent common pitfalls during schema changes. This Skill applies best practices to automate the generation, review, testing, and deployment of SQL migrations, ensuring consistent and repeatable database modifications.

Testing database migrations locally validates schema changes before deployment. This Skill automates the review process and executes local tests using golang-migrate or goose, ensuring migrations are safe to deploy via CI/CD pipelines to production environments.