Agent skill · data analytics · yonatangross

database-patterns

Schema design, Alembic migrations and database versioning. Use when creating migrations, designing or normalizing schemas, or fixing schema drift.

Why this skill is useful

Provides specific patterns and rules for Alembic migrations and schema design that the AI wouldn't reliably generate on its own.

What it needs

About 5k tokens when loaded. Last updated 2026-08-06. 215 stars on the source repository.

What this skill does

<!-- directive-density: intentional (teaches migration anti-patterns; NEVER markers describe real production-break conditions, not aspirational guidance) --> Database Patterns Comprehensive patterns for database migrations, schema design, and version management. Each category has individual rule files in rules/ loaded on-demand. Quick Reference Category Rules Impact When to Use ---------- ------- -------- ------------- Alembic Migrations 2 CRITICAL Data migrations, branch management Schema Design 3 HIGH Normalization, indexing strategies, NoSQL patterns Versioning 2 HIGH Changelogs, schema drift detection Zero-Downtime Migration 2 CRITICAL Expand-contract, pgroll, rollback monitoring Database Selection 1 HIGH Choosing the right database, PostgreSQL vs MongoDB, cost analysis Total: 10 rules across 5 categories This skill is a wrap around Alembic and PostgreSQL, not a replacement for their docs. Read references/ork-delta.md first: it holds the version floors, corrections and house conventions that upstream does not carry. Everything in the table below was removed on purpose. Upstream coverage (do not restate) These topics are vendor documentation. Fetch them from the source instead of re-teaching them here. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills yonatangross/database-patterns

View the source on GitHub

Browse the @skills marketplace