drizzle-best-practices

Drizzle ORM done right. pgTable schema design, relations(), $inferSelect/$inferInsert type
inference, prepared statements, drizzle-kit migrations, relational queries, drizzle-zod, and
connection pooling.
> AI coding assistants default to Prisma syntax, write raw SQL instead of using the query builder,
> manually define types that mirror schemas, and skip drizzle-kit for migrations. This plugin
> anchors your agent to Drizzle's actual API.
Install
Cursor / Claude Code / Windsurf
Or copy skills/ into your .cursor/skills/ or .claude/skills/ directory.
What's Included
| Type | Name | Description |
| ------- | ------------------------ | ------------------------------------------------------------------------------------ |
| Skill | drizzle-best-practices | 12 rules for schema design, relations, type inference, queries, migrations, and more |
| Rule | best-practices | Always-on behavioral rule that enforces Drizzle ORM patterns |
| Command | /audit | Scan your codebase for Drizzle ORM anti-patterns |
What Agents Get Wrong
| What the agent writes | What Drizzle actually uses |
| ----------------------------- | ---------------------------------------------- |
| Prisma-style model User { } | pgTable("users", { ... }) |
| @relation decorators | relations() function |
| Raw SQL strings | Drizzle query builder API |
| Manual interface User { } | $inferSelect and $inferInsert |
| Hand-written migration SQL | drizzle-kit generate + drizzle-kit migrate |
| No query preparation | db.query.users.findMany().prepare() |
Related Plugins
- typescript-best-practices - TypeScript
5.x strict patterns for type-safe queries
- fastapi-best-practices - FastAPI patterns
(if using Drizzle with a Python backend via API)
- vibe-guard - Security guardrails for database operations
---
If this helped your workflow, a star helps others find it.