you-music/backend/MIGRATION_QUICKREF.md

Database Migration Quick Reference

Daily Commands

# Check current version
./migrate.sh current

# Create new migration (after modifying models)
./migrate.sh create "Add description here"

# Apply migrations
./migrate.sh upgrade

# Rollback last migration
./migrate.sh downgrade

# View history
./migrate.sh history

Workflow

1. Modify Model (app/models/models.py)
2. Create Migration (./migrate.sh create "message")
3. Review Migration (alembic/versions/*.py)
4. Apply Migration (./migrate.sh upgrade)
5. Update Schema (app/schemas/schemas.py if needed)

Important Notes

• ✅ Migrations run automatically on app startup
• ✅ Safe for production - preserves data
• ✅ Can rollback if needed
• ❌ Never edit applied migrations
• ❌ Never delete database in production
• 📝 Always commit migration files to git

Files

• alembic/versions/*.py - Migration scripts
• alembic.ini - Alembic configuration
• alembic/env.py - Migration environment
• migrate.sh - Helper script

See Also

• Full guide: MIGRATIONS.md
• AI context: AGENTS.md
• Models: backend/app/models/models.py