postgres-drizzle
✓PostgreSQL and Drizzle ORM best practices. Triggers on: PostgreSQL, Postgres, Drizzle, database, schema, tables, columns, indexes, queries, migrations, ORM, relations, joins, transactions, SQL, drizzle-kit, connection pooling, N+1, JSONB, RLS. Use when: writing database schemas, queries, migrations, or any database-related code. Proactively apply when creating APIs, backends, or data models.
Installation
SKILL.md
| CRITICAL | Index all foreign keys | Prevents full table scans on JOINs | | CRITICAL | Use relational queries for nested data | Avoids N+1 | | HIGH | Connection pooling in production | Reduces connection overhead | | HIGH | EXPLAIN ANALYZE slow queries | Identifies missing indexes | | MEDIUM | Partial indexes for filtered subsets | Smaller, faster indexes |
| MEDIUM | UUIDv7 for PKs (PG18+) | Better index locality |
| No FK index | Slow JOINs, full scans | Add index on every FK column | | N+1 in loops | Query per row | Use with: relational queries | | No pooling | Connection per request | Use @neondatabase/serverless or similar | | push in prod | Data loss risk | Always use generate + migrate |
Facts (cite-ready)
Stable fields and commands for AI/search citations.
- Install command
npx skills add https://github.com/ccheney/robust-skills --skill postgres-drizzle- Source
- ccheney/robust-skills
- Category
- </>Dev Tools
- Verified
- ✓
- First Seen
- 2026-02-01
- Updated
- 2026-02-18
Quick answers
What is postgres-drizzle?
PostgreSQL and Drizzle ORM best practices. Triggers on: PostgreSQL, Postgres, Drizzle, database, schema, tables, columns, indexes, queries, migrations, ORM, relations, joins, transactions, SQL, drizzle-kit, connection pooling, N+1, JSONB, RLS. Use when: writing database schemas, queries, migrations, or any database-related code. Proactively apply when creating APIs, backends, or data models. Source: ccheney/robust-skills.
How do I install postgres-drizzle?
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/ccheney/robust-skills --skill postgres-drizzle Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code or Cursor
Where is the source repository?
https://github.com/ccheney/robust-skills
Details
- Category
- </>Dev Tools
- Source
- skills.sh
- First Seen
- 2026-02-01