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
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 2020One column per quarter.
Releases
- 5.4.0-dev.1815 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1715 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1615 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1514 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1414 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1314 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1213 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1113 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.1013 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.913 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.813 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.713 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.613 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.413 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.313 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.213 Sept 2023pre-release
Nothing published for this version
- 5.4.0-dev.113 Sept 2023pre-release
Nothing published for this version
- 5.3.115 Sept 2023
- 5.3.1-dev.114 Sept 2023pre-release
Nothing published for this version
- 5.3.013 Sept 2023
Release notes
Open source →🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟
Highlights
In this sprint, we’ve made bug fixes and overall improvements to Prisma Client. We’ve been working on a few projects that will be announced soon. Stay tuned for the upcoming releases for updates!
Improvements and bug fixes
We made the following changes:
Prisma Client improvements
- Validation for
undefinedvalues in arrays inJsonfields We added runtime validation forundefinedvalues in arrays inJsonfields. Prisma Client will now return an error when an array contains anundefinedvalue. Therefore, we encourage you to add validation that either removes the value or transforms it tonullif you stumble on the runtime validation:// Query await prisma.user.findMany({ where: { // JSON field preferences: [undefined, '"theme": "dark"', null, ] } }) // Example error message on running the query Can not use `undefined` value within array. Use `null` or filter out `undefined` values - Performance improvements for models with many unique fields: This release improves Prisma Client’s memory consumption for models with many
@uniqueconstraints. This was a regression from version 4.10.1, where in some cases, if a model had many unique constraints, Prisma Client would use up a lot of available memory. - Fixed the segmentation fault error that used to occur on ARM64 Linux binary targets
- Metrics Preview feature improvements:
- We updated the counters and gauge properties
- We fixed the bug that caused the
prisma_pool_connections_openmetric to have a negative value in some cases.
Prisma Migrate improvements
- Fixed an introspection bug for MongoDB views. Previously, if a MongoDB database contained a view,
prisma db pullwould throw an error. We resolved this, and views are now ignored. - Added the
PRISMA_SCHEMA_DISABLE_ADVISORY_LOCKenvironment variable that enables you to disable advisory locking.
VS Code extension improvements
- Added support for rendering multi-line comments in tooltips when hovering on a block.
- Improved the auto-completion for composite types in other blocks.
- Added a Code Action that allows you to replace
SetDefaultwithNoActionwhen using MySQL and the default/foreignKeysrelation mode.
Fixes and improvements
Prisma Migrate
- Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING
- MongoDB views should be ignored introspecting the database
- Error in Connector on MongoDB executing listIndex: "system.views"
prisma migrate deploy:MariaDB doesn't yet support 'GET_LOCK in cluster (WSREP_ON=ON)'
Prisma Client
- Remove all special cases for Data Proxy in our tests
- Segmentation fault on ARM64 Linux
- In the metrics feature a gauge & counter are swapped
- The prisma metrics
prisma_pool_connections_openhas a bug where it goes negative - Prisma crashes with GraphQL queries of nested one-to-many relationship
- P1017 Server has closed the connection on linux_arm64
Error: socket hang upon Linux/arm64- Panic in Query Engine with SIGABRT signal (Debian Bookworm, engineType = binary)
- Prisma 5 drops
undefinedfrom Arrays when using Json fields with Postgres - Suspected memory leak in Lambda function after upgrading from 4.10.1
- Error when generating - No unsupported field should reach that path
Language tools (e.g. VS Code)
- Models with multi line comments only show last line in tooltip
- Add VS Code quick fix / code action to replace
SetDefaultwithNoActionwhenprovider = "mysql"andrelationMode = "foreignKeys" | default - Composite Types aren't offered as being auto-completable in other blocks
Credits
Huge thanks to @alencardc, @Oreilles, @christianledgard, @skyzh, @alula, @michaelpoellath, @RobertCraigie, @stephenwade for helping!
- Validation for
- 5.3.0-integration-fix-client-20243.128 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.176 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.165 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.155 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.145 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.131 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.121 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.111 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.101 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.91 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.81 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.71 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.61 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.530 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.430 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.328 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.223 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-js-connectors-in-client.122 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-driver-adapters-in-client.411 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-driver-adapters-in-client.36 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-driver-adapters-in-client.25 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-driver-adapters-in-client.15 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-auto-edge-import.47 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-auto-edge-import.37 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-auto-edge-import.27 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-feat-auto-edge-import.17 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-7-qe-remove-unsafe-log-callback-1eb2a814ca332858858b479ede3d45f80c68d293.125 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-32-integration-json-span-4dbffec2916e7d85fd3f98b0aebe4f56916d8f25.28 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-32-integration-json-span-4dbffec2916e7d85fd3f98b0aebe4f56916d8f25.18 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-24-integration-arm-openssl-main-92c9273a161ecfa87c1e2b27abd570c922b184a6.21 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-24-integration-arm-openssl-main-92c9273a161ecfa87c1e2b27abd570c922b184a6.11 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-engines-5-3-0-23-arm-openssl-86636092afd42d73241c93c2aafe60f131001f52.11 Sept 2023pre-release
Nothing published for this version
- 5.3.0-integration-chore-upgrade-esm-deps.126 Aug 2023pre-release
Nothing published for this version
- 5.3.0-integration-arm-openssl-5-2-0.11 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.5511 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.5411 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.538 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.527 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.517 Sept 2023pre-release
Nothing published for this version
- 5.3.0-dev.507 Sept 2023pre-release
Nothing published for this version