migrations
Database schema migrations and version control
When & Why to Use This Skill
This Claude skill provides a comprehensive framework for managing database schema migrations and version control. It enables developers and DevOps engineers to implement safe, automated, and reversible database changes using industry-standard tools like Flyway, Liquibase, and Prisma, ensuring data integrity and facilitating zero-downtime deployments in professional software workflows.
Use Cases
- Automating schema updates within CI/CD pipelines to maintain environment parity across development, staging, and production.
- Implementing zero-downtime migrations for high-availability applications using blue-green deployment and incremental change patterns.
- Managing complex database versioning and resolving schema conflicts in multi-developer teams through migration history and baseline management.
- Designing robust rollback strategies and reversible migration scripts to mitigate risks during critical database upgrades.
| name | migrations |
|---|---|
| description | Database schema migrations and version control |
| sasmp_version | "1.3.0" |
| bonded_agent | 08-sql-devops |
| bond_type | PRIMARY_BOND |
Database Migrations Skill
Overview
Manage database schema changes with version control, migration tools, and safe deployment practices.
Topics Covered
Migration Tools
- Flyway
- Liquibase
- Alembic (Python)
- Prisma migrations
- TypeORM migrations
Migration Patterns
- Incremental changes
- Reversible migrations
- Data migrations
- Zero-downtime migrations
- Blue-green deployments
Version Control
- Migration versioning
- Baseline management
- Migration history
- Conflict resolution
- Team workflows
Best Practices
- Small, focused changes
- Testing migrations
- Rollback strategies
- Documentation
- CI/CD integration
Prerequisites
- SQL fundamentals
- Version control basics
Learning Outcomes
- Create safe migrations
- Use migration tools
- Deploy without downtime
- Manage schema versions