NestJS Framework with Drizzle ORM

NestJS Framework with Drizzle ORM

Overview

Provides NestJS patterns with Drizzle ORM for building production-ready server-side applications. Covers CRUD modules, JWT authentication, database operations, migrations, testing, microservices, and GraphQL integration.

When to Use

• Building REST APIs or GraphQL servers with NestJS
• Setting up authentication and authorization with JWT
• Implementing database operations with Drizzle ORM
• Creating microservices with TCP/Redis transport
• Writing unit and integration tests
• Running database migrations with drizzle-kit

Instructions

1. Install dependencies: npm i drizzle-orm pg && npm i -D drizzle-kit tsx
2. Define schema: Create src/db/schema.ts with Drizzle table definitions
3. Create DatabaseService: Inject Drizzle client as a NestJS provider
4. Build CRUD module: Controller → Service → Repository pattern
5. Add validation: Use class-validator DTOs with ValidationPipe
6. Implement guards: Create JWT/Roles guards for route protection
7. Write tests: Use @nestjs/testing with mocked repositories
8. Run migrations: npx drizzle-kit generate → Verify SQL → npx drizzle-kit migrate

Examples

Complete CRUD Module with Drizzle

// src/db/schema.ts
export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  email: text('email').notNull().unique(),
  createdAt: timestamp('created_at').defaultNow(),
});

// src/users/dto/create-user.dto.ts