Queries

Excluding fields

Learn how to exclude fields from Prisma Client results with the omit option.

Use omit when you want Prisma Client to return the normal result shape except for a few specific fields.

Omit a field for one query

const user = await prisma.user.findUnique({
  where: { id: 1 },
  omit: {
    password: true,
  },
});

Omit fields globally

You can also configure omit on the client itself:

const prisma = new PrismaClient({
  omit: {
    user: {
      password: true,
    },
  },
});

When to use omit vs select

Use select when you want to return only a small subset of fields.
Use omit when the default result is mostly correct and you only want to remove a few sensitive or noisy fields.

Select fields

Learn how to return only the fields and relations you need with select and include in Prisma Client.

Relation queries

Prisma Client provides convenient queries for working with relations, such as a fluent API, nested writes (transactions), nested reads and relation filters

On this page

Omit a field for one query Omit fields globally When to use omit vs select Related pages