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 4 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
- 4.14.0-dev.4630 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4530 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4430 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4330 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4230 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4128 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.4028 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3928 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3828 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3728 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3628 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3528 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3428 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3327 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3227 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3127 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.3027 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2927 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2827 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2727 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2627 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2426 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2326 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2226 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2125 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.2025 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1925 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1825 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1725 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1625 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1525 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1424 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1324 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1224 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1124 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.1021 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.921 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.820 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.720 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.619 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.519 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.419 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.318 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.218 Apr 2023pre-release
Nothing published for this version
- 4.14.0-dev.118 Apr 2023pre-release
Nothing published for this version
- 4.13.018 Apr 2023
Release notes
Open source โ๐ Help us spread the word about Prisma by starring the repo or tweeting about the release. ๐
Highlights
Introspection warnings for unsupported features
The Prisma Schema Language (PSL) currently doesn't support all database features and functionality of our target databases. The PSL is an abstraction over SQL and will keep evolving to address gaps in our database feature matrix.
Before this release,
prisma db pulldid not pick up the unsupported features in a database. It was easy to lose them when runningprisma migrate devbased on an existing Prisma schema if not included in a migration file using custom migrations.To avoid this, we added introspection warnings that surface the existence of these features in your database and link to our documentation on how to manually work around the Prisma Schema with unsupported database features.
In this release, we added introspection warnings for the following features:
- Partitioned tables
- PostgreSQL Row Level Security
- Index sort order,
NULLS FIRST/NULLS LAST - CockroachDB row-level TTL
- Comments
- PostgreSQL deferred constraints
Prisma CLI will output warnings on introspection (
prisma db pull) and add comments to your Prisma schema. In the coming releases, we will expand this to many more features labeled withtopic: database-functionalityon GitHub.Improved support for Netlify and Vercel build process
Netlify and Vercel cache project dependencies during the build process and reuse that cache until dependencies change. While this helps speed up the build process, any
postinstallscripts of these dependencies will not be executed.Prisma uses a
postinstallscript in its package to automatically trigger the customized generation of Prisma Client for your Prisma Schema. When a dependency cache is used, that generation process is not triggered, and an outdated Prisma Client may be used in your application.When you update your Prisma Schema but not your dependencies, Prisma Client will not be generated for the new schema. For example, columns you added recently to one of your models will not be present in the Prisma Client API - causing errors.
This problem can be avoided by:
- Adding a custom
postinstallscript in yourpackage.jsonfile - Manually adding a
prisma generatestep to the โBuildโ scripts of Vercel and Netlify.
We now added detection of this scenario and will prevent a build without an additional
prisma generate. This will ensure you're aware of the problem early and get guidance on how to fix this problem. You can read more on how to do this in our docs โ Vercel caching troubleshooting, Netlify caching troubleshooting.Better support for pnpm as a package manager
Before this release, Prisma only used npm scripts which would lead to undesirable behavior for a project using a different package manager such as pnpm and yarn. This release improves the detection of the package managers in your project by using
ni. If you're still running into this problem, let us know by creating a GitHub issue.Segmentation fault and TLS connection error fix
In this release, we've fixed a TLS connection error segmentation fault. This mostly affected users running on Node.js 17 or later with OpenSSL 1.1 when using TLS to connect to their database.
JSON protocol Preview feature feedback
We have fixed multiple bugs for the
jsonProtocolPreview feature and are close to making it Generally Available. We are still looking for feedback about its usage to ensure it is ready and works as expected for everyone.We would appreciate it if you would try it out, help us polish the feature, and move it to General Availability. Testing it requires little effort. You can test it using the following steps:
- Enabling the
jsonProtocolPreview feature in your Prisma schema - Re-generating Prisma Client
- Running your application or tests to make sure everything works
We encourage you to leave your feedback in this GitHub issue or create a bug report if your run into any issues.
Fixes and improvements
Prisma Client
prisma generatefails when using pnpm workspaces because it tries to install prisma dependencies with npm or yarn- Netlify deploy does not pick up changes to schema file
- Vercel: Schema only change does not invalidate build cache
- Serverless deployments: Just making a schema level change to a repository does not invalidate
node_modulescache that contains generated Client - pnpm: Can not
prisma generatewhen@prisma/clientis not installed in project - Segmentation fault crash when using prisma client when using PostgreSQL
- Docker with
pnpm installhangs on@prisma/clientpostinstall - Automatic installation of missing dependencies isn't compatible with pnpm
- Prisma generate throws dependency error karma-chai
- Postinstall script fails with PNPM workspaces due to npm ERR! Cannot read properties of null (reading 'matches')
- Debian 11 Node 19.3.0 segmentation fault
- Prisma client segfault on Ubuntu 22.04
- Segmentation Fault in Postgres
- Using Prisma with pnpm results in inability to call database related commands
- Prisma Connect Causes NodeJS to Close With Exit Code 0
- 99056 segmentation fault (core dumped) node --require esbuild-register prisma/seed.ts
- JSON protocol: sibling composites of the same type are rejected
Prisma Migrate
- prisma db pull adds redundant comments: "This table is a partition table ..."
- Render warning code 30 in cli (PG RLS)
Language tools (e.g. VS Code)
Credits
Huge thanks to @KhooHaoYit, @rintaun, @maxmartynov, @haneenmahd for helping!
๐บ Join us for another "What's new in Prisma" live stream
Learn about the latest release and other news from the Prisma community by joining us for another "What's new in Prisma" live stream.
The stream takes place on YouTube on Thursday, April 20 at 5 pm Berlin | 8 am San Francisco.
- 4.13.0-integration-sync-loading.13 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.1014 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.914 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.814 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.713 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.65 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.55 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.44 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.34 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.23 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-rtld-deepbind.129 Mar 2023pre-release
Nothing published for this version
- 4.13.0-integration-opt-openssl-search.35 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-opt-openssl-search.25 Apr 2023pre-release
Nothing published for this version
- 4.13.0-integration-opt-openssl-search.15 Apr 2023pre-release
Nothing published for this version