Is it compatible with SQLAlchemy 2.0?

Absolutely. It is specifically optimized for SQLAlchemy 2.0 async dialects like postgresql+asyncpg.

Does it support NoSQL databases?

Yes, while it features deep support for PostgreSQL and SQLAlchemy, it includes patterns for NoSQL document design, embedding vs. referencing, and sharding.

How does this skill help with zero-downtime migrations?

It implements the 'expand-contract' pattern, providing rules for two-phase column additions and concurrent indexing to ensure the database remains available during schema updates.

Can it fix schema drift?

Yes, the skill includes drift detection rules that help verify environment synchronization and checksum migrations across local, staging, and production.

Database Design & Migration Patterns

Name: Database Design & Migration Patterns
Author: yonatangross

byyonatangross

•

116

•

Gestión de Bases de Datos

Automates professional database schema design, Alembic migrations, and zero-downtime versioning strategies for full-stack applications.

This skill provides a comprehensive framework for managing the entire database lifecycle within Claude Code, specializing in SQLAlchemy and Alembic workflows. It guides developers through complex tasks such as 3NF normalization, asynchronous PostgreSQL migrations, and the 'expand-contract' pattern for zero-downtime deployments. By enforcing best practices like concurrent indexing and two-phase column additions, it prevents common production pitfalls and ensures data integrity across SQL and NoSQL environments.

Características Principales

01116 GitHub stars

02Zero-downtime 'expand-contract' patterns for high-availability schema changes

03Comprehensive SQL normalization (1NF-3NF) and NoSQL document design patterns

04Automated Alembic migration generation for SQLAlchemy 2.0 async models

05Advanced indexing strategies including B-tree, GIN, and HNSW for vector data

06Drift detection and environment synchronization for multi-stage deployment pipelines

Casos de Uso

01Generating safe, reviewed Alembic migrations for production PostgreSQL databases

02Planning complex data migrations and rollbacks without incurring system downtime

03Designing scalable database schemas from scratch with proper normalization and indexing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/orchestkit database-patterns

For use in Claude.ai and ChatGPT

Download Skill