skills.rest
bswrundquist
bswrundquistCOMMUNITY
Explore all skills by this author →
GitHub

alembic

Manage database schema migrations with Alembic and SQLAlchemy.

Updated Mar 9, 2026
Search Tags:#database#migrations#python#schema management#sqlalchemy#alembic
One-click install
npx skills add https://github.com/bswrundquist/devtools --skill alembic-bswrundquist
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
NelkitNelkit
1

alembic-migration

Automate PostgreSQL schema changes with SQLAlchemy ORM and Alembic migrations.

Community
Intermediate
linsomniaclinsomniac

alembic-migrations

Automate SQLAlchemy schema migrations with Alembic revision generation and rollbacks.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced