IntroductionQuick startPrerequisites1. Create your NestJS project2. Set up Prisma2.1. Install Prisma and dependencies2.2. Initialize Prisma2.3. Set the generator output path2.4. Configure your database connection2.5. Define your data model2.6. Create and run your migration2.7.

You are going to build a sample NestJS application with a REST API that can read and write data in a database. For the purpose of this guide, you'll use a SQLite database to save the overhead of setting up a database server.

By creating a PrismaService that extends the PrismaClient, you can inject database access throughout your application. NestJS's controller/service pattern pairs naturally with Prisma's type-safe queries, creating a clean separation between your ...

June 4, 2024 - With the Prisma service set up, generate a todo module for all the todo logic with the command below: ... import { Injectable } from '@nestjs/common'; import { PrismaService } from '../../prisma.service'; import { Todo, Prisma } from '@prisma/client'; @Injectable() export class TodoService { constructor(private prisma: PrismaService) {} async getAllTodo(): Promise<Todo[]> { return this.prisma.todo.findMany(); } async getTodo(id: number): Promise<Todo | null> { return this.prisma.todo.findUnique({ where: { id: Number(id) } }); } async createTodo(data: Todo): Promise<Todo> { return this.prisma.todo.create({ data, }); } async updateTodo(id: number): Promise<Todo> { return this.prisma.todo.update({ where: { id: Number(id) }, data: { completed: true }, }); } async deleteTodo(id: number): Promise<Todo> { return this.prisma.todo.delete({ where: { id: Number(id) }, }); } }

June 3, 2022 - Learn how to build a backend REST API with NestJS, Prisma ORM 7, PostgreSQL and Swagger. Set up the project, model your data, build the API and document it with Swagger. Fully updated for Prisma 7 and NestJS 11.

Rust-free and driver adapter NestJS app with prisma-client (Rust-free), driver adapter and nestjs-prisma.

January 7, 2026 - Library and schematics to add Prisma integration to a NestJS application. Latest version: 0.27.0, last published: 7 months ago. Start using nestjs-prisma in your project by running `npm i nestjs-prisma`. There are 9 other projects in the npm registry using nestjs-prisma.

November 29, 2022 - Now, the above example is super simple, but hopefully, you get the idea. Here are a few ideas on how you can take this further: ... [Advanced] Add an auth layer so the userId can be passed in automatically instead of passed into the body of the request · Let's now see how we can work with GraphQL in a NestJS app with Prisma...

January 19, 2024 - To install Prisma Client in your project, run the following command in your terminal: ... When setting up your NestJS application, you’ll want to abstract away the Prisma Client API for database queries within a service.

# for example docker build -t nest-prisma-server . After Docker build your docker image you are ready to start up a docker container running the nest server: docker run -d -t -p 3000:3000 --env-file .env nest-prisma-server · Now open up ...

To initialize Prisma, execute the following command in your terminal: ... In this step, you'll create a PostgreSQL database. We'll use Docker to run a PostgreSQL container. If you already have a PostgreSQL database installed on your computer, feel free to skip this step. Execute the following command in your terminal to create a PostgreSQL container: docker run --name nestjs-prisma-demo -e POSTGRES_PASSWORD=passwd -e POSTGRES_USER=user -e POSTGRES_DB=demo -p 5432:5432 -d postgres

January 8, 2026 - # 1. Install NestJS CLI globally npm install -g @nestjs/cli # 2. Create new project nest new my-awesome-api # Choose npm (or your preference) cd my-awesome-api # 3. Install Prisma npm install @prisma/client npm install -D prisma # 4. Initialize ...

One command to automate the Prisma setup in your NestJS application.

Nx is a build system with smart caching and task orchestration for monorepos and polyrepos. Ship faster and keep CI fast as your codebase scales.

October 3, 2022 - NestJS is a framework for creating scalable, server-side Node.js applications. It uses modern JavaScript, fully supports and is built using TypeScript, and combines elements of object-oriented, functional, and functional reactive programming. This post will demonstrate how to use Nest and Prisma to build a REST API.

February 6, 2025 - Prisma Service: Create src/prisma/prisma.service.ts: import { Injectable, OnModuleInit, OnModuleDestroy } from '@nestjs/common'; import { PrismaClient } from '@prisma/client'; @Injectable() export class PrismaService extends PrismaClient implements OnModuleInit, OnModuleDestroy { async onModuleInit() { await this.$connect(); } async onModuleDestroy() { await this.$disconnect(); } }

August 30, 2024 - To integrate Prisma ORM and PostgreSQL into a NestJS project, follow these steps: ... Edit the prisma/schema.prisma file to define your database schema. Here’s an example schema with a User model:

November 25, 2025 - import { Injectable, OnModuleInit, OnModuleDestroy } from '@nestjs/common'; import { PrismaClient } from '../src/generated/prisma/client'; import { PrismaMariaDb } from '@prisma/adapter-mariadb'; @Injectable() export class PrismaService extends PrismaClient implements OnModuleInit, OnModuleDestroy { constructor() { const adapter = new PrismaMariaDb(process.env.DATABASE_URL!); super({ adapter, log: ['info', 'warn', 'error'] }); } async onModuleInit() { try { await this.$connect(); await this.$queryRaw`SELECT 1`; console.log('✅ Prisma connected to MySQL'); } catch (error) { console.error('❌ Prisma connection error:', error); throw error; } } async onModuleDestroy() { await this.$disconnect(); console.log('🔌 Prisma disconnected from MySQL'); } }

An example of access to module services with forFeature. import { InjectPrismaClient, PrismaModule } from '@nestjs-mod/prisma'; import { NestFactory } from '@nestjs/core'; import { randomUUID } from 'crypto'; import { Injectable, Module } from '@nestjs/common'; import { PrismaClient } from '@prisma/client'; @Injectable() export class FeatureService { constructor( @InjectPrismaClient() private readonly prismaService: PrismaClient ) {} async createUser({ externalUserId }: { externalUserId: string }) { return await this.prismaService.prismaUser.create({ data: { externalUserId } }); } async getUse

July 7, 2024 - Each endpoint above already implemented validation as well according to the DTO, for example: Registration input validation (DTO create-user.dto) ... Now let's jump to the user service. In the service, we'll create functions to interact with the database via Prisma and they'll represent each endpoint mentioned above. ... import { ConflictException, HttpException, Injectable } from '@nestjs/common'; import { User } from '@prisma/client'; import { PrismaService } from 'src/core/services/prisma.service'; import { CreateUserDto } from './dtos/create-user.dto'; import { hash } from 'bcrypt'; @Injectable() export class UsersService { constructor(private prisma: PrismaService) {} // async registerUser // async loginUser // async updateUser // async deleteUser }