Overview

Prisma Client is an auto-generated and type-safe query builder that's tailored to your data. The easiest way to get started with Prisma Client is by following the Quickstart.

Quickstart (5 min)

The setup instructions below provide a high-level overview of the steps needed to set up Prisma Client. If you want to get started using Prisma Client with your own database, follow one of these guides:

Set up a new project from scratch

Add Prisma to an existing project

Set up

1. Prerequisites

In order to set up Prisma Client, you need a Prisma schema file with your database connection, the Prisma Client generator, and at least one model:

1datasource postgresql {
2 url = env("DATABASE_URL")
3 provider = "postgresql"
4}
5
6generator client {
7 provider = "prisma-client-js"
8}
9
10model User {
11 id Int @id @default(autoincrement())
12 createdAt DateTime @default(now())
13 email String @unique
14 name String?
15}

Also make sure to install the Prisma CLI:

1npm install @prisma/cli --save-dev
2npx prisma

2. Installation

You can install Prisma Client in your project with this command:

1npm install @prisma/client

Note that this command also run the prisma generate command which generates the Prisma Client into the node_modules/@prisma/client directory.

3. Use Prisma Client to send queries to your database

1import { PrismaClient } from '@prisma/client'
2
3const prisma = new PrismaClient()
4// use `prisma` in your application to read and write data in your DB

or

1const { PrismaClient } = require('@prisma/client')
2
3const prisma = new PrismaClient()
4// use `prisma` in your application to read and write data in your DB

Once you have instantiated PrismaClient, you can start sending queries in your code:

1// run inside `async` function
2const newUser = await prisma.user.create({
3 data: {
4 name: 'Alice',
5 email: 'alice@prisma.io',
6 },
7})
8const users = await prisma.user.findMany()

4. Evolving your application

Whenever you make changes to your database that are reflected in the Prisma schema, you need to manually re-generate Prisma Client to update the generated code in the node_modules/@prisma/client directory:

1prisma generate

In this section

Edit this page on Github