Next-generation & fully type-safe ORM for NestJS
Query data from MySQL, PostgreSQL & SQL Server databases in NestJS apps using Prisma – a better ORM for JavaScript and TypeScript.
What is Prisma?
Prisma is an open-source ORM that drastically simplifies data modeling, migrations, and data access for SQL databases in Node.js and TypeScript.
// Creating a new recordawait prisma.user.create({ firstName: “Alice”, email: “alice@prisma.io”})id firstName email 1 Bobby bobby@tables.io2 Nilufar nilu@email.com3 Jürgen jums@dums.edu4 Alice alice@prisma.ioHow Prisma and NestJS fit together
Prisma is a next-generation ORM that can be used to query a database in NestJS apps. It embraces TypeScript to avoid runtime errors and improve productivity. The type-safety it provides goes far beyond the guarantees of traditional ORMs like TypeORM or Sequelize (learn more).
Prisma and NestJS code examples
Combining NestJS and Prisma provides a new level of type-safety that is impossible to achieve with any other ORM from the Node.js & TypeScript ecosystem. This example demonstrates how to use Prisma Client
following NestJS' modular architecture via Dependency Injection by implementing a UserService class that will provide CRUD or domain-specific operations to your application controllers.
PrismaService
A PrismaService class can be implemented by extending the generated PrismaClient in order to build an abstraction of Prisma Client that integrates with your NestJS architecture. It will be provided to other services and controllers via Dependency Injection.
1import { Injectable, OnModuleInit, INestApplication } from '@nestjs/common'2import { PrismaClient } from '@prisma/client'3
4@Injectable()5export class PrismaService extends PrismaClient6 implements OnModuleInit {7
8 async onModuleInit() {9 await this.$connect();10 }11
12 async enableShutdownHooks(app: INestApplication) {13 this.$on('beforeExit', async () => {14 await app.close();15 }); 16 }17}PrismaService
A PrismaService class can be implemented by extending the generated PrismaClient in order to build an abstraction of Prisma Client that integrates with your NestJS architecture. It will be provided to other services and controllers via Dependency Injection.
1import { Injectable, OnModuleInit, INestApplication } from '@nestjs/common'2import { PrismaClient } from '@prisma/client'3
4@Injectable()5export class PrismaService extends PrismaClient6 implements OnModuleInit {7
8 async onModuleInit() {9 await this.$connect();10 }11
12 async enableShutdownHooks(app: INestApplication) {13 this.$on('beforeExit', async () => {14 await app.close();15 }); 16 }17}Why Prisma and NestJS?
Embracing TypeScript
Prisma is the first ORM that provides full type-safety, even when querying partial models and relations.
Smooth integration
Prisma fits perfectly into the modular architecture of NestJS and provides a powerful database access layer.
Type-safe database client
Prisma Client ensures fully type-safe database queries with benefits like autocompletion - even in JavaScript.
Intuitive data modeling
Prisma's declarative modeling language is simple and lets you intuitively describe your database schema.
Easy database migrations
Generate predictible and customizable SQL migrations from the declarative Prisma schema.
Designed for building APIs
Prisma Client reduces boilerplates by providing queries for common API features (e.g. pagination, filters, ...).
Featured Prisma & NestJS community examples
A starter kit covering everything you need to build NestJS with Prisma in production.
Learn how to use Prisma with NestJS in the official NestJS documentation.
A comprehensive workshop and series about building a NestJS REST API with Prisma.
An in-depth article about the migration process of a NestJS app from TypeORM to Prisma.
Get Involved
Join the Prisma Community
Join us on Slack
Get help and engage with thousands of NestJS and Prisma developers on Slack
Showcase your project
We'd love to see what you're building with NestJS and Prisma
Get stickers
Show your NestJS + Prisma love with free custom stickers
