database-migration-patterns
Master versioned, reversible database migrations that evolve schemas without downtime. Learn Alembic setup, multi-phase column operations, data backfills, and testing strategies to keep applications running during schema changes.
Database Migration Patterns helps you implement safe, reversible schema changes with zero-downtime strategies and Alembic.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-22
Database Migration Patterns helps you implement safe, reversible schema changes with zero-downtime strategies and Alembic. Master versioned, reversible database migrations that evolve schemas without downtime. Learn Alembic setup, multi-phase column operations, data backfills, and testing strategies to keep applications running during schema changes.
Use it when
- database-migration-patterns covers Alembic setup from initialization through env.py configuration.
- database-migration-patterns emphasizes testing both directions of every migration before production.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Install
organvm/a-i--skills/database-migration-patterns · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How to safely migrate database schema without downtime?
database-migration-patterns teaches safe schema evolution through versioned, reversible migrations. The skill covers zero-downtime techniques including multi-phase operations for renames and removals, concurrent index creation, and strategies that prevent table locks. You'll learn to structure changes so applications continue running while schemas evolve, using Alembic's upgrade/downgrade capabilities to maintain control over each transition.
What is Alembic migration setup and configuration?
database-migration-patterns covers Alembic setup from initialization through env.py configuration. You'll learn to initialize Alembic in your project, configure database connectivity, set up version control for migrations, and customize the migration environment. The skill includes best practices for organizing migration files, managing multiple database targets, and configuring Alembic to work safely in production pipelines.
How do you test migration upgrade and downgrade paths?
database-migration-patterns emphasizes testing both directions of every migration before production. The skill teaches frameworks and strategies for validating upgrade paths, ensuring downgrades restore previous state, and catching data loss or corruption early. You'll learn to automate migration testing, verify schema integrity after transitions, and build confidence that rollbacks will succeed if needed.
How can you safely rename a column in production?
database-migration-patterns covers multi-phase column rename patterns that eliminate downtime. The approach involves creating a new column, backfilling data, updating application code to use both columns, then dropping the old column in a later phase. This skill teaches how to coordinate these phases, handle concurrent writes, and validate data integrity throughout the rename process.
What strategies exist for backfilling and transforming data?
database-migration-patterns teaches data migration strategies that run safely during schema evolution. You'll learn to backfill new columns with computed or transformed values, handle large tables in batches to avoid locks, and validate data consistency after transformations. The skill covers techniques for concurrent data changes and ensures backfills don't block application traffic.
How do you prevent table locks during schema changes?
database-migration-patterns addresses lock prevention through techniques like concurrent index creation, non-blocking column additions, and multi-phase operations. The skill teaches database-specific approaches (PostgreSQL, MySQL) for avoiding exclusive locks, batching large changes, and structuring migrations so applications remain responsive. You'll learn to monitor lock contention and adjust strategies for your database platform.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Database Migration Patterns
Evolve database schemas safely with versioned, reversible, tested migrations.
Alembic Setup
# Initialize
alembic init alembic
# Create migration
alembic revision --autogenerate -m "add skills table"
# Run migrations
alembic upgrade head
# Rollback one step
alembic downgrade -1
# Show current state
alembic current
alembic history
Configuration
```python
alembic/env.py
from app.models import Base from
(truncated - see the full file via the links below)
File tree — 1 file
skills/development/database-migration-patterns/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Implement safe, reversible database schema changes with zero downtime”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Alembic provides version-controlled database migration management for support systems built on SQLAlchemy. Create, test, and deploy schema changes across environments while preserving data integrity and enabling safe rollbacks.
Master database migration techniques including expand-contract patterns, safe index creation, and batch processing for large tables. This skill covers zero-downtime schema changes, foreign key constraints, and rollback strategies using Alembic.
Master Alembic migration patterns for evolving SQLAlchemy database schemas safely. This skill covers initialization, auto-generating migrations from model changes, executing manual data transformations, and deploying schema updates without downtime using proven patterns like nullable-first column additions and concurrent indexing.
Build robust database layers with SQLModel patterns for one-to-many, many-to-many, and self-referential relationships. Manage schema evolution safely using Alembic migrations, from autogenerated changes to complex data transformations. Includes query optimization techniques, inheritance patterns, and production-ready helper scripts.
SQLAlchemy ORM Expert covers modern ORM patterns, session handling, and query performance tuning tailored for customer support systems. Learn to design robust data models with relationships, leverage async operations in FastAPI, and integrate PostgreSQL effectively. The skill walks through real support scenarios including ticket management, user authentication, and bulk data operations.
SQLAlchemy equips Python developers with a robust SQL toolkit and ORM for building type-safe database applications. Master declarative models, relationship mapping, efficient query patterns, and async support using SQLAlchemy 2.0's modern API.
More skills oma-db (MIT)