Intuitive Database Client for TypeScript and Node.js

Prisma Client

Explore the
Prisma Client API

From simple reads to complex nested writes, the Prisma Client supports a wide range of operations to help you make the most of your data.

• Find Records
• Traverse Relations
• Order By, Limits & Cursors
• Aggregates & Group By

1// Find all posts
2const allPosts: Post[] = await prisma.post.findMany()

1// Find a user by ID
2const userById: User | null = await prisma.user.findUnique({
3  where: {
4    id: 2,
5  },
6})

1// Find a user by email
2const userByEmail = await prisma.user.findUnique({
3  where: {
4    email: 'ada@prisma.io',
5  },
6})

1// Find the first user that contains Ada
2const userByName = await prisma.user.findFirst({
3  where: {
4    name: {
5      contains: 'Ada',
6    },
7  },
8})

1// Select specific fields
2const userName = await prisma.user.findUnique({
3  where: {
4    email: 'ada@prisma.io',
5  },
6  select: {
7    name: true,
8    email: true,
9  },
10})