Prisma ORM Syntax Cheat Sheet

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())

  @@map("users")
}

model Post {
  id        Int      @id @default(autoincrement())
  title     String
  content   String?
  authorId  Int
  author    User     @relation(fields: [authorId], references: [id], onDelete: Cascade)

  @@index([authorId])
  @@map("posts")
}

import { PrismaClient } from "@prisma/client";

const prisma = new PrismaClient();

// Create record with nested relation
const newUser = await prisma.user.create({
  data: {
    email: "user@example.com",
    name: "Alice",
    posts: {
      create: [{ title: "First Post" }, { title: "Second Post" }]
    }
  },
  include: { posts: true }
});

// Read with filtering and pagination
const users = await prisma.user.findMany({
  where: {
    email: { endsWith: "@example.com" }
  },
  take: 10,
  skip: 0,
  orderBy: { createdAt: "desc" }
});

// Upsert (update or insert)
const user = await prisma.user.upsert({
  where: { email: "user@example.com" },
  update: { name: "Alice Smith" },
  create: { email: "user@example.com", name: "Alice Smith" }
});