drizzle-best-practices

Drizzle ORM schema design for PostgreSQL involves defining tables, columns, identity columns, JSONB, and enums. This skill provides modular guidance to standardize schema creation and reduce common pitfalls across your database structure.

Drizzle migrations and kit workflows are managed through drizzle-kit commands like generate, push, pull, and migrate. This skill outlines versioned migration patterns to ensure consistent database state transitions across environments.

Type safety in Drizzle schemas allows you to infer TypeScript types and derive Zod or Valibot validators. This skill provides strategies to enforce end-to-end type safety directly from your PostgreSQL database definitions.

Drizzle ORM best practices apply to serverless environments like Neon and Supabase, as well as traditional Node.js drivers. This skill delivers engine-aware guidance for PostgreSQL across different deployment contexts.

Relational queries in Drizzle use the defineRelations function to establish connections between tables. This skill covers query patterns for select, insert, update, and delete operations within your PostgreSQL relations.

RC vs 0.45.x migration guidance for Drizzle is needed when upgrading versions to ensure compatibility. This skill includes activation workflows and modular frontmatter to navigate version-specific schema and migration changes.