Prisma Client

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:

schema.prisma
1datasource db {
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:

npm install prisma --save-dev
npx prisma

2. Installation

Install Prisma Client in your project with the following command:

npm install @prisma/client

This command also runs the prisma generate command, which generates Prisma Client into the node_modules/.prisma/client directory.

3. Importing Prisma Client

There are multiple ways to import Prisma Client in your project depending on your use case:

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()
// use `prisma` in your application to read and write data in your DB

For edge environments, you can import Prisma Client as follows:

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

const prisma = new PrismaClient()
// use `prisma` in your application to read and write data in your DB

For Deno, you can import Prisma Client as follows:

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

The import path will depend on the custom output specified in Prisma Client's generator block in your Prisma schema.

4. Use Prisma Client to send queries to your database

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

// run inside `async` function
const newUser = await prisma.user.create({
  data: {
    name: 'Alice',
    email: 'alice@prisma.io',
  },
})

const users = await prisma.user.findMany()

5. 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:

prisma generate