migration-database

What problem does it solve?

This Skill automates database migration workflows for SQLModel-based projects using Alembic, ensuring that your database schema always reflects your SQLModel definitions and preventing manual errors or inconsistencies.

Core Features & Use Cases

• Automatic Migration Generation: Generates migrations automatically from SQLModel changes, enforcing SQLModel as the single source of truth.
• Mandatory Import Fix: Automatically adds import sqlmodel to generated migrations, preventing common runtime errors.
• Safety Checks & User Review: Performs pre-generation checks, summarizes changes, and requires explicit user confirmation before applying any migration.
• Use Case: You've added a new priority field to your Task model. Use this skill to automatically generate the correct Alembic migration, ensure it's valid, and apply it to your database, all while keeping you informed and in control.

Quick Start

To generate a migration for model changes:

just alembic-auto -m "add priority field to Task model"

After reviewing the generated migration file, to apply it:

just alembic-up