Profile My skills Saved My plugins Edit profile Submit a skill

DB Migrate

Create and run database migrations for fancai. Use when changing database schema, adding columns, creating tables, or modifying SQLAlchemy models. Use when this capability is needed.

tomevault-io Updated
Coding & Dev Tools

File contents

Database Migration Workflow

Steps

  1. Analyze Change: Understand what schema change is needed
  2. Update Model: Modify SQLAlchemy model in backend/app/models/
  3. Update Schema: Modify Pydantic schema in backend/app/schemas/
  4. Generate Migration: cd backend && alembic revision --autogenerate -m "$ARGUMENTS"
  5. Review Migration: Read the generated migration file, verify:
    • Correct upgrade() and downgrade() operations
    • No data loss in downgrade
    • Proper index creation
  6. Test Migration: cd backend && alembic upgrade head
  7. Verify: Run backend tests cd backend && uv run python -m pytest -v --tb=short

Conventions

  • Migration message format: descriptive snake_case
  • Always include downgrade() implementation
  • For production: test migration on staging data first

Source: sandk0/fancai — distributed by TomeVault.

tomevault-io/skills-registry/tree/main/sandk0--fancai--db-migrate commit 4f39a0f746

Browse category

Frequently asked questions

npx skillmds@latest add tomevault-io/db-migrate