Alembic

This is a detailed reference for managing database schema changes with Alembic in customer support systems. You get practical patterns for the full migration lifecycle: autogenerated versus manual migrations, handling data transformations during schema changes, and production deployment strategies. The examples focus on common support system scenarios like adding ticket priority fields and migrating status enums. Worth reading if you're past the basic tutorial phase and need to understand how to safely run migrations in production without breaking active support operations. The data migration section alone will save you from common pitfalls when you need to backfill or transform existing records.

skills.sh installs: 645
GitHub stars: 63
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add manutej/luxor-claude-marketplace --skill alembic --agent claude-code

Installs into .claude/skills of the current project.

Files

Alembic Database Migration Management Skill

Overview

This skill provides comprehensive guidance for managing database migrations using Alembic in customer support environments. It covers everything from initial setup through complex production deployment scenarios, with a focus on maintaining data integrity and minimizing downtime for support operations.

Core Concepts

What is Alembic?

Alembic is a lightweight database migration tool for use with SQLAlchemy. It provides a way to manage changes to your database schema over time through version-controlled migration scripts. For customer support systems, this means:

Version Control: Track all schema changes in your support database
Reproducibility: Apply the same migrations across dev, staging, and production
Rollback Capability: Safely revert problematic changes
Team Collaboration: Merge schema changes from multiple developers
Data Preservation: Migrate data during schema transformations