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 2020Releases
- 5.16.0-dev.4918 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4818 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4718 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4618 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4517 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4417 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4317 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4217 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4117 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.4014 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3914 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3814 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3714 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3613 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3512 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3412 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3312 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3212 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3112 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.3012 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2912 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2812 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2711 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2611 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2510 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2410 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2310 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2210 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2110 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.2010 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.1910 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.1810 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.1710 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.167 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.157 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.147 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.136 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.126 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.116 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.95 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.85 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.75 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.65 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.55 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.44 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.34 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.24 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.14 Jun 2024pre-release
Nothing published for this version
- 5.15.118 Jun 2024
Release notes
Open source →Today, we are issuing the
5.15.1patch release.Fixes in Prisma Client
- internal error: entered unreachable code
- Got error 'internal error: entered unreachable code' when trying to perform an upsert.
- Prisma Client errors on SQLite with internal error: entered unreachable code when running 2 concurrent upsert
ConnectionError(Timed out during query execution.)during seeding- SQLite timeouts after upgrade from prisma 2 to prisma 4
ConnectionError(Timed out during query execution.)error when usingPromise.allfor SQLite- Improve the error when SQLite database file is locked
- sqlite timeout error multiple queries run one after another
- SQLite times out during query execution when using
Promise.all()/ concurrent - internal error: entered unreachable code
- 5.15.1-dev.117 Jun 2024pre-release
Nothing published for this version
- 5.15.04 Jun 2024
Release notes
Open source →Today, we are excited to share the
5.15.0stable release 🎉🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟
Highlights
Multi-File Prisma Schema support
Prisma ORM 5.15.0 features support for multi-file Prisma Schema in Preview.
This closes a long standing issue and does so in a clean and easy to migrate way.
To get started:
- Enable the
prismaSchemaFolderPreview feature by including it in thepreviewFeaturesfield of yourgenerator.datasource db { provider = "postgresql" url = env("DATABASE_URL") } generator client { provider = "prisma-client-js" previewFeatures = ["prismaSchemaFolder"] } - Create a
schemasubdirectory under yourprismadirectory. - Move your
schema.prismainto this directory.
You are now set up with a multi-file Prisma Schema! Add as many or as few
.prismafiles to the newprisma/schemadirectory.When running commands where a Prisma Schema file is expected to be provided, you can now define a Prisma Schema directory. This includes Prisma CLI commands that use the
--schemaoption as well as defining schema viapackage.jsonOur tooling has also been updated to handle multiple Prisma Schema files. This includes our Visual Studio Code extension and tools like database introspection, which will deposit new models in a
introspected.prismafile. Existing models will be updated in the file they are found.To learn more, please refer to our official documentation and announcement blog post. If you try out
prismaSchemaFolder, please let us know!Interesting Bug Fixes
Fix for PostgreSQL prepared statement caching for raw queries
This release fixes a nasty bug with the caching of prepared statements in raw Prisma Client queries that affected PostgreSQL when you ran the same SQL statement with differently typed paramters. This should not fail any more.
Fix for SQL Server introspection of (deprecated)
CREATE DEFAULTOur Introspection logic crashed on encountering certain multi-line
CREATE DEFAULT, a deprecated way to define defaults in SQL Server. As many SQL Server users are working with established databases, this happened frequently enough that we now explicitly ignore these defaults instead of crashing.Fix for Cloudflare D1’s lower parameter limit
Cloudflare’s D1 has a lower parameter limit than local SQLite, which caused bigger queries to fail. We adapted that limit to the D1 default for
@prisma/adapter-d1, which will avoid such failures.Fix for Cloudflare D1’s different
PRAGMAsupportOur generated migration SQL for SQLite did not always work for Cloudflare D1, because of differences in the supported pragmas. We adapted the SQL to work in both local SQLite and Cloudflare D1.
Fixes and improvements
Prisma Migrate
- Crash on multiline defaults introspection on MSSQL
- Error: [libs\sql-schema-describer\src\mssql.rs:315:30] called
Result::unwrap()on anErrvalue: "Couldn't parse default value:create default [dbo].[member_notification_cancel_flags] as 0\r\n" - Error: [libs\sql-schema-describer\src\mssql.rs:315:30] called
Result::unwrap()on anErrvalue: "Couldn't parse default value:create default d_password as 'D,73'" - Crash introspecting MSSQL database with
DEFAULTs - doing introspection on a SQL Server 2018 DB - for Dynamic GP get the following error.
- Error: [libs\sql-schema-describer\src\mssql.rs:317:30] called
Result::unwrap()on anErrvalue: "Couldn't parse default value:\r\ncreate default D_BIT_OFF\r\nas 0\r\n" - Error: called
Result::unwrap()on anErrvalue: "Couldn't parse default value in SQL Server - db pull errors on SQL Server with
Error: [libs\sql-schema-describer\src\mssql.rs:336:30] calledResult::unwrap()on anErrvalue: "Couldn't parse default value: [...] - Error: [libs\sql-schema-describer\src\mssql.rs:336:30] called
Result::unwrap()on anErrvalue: "Couldn't parse default value:\r\ncreate default [va_nulla] as 0\r\n" - Error when pulling from database
- Foreign key relation results in erroneous second migration
db pullcan't parse script setting default value- Bug: Migrations not compatible with D1
- SQL Server Introspection crashes on multi-line (deprecated) defaults
Prisma Client
- Raw query failed. Code:
22P03. Message:db error: ERROR: incorrect binary data format in bind parameter 1 - Float number on raw query:
incorrect binary data format in bind parameter 1 - Can't use Prisma client in Next.js middleware, even when deploying to Node.js
- Prepared statement caching is data dependent on numeric input parameters (
incorrect binary data format in bind parameter x) - Turso Driver Adapter: Including
_countleads to error - Next.js app build fails when using Prisma with DB driver in Server Action
- Bug: [D1] Error in performIO: Error: D1_ERROR: too many SQL variables
- Remove
warn(prisma-client) This is the 10th instance of Prisma Client being started.warning in Edge (and potentially) other envs) - $executeRawUnsafe:
incorrect binary data format in bind parameter 6 - Bug: Error or bug using Prisma with DriverAdapter with PostgreSQL database Neon
Inconsistent column data: Unexpected conversion failure from Number to BigInterror when using@prisma/adapter-pg- Incompatibility with NextJS app dir, CloudFlare Pages and D1
- Breaking change?
Intswitched to beingInt32for MongoDB
Language tools (e.g. VS Code)
- VS Code extension is showing an advertisement
Generatecodelens fails on Windows- We incorrectly read commented out preview features if they are before the real preview features
Credits
Huge thanks to @pranayat, @yubrot, and @skyzh for helping!
- Enable the
- 5.15.0-integration-static-wasm-worker-loader.223 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-static-wasm-worker-loader.122 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-pr-24186.115 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.83 Jun 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.731 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.522 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.422 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.322 May 2024pre-release
Nothing published for this version
- 5.15.0-integration-fix-sqlite-d1-max-bind-values.222 May 2024pre-release
Nothing published for this version