postgres-drizzle

SKILL.md

Type-safe PostgreSQL applications with Drizzle ORM, migrations, and performance best practices.

Covers schema design, relational queries, transactions, and drizzle-kit workflows (generate, migrate, push, studio)

Includes decision trees for modeling relationships, diagnosing slow queries, and choosing the right commands

Emphasizes critical performance patterns: indexing foreign keys, avoiding N+1 queries with relational APIs, and connection pooling

Provides anti-pattern warnings for common mistakes like missing FK indexes, unvalidated JSON storage, and unsafe production migrations

PostgreSQL + Drizzle ORM

Type-safe database applications with PostgreSQL 18 and Drizzle ORM.

Essential Commands

npx drizzle-kit generate   # Generate migration from schema changes
npx drizzle-kit migrate    # Apply pending migrations
npx drizzle-kit push       # Push schema directly (dev only!)
npx drizzle-kit studio     # Open database browser

Quick Decision Trees

"How do I model this relationship?"