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 3 days ago
25 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
10652 releases · first in 2020
Release timeline
10652 releases since 2020Releases
- 6.1.0-dev.52 Dec 2024pre-release
Nothing published for this version
- 6.1.0-dev.41 Dec 2024pre-release
Nothing published for this version
- 6.1.0-dev.330 Nov 2024pre-release
Nothing published for this version
- 6.1.0-dev.230 Nov 2024pre-release
Nothing published for this version
- 6.1.0-dev.130 Nov 2024pre-release
Nothing published for this version
- 6.0.12 Dec 2024
Release notes
Open source →Today we are releasing the
6.0.1patch release to address an issue with using Prisma Client generated in a custom output path with Next.js.Changes
- 6.0.1-dev.12 Dec 2024pre-release
Nothing published for this version
- 6.0.028 Nov 2024
Release notes
Open source →We’re excited to share the Prisma ORM v6 release today 🎉
As this is a major release, it includes a few breaking changes that may affect your application. Before upgrading, we recommend that you check out our upgrade guide to understand the impact on your application.
If you want to have an overview of what we accomplished since v5, check out our announcement blog post: Prisma 6: Better Performance, More Flexibility & Type-Safe SQL.
🌟 Help us spread the word about Prisma by starring the repo ☝️ or posting on X about the release.
Breaking changes
⚠️ This section contains a list of breaking changes. If you upgrade your application to Prisma ORM v6 without addressing these, your application is going to break! For detailed upgrade instructions, check out the upgrade guide. ⚠️
Minimum supported Node.js versions
The new minimum supported Node.js versions for Prisma ORM v6 are:
- for Node.js 18 the minimum supported version is 18.18.0
- for Node.js 20 the minimum supported version is 20.9.0
- for Node.js 22 the minimum supported version is 22.11.0
There is no official support for Node.js <18.18.0, 19, 21, 23.
Minimum supported TypeScript version
The new minimum supported TypeScript version for Prisma ORM v6 is: 5.1.0.
Schema change for implicit m-n relations on PostgreSQL
If you're using PostgreSQL and are defining implicit many-to-many relations in your Prisma schema, Prisma ORM maintains the relation table for you under the hood. This relation table has
AandBcolumns to represent the tables of the models that are part of this relation.Previous versions of Prisma ORM used to create a unique index on these two columns. In Prisma v6, this unique index is changing to a primary key in order to simplify for the default replica identity behaviour.
If you're defining implicit m-n relations in your Prisma schema, the next migration you'll create will contain
ALTER TABLEstatements for all the relation tables that belong to these relations.Full-text search on PostgreSQL
The
fullTextSearchPreview feature is promoted to General Availability only for MySQL. This means that if you're using PostgreSQL and currently make use of this Preview feature, you now need to use the newfullTextSearchPostgresPreview feature.Usage of
BufferPrisma v6 replaces the usage of
BufferwithUint8Arrayto represent fields of typeBytes. Make sure to replace all your occurrences of theBuffertype with the newUint8Array.Removed
NotFoundErrorIn Prisma v6, we removed the
NotFoundErrorin favor ofPrismaClientKnownRequestErrorwith error codeP2025infindUniqueOrThrow()andfindFirstOrThrow(). If you've relied on catchingNotFoundErrorinstances in your code, you need to adjust the code accordingly.New keywords that can't be used as model names:
async,await,usingWith this release, you can't use
async,awaitandusingas model names any more.
⚠️ For detailed upgrade instructions, check out the upgrade guide. ⚠️
Preview features promoted to General Availability
In this release, we are promoting a number of Preview features to General Availability.
fullTextIndexIf you use the full-text index feature in your app, you can now remove
fullTextIndexfrom thepreviewFeaturesin your Prisma schema:generator client { provider = "prisma-client-js" - previewFeatures = ["fullTextIndex"] }fullTextSearchIf you use the full-text search feature with MySQL in your app, you can now remove
fullTextSearchfrom thepreviewFeaturesin your Prisma schema:generator client { provider = "prisma-client-js" - previewFeatures = ["fullTextSearch"] }If you are using it with PostgreSQL, you need to update the name of the feature flag to
fullTextSearchPostgres:generator client { provider = "prisma-client-js" - previewFeatures = ["fullTextSearch"] + previewFeatures = ["fullTextSearchPostgres"] }New features
We are also releasing new features with this release:
- cuid2() support
- Include unused enum definitions in
prisma generate's output - Improved compatibility with Deno 2
Company news
🚀 Prisma Postgres is free during Early Access
In case you missed it: We recently launched Prisma Postgres, a serverless database with zero cold starts, a generous free tier, connection pooling, real-time events, and a lot more! It’s entirely free during the Early Access phase, try it now!
✨ Let us know what you think of Prisma ORM
We're always trying to improve! If you've recently used Prisma ORM, we'd appreciate hearing your thoughts about your experience via this 2min survey.
- 5.23.0-integration-otel-peer-deps.17 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-8-integration-include-field-native-type-data-to-dmmf-f616ccc38c3d791e452ebd52f830a7fad0161650.215 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-8-integration-include-field-native-type-data-to-dmmf-f616ccc38c3d791e452ebd52f830a7fad0161650.115 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-6-integration-enum-mapped-values-cc1d5ee45ff9a116165edca8ab47690e5133baf0.214 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-6-integration-enum-mapped-values-cc1d5ee45ff9a116165edca8ab47690e5133baf0.114 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-26-integration-enum-mapped-values-caa24ef936c3d4510b1fec91d88f94a5d6df0cdc.228 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-26-integration-enum-mapped-values-caa24ef936c3d4510b1fec91d88f94a5d6df0cdc.128 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-24-integration-enum-mapped-values-3481347682d702270b0c3c9e3d557e210154a15a.228 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-24-integration-enum-mapped-values-3481347682d702270b0c3c9e3d557e210154a15a.128 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-23-implicit-m2m-id-6a7820e9be60378b1fa68bf5922e06de81baca34.128 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-22-integration-enum-mapped-values-89f945da93fef3a624a4ebfff5ef973e7f2fc01d.227 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-22-integration-enum-mapped-values-89f945da93fef3a624a4ebfff5ef973e7f2fc01d.127 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-20-integration-enum-mapped-values-5951ba0974e3e23a86bf5e9ff7eb9c5dd7519e23.227 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-20-integration-enum-mapped-values-5951ba0974e3e23a86bf5e9ff7eb9c5dd7519e23.127 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-2-add-schema-to-dmmf-6b2b29378ec9ecb0902a9ae4fa6302e9b16baf18.17 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-19-integration-enum-mapped-values-3a4cdab80bbc3114eec7f32b9d272b3d033acfd1.227 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-19-integration-enum-mapped-values-3a4cdab80bbc3114eec7f32b9d272b3d033acfd1.127 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-17-implicit-m2m-id-701e194f51e12fda9d113117e2c8300f554160d3.127 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-16-implicit-m2m-id-42e66f7165718331029b4c93e767c0cc7241884d.126 Nov 2024pre-release
Nothing published for this version
- 5.23.0-integration-engines-5-23-0-1-add-schema-to-dmmf-69b6e9d3bee92eeb76fcfa1ffb0a5b65cd7027b4.17 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.3328 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.3228 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.3128 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.3028 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2927 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2827 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2727 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2627 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2527 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2427 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2327 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2227 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2127 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.2027 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1927 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1826 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1725 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1622 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1521 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1421 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1321 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1220 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1119 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.1015 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.915 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.815 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.713 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.613 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.512 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.411 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.36 Nov 2024pre-release
Nothing published for this version
- 5.23.0-dev.26 Nov 2024pre-release
Nothing published for this version