Postgres Drizzle

This gets you type-safe PostgreSQL with Drizzle ORM without the usual pitfalls. It covers schema design, relational queries, and migrations with drizzle-kit, plus specific fixes for common performance problems like N+1 queries and missing indexes on foreign keys. The decision trees are genuinely helpful when you're staring at a slow query or trying to figure out which drizzle-kit command to run. It assumes PostgreSQL 18 and pushes you toward connection pooling and the relational query API instead of raw SQL everywhere. Good if you want guardrails around database code that actually prevent the mistakes that show up in production.

skills.sh installs: 1.5K
GitHub stars: 62
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add ccheney/robust-skills --skill postgres-drizzle --agent claude-code

Installs into .claude/skills of the current project.

Files

PostgreSQL and Drizzle ORM

Match database work to the project's installed API and deployment context. The user's explicit instructions take precedence over this skill's guidelines.

Establish the database contract

Use the relevant schema/query, migration history, and requested behavior as input. For Drizzle code, inspect installed drizzle-orm/drizzle-kit versions and the driver; for SQL, establish the PostgreSQL version when a version-specific feature matters.

The references cover PostgreSQL 17/18 and distinguish Drizzle's 0.x relations() API from the v1 defineRelations() API. Do not mix them or infer the installed API from an npm dist-tag. When the version is unknown, use imports/lockfiles or ask for the missing version before giving version-dependent code.