qa-db-migrations
Database migration testing: 4 skills (atlas-migrations, flyway-migrations, liquibase-migrations, sqlmesh-migrations) and 2 agents (db-migration-performance-critic, migration-blast-radius-reviewer). Covers schema-change safety, blast-radius review, and rollback verification across the major migration tools.
Install this plugin
/plugin install qa-db-migrations@testland-qaPart of role bundle: qa-role-backend
qa-db-migrations
Database migration testing. Four per-tool skill wrappers covering the mainstream database migration ecosystem (Flyway, Liquibase, Atlas, SQLMesh) plus an adversarial reviewer agent that classifies operations against an 8-category taxonomy and refuses to approve production-unsafe patterns.
Anchored on the ISO 25010 portability characteristic. Universal need: every team that ships schema changes.
Components
| Type | Name | Description |
|---|---|---|
| Skill | flyway-migrations | V/U/R prefix versioned SQL migrations + flyway_schema_history; production guards (cleanDisabled, validateOnMigrate) |
| Skill | liquibase-migrations | XML/YAML/JSON/SQL changelog with preconditions + contexts/labels + per-changeset rollback |
| Skill | atlas-migrations | Terraform-style declarative HCL or SQL schema; atlas migrate diff/apply/lint with destructive-pattern detection |
| Skill | sqlmesh-migrations | Data-pipeline + virtual environments; auto-classification of breaking-vs-non-breaking + downstream impact analysis |
| Agent | migration-blast-radius-reviewer | Adversarial reviewer for any migration tool: 8-category operation taxonomy; refuses to approve unsafe NOT NULL or DROP COLUMN without consumer coordination |
| Agent | db-migration-performance-critic | Performance-focused adversarial reviewer: flags missing CONCURRENTLY on index creation, full-table-rewrite ALTERs holding ACCESS EXCLUSIVE locks, missing post-migration ANALYZE, partition-pruning hazards, and MySQL VARCHAR boundary crossings |
Install
/plugin marketplace add testland/qa
/plugin install qa-db-migrations@testland-qaSkills
atlas-migrations
Authors and runs Atlas database schema migrations - declarative HCL or SQL schema definition with `atlas schema apply` for desired-state apply OR `atlas migrate diff` to generate versioned migrations against a dev DB; `atlas migrate apply` to deploy; `atlas migrate lint` to flag destructive / locking / data-loss patterns; `atlas migrate hash` to detect tampering. Supports PostgreSQL, MySQL, SQL Server, ClickHouse, SQLite, MariaDB, Snowflake, Oracle, Redshift, Spanner, CockroachDB, Databricks. Use when the user wants Terraform-style declarative DB schema management or modern SQL-first migration linting beyond Flyway / Liquibase.
flyway-migrations
Authors and runs Flyway database migrations - versioned (`V1__add_users.sql`), repeatable (`R__refresh_views.sql`), and undo (`U1__remove_users.sql`) migration files in `db/migration/`; runs `flyway migrate` / `info` / `validate` / `clean` / `baseline` / `repair`; tracks state in the `flyway_schema_history` table; supports 50+ databases including Oracle / SQL Server / MySQL / PostgreSQL / MariaDB / Snowflake / BigQuery; integrates with Maven, Gradle, CLI, and Docker. Use when the user works with Flyway-managed schemas, asks about migration ordering, or needs CI gates on schema changes.
liquibase-migrations
Authors and runs Liquibase database migrations - changelog-driven schema management with changesets in XML / YAML / JSON / SQL formats; supports `liquibase update` / `status` / `rollback` / `tag` / `history` lifecycle; offers per-changeset preconditions, contexts and labels for selective execution, and rollback semantics; tracks state in `DATABASECHANGELOG` + `DATABASECHANGELOGLOCK` tables. Use when the user works with Liquibase-managed schemas (Spring Boot heritage, polyglot DB shops), needs cross-DBMS portable migrations, or requires fine-grained rollback control.
sqlmesh-migrations
Authors and runs SQLMesh - data-transformation framework with version control, virtual data environments, automatic breaking-vs-non-breaking change classification, and downstream impact analysis; supports `sqlmesh init` / `plan` / `apply` / `run` / `audit` / `test` lifecycle; covers DuckDB, Postgres, Snowflake, BigQuery, Redshift, Databricks. Use when the user works with SQL data pipelines (warehouse + dbt-adjacent ELT), needs safer model evolution than dbt's deploy-and-pray, or wants the strongest impact-analysis story in the OSS data tooling space.
Agents
db-migration-performance-critic
Adversarial performance reviewer for a single database migration (Flyway V*.sql, Liquibase changeset, Atlas migration). Flags missing CONCURRENTLY on index creation, full-table-rewrite ALTERs holding ACCESS EXCLUSIVE locks, missing post-migration statistics (ANALYZE), partition-pruning hazards, and lock-time estimates for large-table operations. Emits a BLOCK / PASS verdict with a findings table. Use before merging any migration PR to catch slow-path DDL that the correctness-focused migration-blast-radius-reviewer does not cover; that agent covers breaking changes, rollback paths, and consumer coordination - this agent covers only DDL locking and query-performance impact.
migration-blast-radius-reviewer
Adversarial reviewer for a single database migration (Flyway V*.sql, Liquibase changeset, Atlas migration, or SQLMesh model change). Classifies operations as additive / breaking / data-loss / locking / lock-escalating; estimates downtime risk for large-table operations; identifies downstream consumers via grep on column/table names; flags missing rollback path; surfaces unsafe defaults (NOT NULL add without default, narrow column type change, foreign-key add without index). Returns Critical / Warning / Info findings table. Use proactively before merging any DB migration PR.