Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →aiskillstore/alembic
Database migration management for SQLAlchemy projects using Alembic
Passed 21 of 23 test cases with the skill, and 19 of 23 without it.
2 fixed19 passed either way2 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.
I need to write a migration script for an existing table with user records. I want to introduce a required 'full_name' column, but I first need to populate it with concatenated data from existing 'first_name' and 'last_name' columns. Can you provide the upgrade and downgrade migration code for this multi-step schema and data update?
| Checked | Without skill | With skill |
|---|---|---|
| The upgrade function obtains the database bind using op.get_bind(). | Missed | Passed |
| The data update query is wrapped with sa.text. | Missed | Passed |
The instructions your model reads when the skill loads.
Alembic is a database migration tool for SQLAlchemy projects that provides version control for your database schema.
# Generate migration from model changes
uv run alembic revision --autogenerate -m "Add user table"
# Check if there are pending changes
uv run alembic check
# Upgrade to latest version
uv run alembic upgrade head
# Upgrade to specific revision
uv run alembic upgrade ae1027a6acf
# Downgrade one revision
uv run alembic downgrade -1
# Downgrade to base (empty schema)
uv run alembic downgrade base
# Show current database revision
uv run alembic current
# Show all revision history
uv run alembic history
test cases passed, vs 19 / 23 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.