菜单
Use when writing data migrations (backfills, counter updates) 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 | data-migration-builder |
| description | Use when writing data migrations (backfills, counter updates) with Alembic |
def upgrade():
op.execute("""
UPDATE skills SET install_count = (
SELECT COUNT(*) FROM installs
WHERE installs.skill_id = skills.id AND installs.uninstalled_at IS NULL
)
""")
def downgrade():
pass # Data migrations typically not reversible
For large tables, batch:
op.execute("UPDATE skills SET field = value WHERE id IN (SELECT id FROM skills LIMIT 1000)")
libs/db/alembic/versions/libs/db/alembic.ini