alembic

Name: alembic
Availability: InStock
Author: bswrundquist

Manage database schema migrations with Alembic and SQLAlchemy.

Updated Mar 9, 2026

Search Tags:#database #migrations #python #schema management #sqlalchemy #alembic

Ready to run

npx skills add https://github.com/bswrundquist/devtools --skill alembic-bswrundquist

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: alembic
Source: https://github.com/bswrundquist/devtools/tree/main/src/devtools/templates/claude/user/.claude/skills/alembic
Command: npx skills add https://github.com/bswrundquist/devtools --skill alembic-bswrundquist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the process of managing database schema changes over time, ensuring consistency and facilitating collaboration in development environments.

Core Features & Use Cases

Automated Schema Generation: Create migration scripts based on SQLAlchemy model changes.
Data Migration Handling: Support for complex data backfills and transformations within migrations.
Use Case: When adding a new feature that requires database schema modifications, use this Skill to generate, apply, and manage the necessary migration scripts, ensuring your database schema evolves alongside your application.

Quick Start

Use the alembic skill to generate a new migration script for your database schema changes.

Frequently Asked Questions about alembic

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

FAQPage Schema

How do I manage database schema migrations in a Python application?▼

Database schema migrations are managed by generating and applying revision scripts that alter your database structure. This Skill uses Alembic and SQLAlchemy to automate creating those migration scripts from your Python model changes.

Can I autogenerate migration scripts from SQLAlchemy model changes?▼

Yes, you can autogenerate migration scripts from SQLAlchemy model changes. The Skill detects modifications to your SQLAlchemy models and automatically creates the corresponding Alembic migration scripts to apply those schema updates.

What's the best way to handle data migrations and backfills alongside schema changes?▼

Handling data migrations and backfills alongside schema changes requires writing custom logic within your migration scripts. This Skill supports executing complex data transformations and backfills directly inside your Alembic migration revisions.

How do I resolve multi-head revisions when managing database schema revisions?▼

Multi-head revisions occur when database schema migrations diverge into multiple branches. This Skill supports managing multi-head revisions in Alembic, allowing you to merge branching migration paths and maintain a consistent database migration history.

Do I need SQLAlchemy and Alembic installed to use database schema migrations?▼

Yes, you need SQLAlchemy and Alembic installed and configured. This Skill requires Python, SQLAlchemy, and Alembic to be properly set up in your environment to interact with the database and generate migration scripts.