Drizzle ORM Database Patterns
Implements standardized Drizzle ORM patterns, query conventions, and Row Level Security (RLS) for robust database management.
Implements standardized Drizzle ORM patterns, query conventions, and Row Level Security (RLS) for robust database management.
This skill provides comprehensive architectural guidance for managing databases using Drizzle ORM, specifically tailored for applications requiring strict data isolation and type safety. It enforces a clean separation of concerns by centralizing database logic in dedicated query files, preventing the direct use of database clients in API routes. By providing clear naming conventions for CRUD operations—distinguishing between safe queries and error-throwing getters—it streamlines backend development. The skill also mandates the implementation of Row Level Security (RLS) to ensure multi-tenant data privacy and leverages Drizzle's powerful inference engine to maintain end-to-end TypeScript safety without manual type maintenance.