Prisma Client
Prisma Client is Prisma ORM's generated, type-safe query builder for Node.js, Bun, and Deno applications.
Prisma Client is Prisma ORM's generated query builder. It is tailored to your schema, fully typed, and designed to make common database work feel like ordinary application code.
What Prisma Client gives you
- Typed query methods based on your models
- Autocomplete for filters, relations, ordering, and nested writes
- Predictable plain JavaScript objects as query results
- A single client API that works across PostgreSQL, MySQL, SQLite, MongoDB, and more
Quick start
1. Define a generator in your schema
generator client {
provider = "prisma-client"
output = "./generated"
}2. Install Prisma Client
npm install @prisma/client3. Generate the client
npx prisma generateIf you want more detail on this step, see Generating Prisma Client.
4. Import and use the generated client
import { PrismaClient } from "./generated/client";
const prisma = new PrismaClient();
const users = await prisma.user.findMany();Common tasks
- Set up and configure Prisma Client
- Generate Prisma Client
- Run CRUD queries
- Work with relations
- Use transactions
- Use raw SQL when you need it