Prisma setup in NestJS - Mini Project: Build & Apply

Prisma setup in NestJS

📖 Scenario: You are building a simple NestJS backend application that needs to connect to a database using Prisma ORM. Prisma helps you manage your database easily with type-safe queries.In this project, you will set up Prisma in a NestJS project step-by-step, so your app can talk to the database.

🎯 Goal: Set up Prisma in a NestJS project by creating the Prisma service, configuring the Prisma module, and integrating it into the main app module.After completing, your NestJS app will be ready to use Prisma for database operations.

📋 What You'll Learn

Create a PrismaService class that extends PrismaClient

Add a configuration variable for Prisma logging

Create a PrismaModule that provides PrismaService

Import PrismaModule into the main AppModule

💡 Why This Matters

🌍 Real World

Setting up Prisma in NestJS is a common task when building backend APIs that need to interact with databases safely and efficiently.

💼 Career

Many companies use NestJS with Prisma for scalable backend development. Knowing this setup is valuable for backend developer roles.

1

Create PrismaService class

Create a class called PrismaService that extends PrismaClient from @prisma/client. Inside the constructor, call super() to initialize the client.

NestJS

# Your code here
// Create PrismaService class extending PrismaClient
// Call super() inside constructor

Need a hint?

Think of PrismaService as a helper that talks to the database. Extending PrismaClient gives it all the database powers.

2

Add Prisma logging configuration

Inside the PrismaService constructor, add a configuration object to super() with a log property set to ["query", "error", "warn"] to enable logging of queries, errors, and warnings.

NestJS

import { PrismaClient } from '@prisma/client';

export class PrismaService extends PrismaClient {
  constructor() {
    // Add logging config to super()
    super();
  }
}

Need a hint?

Logging helps you see what Prisma is doing behind the scenes. Pass the log array inside super().

3

Create PrismaModule to provide PrismaService

Create a NestJS module called PrismaModule using @Module decorator from @nestjs/common. Inside @Module, add providers and exports arrays both containing PrismaService.

NestJS

import { Module } from '@nestjs/common';

// Create PrismaModule with PrismaService provider and export

Need a hint?

Modules group related providers. Exporting PrismaService lets other modules use it.

4

Import PrismaModule into AppModule

In the main AppModule, import PrismaModule inside the imports array of the @Module decorator from @nestjs/common.

NestJS

import { Module } from '@nestjs/common';
import { PrismaModule } from './prisma.module';

// Import PrismaModule inside AppModule imports array

Need a hint?

Importing PrismaModule makes PrismaService available app-wide.