What problem does it solve?
This Skill provides structured methods to seamlessly incorporate Drizzle ORM into NestJS projects, addressing database schema design, relation management, migration workflows, and performance optimization.
Core Features & Use Cases
- Schema Design & Indexing: Defines type-safe tables, enums, and indexes for efficient data storage.
- Relation Modeling: Implements one-to-many, many-to-many, and self-referential relations with relational integrity.
- Migration Workflow: Guides through schema evolution, migration generation, and deployment best practices.
- Advanced Querying: Demonstrates complex select, raw SQL, and optimization techniques including transactions and nested queries.
- Repository Pattern: Establishes scalable, domain-specific repositories for clean data access layers.
- Testing & Development: Sets up test databases, fixtures, and best practices for reliable, repeatable tests.
Quick Start
Use this Skill to set up a full-featured ORM solution in NestJS by configuring modules, defining schemas, and implementing relations and repositories.