migrations

数据库架构迁移和版本控制

📖 中文导读:数据库架构迁移和版本控制 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。

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