| 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