alembic-migration

Automate Alembic migration creation and management for SQLite and PostgreSQL.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/jzallen/dashboard-chat --skill alembic-migration-jzallen
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: alembic-migration
Source: https://github.com/jzallen/dashboard-chat/tree/main/.claude/skills/alembic-migration
Command: npx skills add https://github.com/jzallen/dashboard-chat --skill alembic-migration-jzallen

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Alembic, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of creating, modifying, and running Alembic database migrations, ensuring compatibility between SQLite and PostgreSQL.

Core Features & Use Cases

  • SQLite/PostgreSQL Compatibility: Ensures migrations work seamlessly across both database systems.
  • Automated Migration Generation: Automatically generates migrations based on ORM model changes.
  • Manual Migration Support: Allows for manual migration creation for data migrations and index changes.
  • Index and Column Operations: Provides guidance on creating indexes and handling column operations.
  • Downgrade Discipline: Ensures migrations can be downgraded safely and properly.

Quick Start

Generate a new Alembic migration for adding a 'things' table with: alembic-migration add-thing-table

Frequently Asked Questions about alembic-migration

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

FAQPage Schema
How do I automate Alembic database migration generation from ORM models?

You can automate Alembic database migration generation by detecting ORM model changes to automatically create migration scripts. This Skill handles index and column operations while maintaining SQLite and PostgreSQL compatibility.

Does Alembic work with both SQLite and PostgreSQL for schema changes?

Yes, Alembic works with both SQLite and PostgreSQL for schema changes. This Skill ensures database migrations execute seamlessly across both database systems, handling index creation and column modifications without compatibility issues.

How do I safely downgrade an Alembic migration?

To safely downgrade an Alembic migration, you need strict downgrade discipline to reverse schema changes properly. This Skill provides the necessary guidance to ensure migrations can be downgraded safely without breaking database integrity.

Can I manually create Alembic migrations for data changes and indexes?

Yes, you can manually create Alembic migrations for data changes and indexes. This Skill supports manual migration creation alongside automated generation, providing specific guidance for data migrations and index operations.

What is the best way to manage database schema changes with Alembic?

The best way to manage database schema changes with Alembic is combining automated generation from ORM models with manual control for data and indexes. This Skill streamlines creation, modification, and application while enforcing safe downgrade practices.

Why do I need Alembic to manage database schema changes?

You need Alembic to manage database schema changes because it provides version control for your database structure. This Skill requires Alembic to automate migrations, handle column operations, and ensure safe downgrades across SQLite and PostgreSQL.