Prisma ORM · Prisma Client queries

Include relations or pick fields

include loads related records, and select returns only the fields you name.

const withPosts = await prisma.user.findMany({ include: { posts: true } });
const names = await prisma.user.findMany({ select: { id: true, name: true } });

Official Prisma ORM documentation

More prisma client queries commands

All prisma client queries commands · Prisma ORM cheatsheet

Was this page helpful?