Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →aiskillstore/db-migration
Use when setting up Alembic migrations or making database schema changes. Triggers for: initializing Alembic, generating migrations, applying upgrades, rolling back changes, or creating data migrations. NOT for: raw SQL execution outside migration context or non-database schema updates.
Passed 17 of 22 test cases with the skill, and 16 of 22 without it.
1 fixed16 passed either way5 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
We need to create an Alembic migration file for our financial module. The migration needs to add a 'fees' table linked to 'students' with columns for student ID, monetary amount, status string defaulting to pending, due date, and timestamps, along with indexes on student ID and status. Please provide the full Python migration file code with both forward upgrade and safe rollback downgrade functions.
| Checked | Without skill | With skill |
|---|---|---|
| Uses sa.func.now() for default timestamp values on created_at and updated_at columns. | Missed | Passed |
| Uses sa.DateTime() for the due_date column definition. | Missed | Passed |
| Includes op.drop_constraint to remove foreign key constraints before dropping the table during downgrade. | Missed | Passed |
The instructions your model reads when the skill loads.
Expert Alembic migration management for SQLModel/FastAPI projects with safe schema evolution and rollback capabilities.
| Command | Purpose |
|---|---|
alembic init alembic | Initialize Alembic in project |
alembic revision --autogenerate -m "message" | Generate migration from model changes |
alembic revision -m "message" | Create empty migration manually |
alembic upgrade head | Apply all pending migrations |
alembic upgrade +1 | Apply one migration at a time |
alembic downgrade -1 | Rollback last migration |
alembic downgrade base | Rollback all migrations |
alembic current | Show current revision |
alembic history | Show migration history |
alembic init alembic
# alembic.ini
sqlalchemy.url = driver://user:pass@localhost/dbname
file_template = %%(year)s_%%(month).2d_%%(day).2d_%%(hour).2d%%(minute).2d_%%(rev)s_%%(slug)s
timezone = UTC
# alembic/env.py
from logging.config import fileConfig
test cases passed, vs 16 / 22 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.