skills.rest
jrmatherly
jrmatherlyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

migration

Generate and optionally apply Alembic database migrations for FastAPI and SQLAlchemy.

1|Updated Feb 27, 2026
Search Tags:#backend#migration#review#sqlalchemy#alembic#code-generation#database-migrations
One-click install
npx skills add https://github.com/jrmatherly/apollos-portal --skill migration-jrmatherly
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: migration
Source: https://github.com/jrmatherly/apollos-portal/tree/main/.claude/skills/migration
Command: npx skills add https://github.com/jrmatherly/apollos-portal --skill migration-jrmatherly

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Alembic migrations are essential for evolving database schemas, and this skill guides you through generating and optionally applying them safely.

Core Features & Use Cases

  • Generate a new Alembic migration based on your description.
  • Review and validate the generated migration before applying.
  • Apply the migration to upgrade the database to the latest schema.

Quick Start

Describe the schema change you want to implement in plain language, and the tool will generate and optionally apply the migration.

Frequently Asked Questions about migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate Alembic migrations for a SQLAlchemy backend?▼

To generate Alembic migrations, you provide a plain language description of the schema change. The tool then automates the creation of a new Alembic revision for your SQLAlchemy backend based on that description.

Can I review an Alembic database migration before applying it?▼

Yes, you can review an Alembic database migration before applying it. The workflow includes a review and validation step for the generated migration content, ensuring you can safely verify changes before execution.

Do I need a uv workspace to use this Alembic migration tool?▼

Yes, you need a uv workspace to use this Alembic migration tool. It requires a Python backend setup with uv, Alembic installed, and a FastAPI and SQLAlchemy environment to function correctly.

What is the best way to apply Alembic migrations safely?▼

The best way to apply Alembic migrations safely is to follow a guided workflow of description, review, and confirmation. After reviewing the generated revision, you can optionally apply it to upgrade the database schema.

How do I verify the current Alembic migration head after upgrading the database?▼

To verify the current Alembic migration head after upgrading the database, the tool includes a verification step. This confirms the database schema has successfully reached the latest generated revision.

Related Skills

Explore More Software Engineering Skills→
0xkynz0xkynz

python-fastapi

Generates modular FastAPI/SQLAlchemy/Alembic project skeletons with automated tests using uv.

Community
Advanced
bswrundquistbswrundquist

alembic

Manage database schema migrations with Alembic and SQLAlchemy.

Community
Intermediate
mefardalesmefardales

python-fastapi

Generate FastAPI project structures with Pydantic validation and async patterns.

Community
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced