How does it handle migration conflicts in team environments?

The skill includes specialized branching and merging rules for Alembic to help resolve migration conflicts during collaborative feature development.

Does this skill support asynchronous database drivers?

Yes, it includes specific patterns for SQLAlchemy 2.0 and postgresql+asyncpg for modern asynchronous applications.

Is it limited to PostgreSQL?

While PostgreSQL is the primary recommendation, the skill includes universal schema design patterns for NoSQL databases and general SQL standards.

Can it help with zero-downtime deployments?

Absolutely; it provides dedicated expand-contract patterns and integration advice for tools like pgroll to ensure migrations don't interrupt live services.

Database Design & Migration Patterns

Name: Database Design & Migration Patterns
Author: yonatangross

byyonatangross

•

116

•

数据库管理

Implements production-ready database schema designs and Alembic migration workflows for high-availability applications.

This skill provides a comprehensive framework for managing the entire database lifecycle, from initial schema design and 3NF normalization to zero-downtime migrations and schema drift detection. It features specialized patterns for SQLAlchemy and Alembic, advanced indexing strategies for PostgreSQL, and NoSQL design principles, ensuring that database changes are safe, reversible, and optimized for production performance without service interruptions.

主要功能

01Automated Alembic migration workflows with native async SQLAlchemy support.

02Advanced schema design guides for both SQL (3NF) and NoSQL document structures.

03Comprehensive database versioning, changelogs, and automated drift detection.

04Zero-downtime migration patterns using expand-contract strategies and pgroll.

05Safe indexing strategies including concurrent index creation for high-volume tables.

06116 GitHub stars

使用场景

01Managing consistent database version control and rollbacks across multiple environments.

02Executing complex, multi-phase database migrations without application downtime.

03Designing and normalizing relational schemas to ensure data integrity and query performance.

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