스킬 파일

Add Database Migration

Name: Add Database Migration
Author: hjcas87

Create and apply Alembic migrations when SQLAlchemy models are modified. Use whenever database schema changes are needed. CRITICAL: models must be synchronized with database tables.

hjcas870 스타2026. 4. 12.

직업
카테고리: 데이터베이스 도구

스킬 내용

When to use

Adding a new SQLAlchemy model
Modifying an existing model (adding/removing columns, changing types)
Renaming columns or tables
Any change to database schema

Rules (STRICT)

NEVER modify models without creating a migration
NEVER modify database manually without migrations
ALWAYS verify models are synchronized after migration

Steps

1) Modify the model

Update SQLAlchemy model in models.py
Ensure type hints are correct

2) Generate migration

cd backend
uv run alembic revision --autogenerate -m "Description of changes"

Add Database Migration

When to use

Rules (STRICT)

Steps

1) Modify the model

2) Generate migration

Add Database Migration

When to use

Rules (STRICT)

Steps

1) Modify the model

2) Generate migration

3) Review generated migration

4) Edit migration if needed

5) Apply migration

6) Verify synchronization

7) Commit migration

Validation

Common mistakes

Database Migrations

Database Migrations

Postgres Patterns

Frontend Query & Mutation

Db Migrations

Drizzle