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

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

npm 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

import { PrismaClient } from '@prisma/client'

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

or

const { PrismaClient } = require('@prisma/client')

const prisma = new PrismaClient()
// 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:

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

const 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:

prisma generate