fastapi-db-migrate

name	fastapi-db-migrate
description	> Use when this capability is needed.

Database Migration Helper (FastAPI + Alembic)

Automates Alembic migration creation and model import location updates.

Scope: New model creation with migration generation. For modifying existing models, manually edit the model file and run alembic revision --autogenerate. For stack-neutral migration support (Prisma, Knex, Django, etc.), use /db-migrate. After any migration, verify with /db-migrate-verify.

Note: The backend/ path is a convention. If your project uses a different layout, adjust paths accordingly.

Request: $ARGUMENTS

---

Modes

Mode	Trigger	Behavior
new-model	Model name provided	Create model file + update import locations + generate migration
migrate	"run" or "migrate"	Run alembic upgrade head
status	"status"	Show current migration status
check	"check"	Verify all import locations are in sync

---

STEP 1: New Model Mode

1. Create the Model File

Create backend/app/models/{model_name_snake}.py following existing patterns:

from sqlalchemy import Column, String, DateTime, ForeignKey, func
from sqlalchemy.dialects.postgresql  UUID
 app.db.base  Base
 uuid

 ():
    __tablename__ = 
     = Column(UUID(as_uuid=), primary_key=, default=uuid.uuid4)
    created_at = Column(DateTime(timezone=), server_default=func.now())
    updated_at = Column(DateTime(timezone=), server_default=func.now(), onupdate=func.now())