Menu
Use when writing data migrations (backfills, counter updates) with Alembic
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
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