القائمة
Use when creating or managing database migrations with Alembic
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
Record browser-based feature demos as GIFs via Playwright and optionally document them in docs/features/index.md. Trigger with "Demo <feature>" or "Demo and Document <feature>".
Use when creating service modules in apps/api/skillhub/services/
Use when writing API tests in apps/api/tests/
Use when implementing division-based access control on any endpoint
Use when adding services to docker-compose.yml or creating Dockerfiles
Use when implementing error handling across the API, frontend, or MCP server
| name | alembic-migration-manager |
| description | Use when creating or managing database migrations with Alembic |
| Task | Command |
|---|---|
| Generate from models | mise run db:make-migration "description" |
| Apply all | mise run db:migrate |
| Rollback one | mise run db:rollback |
| Rollback all | mise run db:rollback:all |
| Check status | mise run db:check |
| Full reset | mise run db:reset |
libs/db/alembic/versions/YYYYMMDD_HHMM_description.py
# 1. Edit model in libs/db/skillhub_db/models/
# 2. Generate migration
mise run db:make-migration "add user_preferences table"
# 3. Review generated file
# 4. Apply
mise run db:migrate
def upgrade():
op.add_column('skills', sa.Column('deprecated_at', sa.DateTime))
op.create_index('idx_skills_deprecated', 'skills', ['deprecated_at'])
def downgrade():
op.drop_index('idx_skills_deprecated')
op.drop_column('skills', 'deprecated_at')
def upgrade():
# Schema change
op.add_column('skills', sa.Column('new_field', sa.String))
# Data backfill
op.execute("UPDATE skills SET new_field = old_field WHERE old_field IS NOT NULL")
alembic check in CI fails if models diverge from migrations. Run mise run db:check locally before committing.
libs/db/alembic.inilibs/db/alembic/versions/001_initial_schema.pylibs/db/skillhub_db/models/