Database Migration Writer

СреднийdevelopmentМинимальный контекст: 16K

Writes safe, reversible database schema migrations and the corresponding rollback scripts. Plans zero-downtime changes using expand-and-contract patterns, handles data backfills and index creation without locking, and generates migrations for tools like Alembic, Flyway, Prisma, Knex, and Rails ActiveRecord with clear up/down steps.

databasemigrationsschemasqlzero-downtimebackend

Варианты использования

  • Writing forward and rollback migrations for schema changes
  • Planning zero-downtime expand-and-contract migrations
  • Backfilling data safely on large tables
  • Adding indexes concurrently without locking
  • Generating migrations for Alembic, Flyway, Prisma, or Rails

Пример промпта

Write a zero-downtime migration to split a "full_name" column into "first_name" and
"last_name" on a PostgreSQL "users" table with 20M rows, using Alembic.

Provide:
1. Expand-and-contract step plan
2. Forward migration(s) with non-locking backfill
3. Application cutover notes
4. Rollback/down migration
5. Verification queries

Рекомендуемые модели

claude-opus-4-6gpt-5deepseek-v4

Совместимые инструменты

claude-codecursorkiroany

Модальности

Вход: text, code
→
Выход: code, text

Похожие Skills

schema-designdatabase-query-optimizermigration-planner

Автор

OpenModels Community

@openmodelsrun