npm · #3659 most downloaded on npm

@prisma/client

Prisma Client is an auto-generated, type-safe and modern JavaScript/TypeScript ORM for Node.js that's tailored to your data. Supports PostgreSQL, CockroachDB, MySQL, MariaDB, SQL Server, SQLite & MongoDB databases.

Last release 2 days ago
27 Aug 2026
Ships fairly regularly
a new release about every 1 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
3 versions withdrawn
withdrawn after publishing
7 years old
10653 releases · first in 2020

Release timeline

10653 releases since 2020

2020202120222023202420252026

20202026

One column per quarter.

Releases

5.14.0-dev.658 May 2024pre-release
Nothing published for this version
5.14.0-dev.648 May 2024pre-release
Nothing published for this version
5.14.0-dev.638 May 2024pre-release
Nothing published for this version
5.14.0-dev.628 May 2024pre-release
Nothing published for this version
5.14.0-dev.618 May 2024pre-release
Nothing published for this version
5.14.0-dev.608 May 2024pre-release
Nothing published for this version
5.14.0-dev.598 May 2024pre-release
Nothing published for this version
5.14.0-dev.588 May 2024pre-release
Nothing published for this version
5.14.0-dev.578 May 2024pre-release
Nothing published for this version
5.14.0-dev.568 May 2024pre-release
Nothing published for this version
5.14.0-dev.558 May 2024pre-release
Nothing published for this version
5.14.0-dev.547 May 2024pre-release
Nothing published for this version
5.14.0-dev.537 May 2024pre-release
Nothing published for this version
5.14.0-dev.527 May 2024pre-release
Nothing published for this version
5.14.0-dev.516 May 2024pre-release
Nothing published for this version
5.14.0-dev.506 May 2024pre-release
Nothing published for this version
5.14.0-dev.496 May 2024pre-release
Nothing published for this version
5.14.0-dev.483 May 2024pre-release
Nothing published for this version
5.14.0-dev.473 May 2024pre-release
Nothing published for this version
5.14.0-dev.462 May 2024pre-release
Nothing published for this version
5.14.0-dev.442 May 2024pre-release
Nothing published for this version
5.14.0-dev.432 May 2024pre-release
Nothing published for this version
5.14.0-dev.422 May 2024pre-release
Nothing published for this version
5.14.0-dev.412 May 2024pre-release
Nothing published for this version
5.14.0-dev.402 May 2024pre-release
Nothing published for this version
5.14.0-dev.392 May 2024pre-release
Nothing published for this version
5.14.0-dev.382 May 2024pre-release
Nothing published for this version
5.14.0-dev.362 May 2024pre-release
Nothing published for this version
5.14.0-dev.351 May 2024pre-release
Nothing published for this version
5.14.0-dev.3430 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.3330 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.3230 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.3130 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.3030 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2830 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2730 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2630 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2530 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2430 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2329 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2226 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2126 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.2026 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1926 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1826 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1625 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1425 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1325 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1224 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.1124 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.924 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.624 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.524 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.424 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.324 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.224 Apr 2024pre-release
Nothing published for this version
5.14.0-dev.124 Apr 2024pre-release
Nothing published for this version
5.13.023 Apr 2024
Release notes
Today, we are excited to share the 5.13.0 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo or posting on X about the release.

Highlights

omit fields from Prisma Client queries (Preview)

We’re excited to announce Preview support for the omit option within the Prisma Client query options. The highly-requested omit feature now allows you to exclude fields that you don’t want to retrieve from the database on a per-query basis.

By default, when a query returns records, the result includes all scalar fields of the models defined in the Prisma schema. select can be used to return specific fields, while omit can now be used to exclude specific fields. omit lives at the same API level and works on all of the same Prisma Client model queries as select. Note, however, that omit and select are mutually exclusive. In other words, you can’t use both in the same query.

To get started using omit, enable the omitApi Preview feature in your Prisma schema:
```
// schema.prisma
generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["omitApi"]
}
```
Be sure to re-generate Prisma Client afterwards:
```
npx prisma generate
```
Here is an example of using omit:
```
// Includes all fields except password
await prisma.user.findMany({
  omit: {
   password: true
  },
})
```
Here is an example of using omit with include:
```
// Includes all user fields except user's password and title of user's posts
await prisma.user.findMany({
  omit: {
   password: true
  },
  include: {
    posts: {
      omit: {
        title: true
      },
    },
  },
})
```
<details> <summary>Expand to view the example Prisma schema</summary>
```
model User {
  id       Int     @id @default(autoincrement())
  email    String  @unique
  name     String?
  password String
  posts    Post[]
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  author   User   @relation(fields: [authorId], references: [id])
  authorId Int
}
```
</details>

Many users have requested a global implementation of omit. This request will be accommodated in the future. In the meantime, you can follow the issue here.

📣 Share your feedback: omitApi Preview feature

📚 Documentation: omit - Prisma Client API Reference

Fixes and improvements

Prisma Migrate
- Nicer Datamodel Type validation
Prisma Client
Credits

Huge thanks to @ospfranco, @pranayat, @yubrot, @skyzh, @anuraaga, @yehonatanz, @arthurfiorette, @elithrar, @tockn, @Kuhave, @obiwac for helping!
Open source →
5.13.0-integration-help-promo.322 Apr 2024pre-release
Nothing published for this version
5.13.0-integration-help-promo.222 Apr 2024pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Highlights

omit fields from Prisma Client queries (Preview)

Fixes and improvements

Prisma Migrate

Prisma Client

Credits

`omit` fields from Prisma Client queries (Preview)