Prisma Integration

What problem does it solve?

This skill helps NestJS projects integrate Prisma ORM by providing setup guidance, PrismaService usage, and schema/templates aligned with traceability-backend conventions.

Core Features & Use Cases

• PrismaService integration: Provides a nest-friendly PrismaService wrapper to manage PrismaClient lifecycle.
• AppModule configuration: Global configuration and provider wiring to expose Prisma across modules.
• Audit-friendly data modeling: Guidance to add audit fields (created_at, updated_at, deleted_at and by fields) and soft-delete patterns.
• Migration & tooling workflows: Standardized commands for prisma generate, prisma migrate, and Prisma Studio within a multi-service monorepo.

Quick Start

Install Prisma CLI and client, initialize Prisma, and scaffold a prisma schema. Then configure generator and datasource, generate the client, and wire PrismaService in a NestJS module. For example:

• npm install prisma @prisma/client
• npx prisma init
• Define schema.prisma with a generator client and a Postgres datasource
• npm run prisma:generate