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 5 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

3.11.0-dev.409 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.399 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.389 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.379 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.364 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.353 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.343 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.333 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.323 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.313 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.302 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.292 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.282 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.272 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.262 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.252 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.242 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.232 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.222 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.211 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.201 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.191 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.181 Mar 2022pre-release
Nothing published for this version
3.11.0-dev.1728 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1625 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1525 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1425 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1325 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1225 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1125 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.1024 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.924 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.824 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.723 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.623 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.523 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.423 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.323 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.223 Feb 2022pre-release
Nothing published for this version
3.11.0-dev.122 Feb 2022pre-release
Nothing published for this version
3.10.022 Feb 2022
Release notes
Today, we are excited to share the 3.10.0 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟

Major improvements and new features

We are working towards a stable release of MongoDB and are shipping lots of improvements. All the new features and changes in this release therefore only apply to the MongoDB connector. Take a closer look if you are using the Preview of MongoDB as some of the changes are breaking.

Embedded documents support is now in Preview

We're super excited to announce that Prisma version 3.10.0 supports reading and modifying embedded documents. Embedded documents will provide access to a new type keyword in your Prisma schema that you can use to define composite types.
```
datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["mongoDb"]
}

model Product {
  id     String  @id @default(auto()) @map("_id") @db.ObjectId
  name   String
  photos Photo[]
}

type Photo {
  height Int
  width  Int
  url    String
}
```
Given the schema above, you can now read and write to the embedded photos array:
```
// Create a new product with an embedded list of photos
const product = await prisma.product.create({
  data: {
    name: "Forest Runners",
    // Create an embedded list of photos in the product
    photos: [
      { height: 100, width: 200, url: "1.jpg" },
      { height: 300, width: 400, url: "2.jpg" },
    ],
  },
})
```
Best of all, the query is entirely type-safe! This scratches the surface of what's possible with embedded documents. You can read further in our documentation.

If you run into anything, feel free to open an issue, and we’ll give you a hand!

Introspection of embedded documents is now enabled by default

We added Preview support for Introspection of embedded documents in version 3.4.0 and are now activating it for all users. Running prisma db pull against your MongoDB database will generate type definitions within your Prisma schema.

When introspecting your database, you can switch off the depth with --composite-type-depth=0, or limit it with, for example, --composite-type-depth=2.

Feel free to drop your feedback on the feature on GitHub.

@default(dbgenerated()) is now replaced with @default(auto())

The original purpose of dbgenerated is to support SQL expressions Prisma doesn’t understand yet. However, MongoDB doesn’t have a concept of default value expressions like SQL does. We took this opportunity to simplify how we handle the default values in MongoDB:
```
model Post {
-  id String @id @default(dbgenerated()) @map("_id") @db.ObjectId
+  id String @id @default(auto()) @map("_id") @db.ObjectId
}
```
Many-to-Many relations now require a references argument

Prisma version 3.10.0 now enforces all arguments in a MongoDB many-to-many relation. This means a @relation attribute must define fields and references arguments on both sides.

The fields argument must point to a scalar field in the same model, and this scalar field must be an array. The references arguments must point to a scalar field in the opposite model, and it must be a singular type of the same base type as the referencing array on the other side.
```
model Post {
  id           String     @id @map("_id") @default(auto()) @db.ObjectId
  category_ids String[]   @db.ObjectId
- categories   Category[] @relation(fields: [category_ids])
+ categories   Category[] @relation(fields: [category_ids], references: [id])
}
    
model Category {
  id       String   @id @map("_id") @default(auto()) @db.ObjectId
  post_ids String[] @db.ObjectId
- posts    Post[]   @relation(fields: [post_ids])
+ posts    Post[]   @relation(fields: [post_ids], references: [id])
}
```
@db.Array(ObjectId) is now updated to @db.ObjectId

We've adjusted the Prisma schema format for scalar lists with native types (like lists of Object IDs). This will likely affect those with many-to-many relationships in MongoDB. We made this change to align MongoDB with our existing SQL databases better:
```
model Post {
  id          String     @id @default(auto()) @map("_id") @db.ObjectId
- categoryIDs String[]   @db.Array(ObjectId)
+ categoryIDs String[]   @db.ObjectId
  categories  Category[] @relation(fields: [categoryIDs], references: [id])
}

model Category {
  id      String   @id @default(auto()) @map("_id") @db.ObjectId
- postIDs String[] @db.Array(ObjectId)
+ postIDs String[] @db.ObjectId
  posts   Post[]   @relation(fields: [postIDs], references: [id])
}
```
Fixes and improvements

Prisma Migrate
Prisma Client
Credits

Huge thanks to @andyrichardson, @xnerhu, @Josh-a-e, @dusandz, @hyochan, @cesconix, @benkroeger, @YassinEldeeb, @chenkie for helping!

📺 Join us for another "What's new in Prisma" livestream

Learn about the latest release and other news from the Prisma community by joining us for another "What's new in Prisma" livestream.

The stream takes place on YouTube on Thursday, February 03 at 5 pm Berlin | 8 am San Francisco.
Open source →
3.10.0-integration-path-generation-fix.118 Feb 2022pre-release
Nothing published for this version
3.10.0-integration-fix-extraneous-esm-files.28 Feb 2022pre-release
Nothing published for this version
3.10.0-integration-fix-extraneous-esm-files.18 Feb 2022pre-release
Nothing published for this version
3.10.0-integration-fix-10512.116 Feb 2022pre-release
Nothing published for this version
3.10.0-integration-composites.121 Feb 2022pre-release
Nothing published for this version
3.10.0-integration-8989-fixes-memory-leak.111 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.7322 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.7222 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.7121 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.7021 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6921 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6821 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6721 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6618 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6518 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6418 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6318 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6218 Feb 2022pre-release
Nothing published for this version
3.10.0-dev.6118 Feb 2022pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Major improvements and new features

Embedded documents support is now in Preview

Introspection of embedded documents is now enabled by default

`@default(dbgenerated())` is now replaced with `@default(auto())`

Many-to-Many relations now require a `references` argument

`@db.Array(ObjectId)` is now updated to `@db.ObjectId`

Fixes and improvements

Prisma Migrate

Prisma Client

Credits

📺 Join us for another "What's new in Prisma" livestream

@prisma/client

Release timeline

Releases

Major improvements and new features

Embedded documents support is now in Preview

Introspection of embedded documents is now enabled by default

@default(dbgenerated()) is now replaced with @default(auto())

Many-to-Many relations now require a references argument

@db.Array(ObjectId) is now updated to @db.ObjectId

Fixes and improvements

Prisma Migrate

Prisma Client

Credits

📺 Join us for another "What's new in Prisma" livestream

`@default(dbgenerated())` is now replaced with `@default(auto())`

Many-to-Many relations now require a `references` argument

`@db.Array(ObjectId)` is now updated to `@db.ObjectId`