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

2020202120222023202420252026

20202026

One column per quarter.

Releases

4.11.0-dev.1213 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.1113 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.1013 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.910 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.810 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.79 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.69 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.59 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.49 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.39 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.29 Feb 2023pre-release
Nothing published for this version
4.11.0-dev.18 Feb 2023pre-release
Nothing published for this version
4.10.19 Feb 2023
Release notes
Today, we are issuing the 4.10.1 patch release.

Fixes in Prisma Client
- Prisma Client falsely validates directUrl env var value, leading to validation error (Affects PDP/Data Proxy and normal Engine)
- 4.10.0, unexpected: errorCode: 'P1012' PrismaClientInitializationError: error: Environment variable not found: DATABASE_URL.
Open source →
4.10.1-dev.69 Feb 2023pre-release
Nothing published for this version
4.10.1-dev.59 Feb 2023pre-release
Nothing published for this version
4.10.1-dev.49 Feb 2023pre-release
Nothing published for this version
4.10.1-dev.39 Feb 2023pre-release
Nothing published for this version
4.10.1-dev.29 Feb 2023pre-release
Nothing published for this version
4.10.1-dev.19 Feb 2023pre-release
Nothing published for this version
4.10.07 Feb 2023
Release notes
🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟

Highlights

Improved CLI support for connection poolers

When working with connection poolers such as the Prisma Data Proxy, Accelerate or pgBouncer, it is necessary to use a different URL to connect to the database when using Prisma Client and Prisma Migrate.

We're introducing a new datasource property directUrl to improve this. When the directUrl property is present, the Prisma CLI will use it to connect to the database for tasks such as introspection and migrations.
```
# .env
# Connection to Prisma Data Proxy. Used by Prisma Client.
DATABASE_URL="prisma://__HOST__/?api_key=__KEY__"
# Connection to the database. Used for migrations and introspection.
DIRECT_URL="postgresql://__USER__:__PASSWORD__@__HOST__:__PORT__/__DATABASE__"
```
```
// ./prisma/schema.prisma
generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider  = "postgresql"
  url       = env("DATABASE_URL")
  directUrl = env("DIRECT_URL")
}
```
To learn more, refer to our documentation.

Introspection support for PostgreSQL views

We introduced initial support for database views in 4.9.0 with the addition of the view keyword. This release introduces introspection support for PostgreSQL views. You can run prisma db pull against your database to populate your Prisma schema with your views.

To learn more, refer to our documentation on views introspection. Try it out and let us know your thoughts in this GitHub issue.

Improved introspection for unsupported database functionality & partitioned tables

Currently, the Prisma Schema Language(PSL) does not cover the full feature sets of different database providers. For the unsupported database functionality, Prisma provides offers escape hatches like raw queries or manual editing of the migration files.

While we work on adding support for missing database functionality, e.g. database views, some of it is not fully-supported and the escape hatches fail. Objects that use unsupported properties might not be caught during introspection and raw queries might not work. Re-introspection may sometimes remove the information from the schema file and the generated migrations may be invalid or re-generate the same SQL repeatedly.

We're therefore fixing the defects and supporting the unsupported database functionalities Prisma currently doesn't support. We created a list of these features in this GitHub issue we would like to improve.

This release improves introspection support for partitioned tables in PostgreSQL and MySQL. Previously, Prisma would pick up the partitions as models and miss the actual main table. Prisma will now pick up the main table as a model, not the partitions.

If you're already using partitioned tables in your database, you can use prisma db pull to update your Prisma schema. If you're already using Prisma and want to partition a table in your database, you can:
1. Create a draft migration using prisma migrate dev --create-only
2. Update the draft migration with the SQL to partition the tables
3. Re-run prisma migrate dev to apply the draft migration to your database
Try it out and let us know what you think. If you run into an issue, feel free to create a bug report.

Smaller engine size used in Prisma CLI

In 4.8.0, we decreased the size of the engines by ~50%, which significantly impacted Prisma Client, especially in serverless environments.

In this release, we've reduced the size of Prisma CLI by removing the Introspection and Formatter engines. The introspection functionality is now served by the Migration Engine. A cross-platform Wasm module has entirely replaced the Formatter Engine. This reduces the overall installation size for Prisma CLI.

Fixes and improvements

Prisma Client
Prisma
Language tools (e.g. VS Code)
- Add VS Code quick fix / code action to phase out referentialIntegrity in favor of relationMode
- Auto completion of directUrl
Credits

Huge thanks to @rintaun, @ivan, @Mini256, @yukukotani, @sandrewTx08 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, February 9 at 5 pm Berlin | 8 am San Francisco.
Open source →
4.10.0-integration-unblock-ci.130 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-remove-introspection-engine.124 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-remove-install-now-hack.124 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-musl-not-amd64-only-fail-when-using-official-prisma-engines.118 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.93 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.83 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.73 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.62 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.52 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.41 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.31 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.231 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-musl-arm.131 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-libssl-avoid-0-x.25 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-libssl-avoid-0-x.13 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-grep-ssl-to-libssl.118 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-fix-client-extensions-error-wrapping.331 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-fix-client-extensions-error-wrapping.231 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-fix-client-extensions-error-wrapping.130 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-fix-client-data-proxy-custom-output.27 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-fix-client-data-proxy-custom-output.17 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.830 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.730 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.628 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.528 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.428 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.328 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.217 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-feat-pce-custom-fetch.117 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-83-integration-evie-partition-tables-fix-0c08c4bf9d6ec24df1142c87016ffac6ca85b118.17 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-81-integration-direct-url-fix-1df394d740069ed92a9c7ee705e09b3c44289b5a.16 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-80-integration-direct-url-fix-c46ccd25d43ebe3a797d38ff47c6a3cc6913ef79.16 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-79-integration-evie-direct-url-fix-1df394d740069ed92a9c7ee705e09b3c44289b5a.16 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-78-integration-evie-direct-url-fix-6ae8d35f7be300e6622461bd3a74c7fc06132321.16 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-70-integration-musl-arm-b8c9e5b20cd0f9e19d03fc3cf6964ba078e4352e.12 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-66-no-locking-adf1bb52d8051fb218120102454d5f308d41b46a.11 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-64-integration-get-dmmf-wasm-handle-errors-3d4278979c9faf9b522074a40a7988576e3018da.11 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-63-integration-get-dmmf-wasm-handle-errors-5c66df116302959d5852ec3e41908703d8273e61.11 Feb 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-62-integration-get-dmmf-wasm-handle-errors-b1cab025df75ffc6b890e90611c3a9b9c1f0984c.131 Jan 2023pre-release
Nothing published for this version
4.10.0-integration-engines-4-10-0-60-integration-musl-arm-bbb684e8f722179952f61f00103009d8815cdb1f.131 Jan 2023pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Fixes in Prisma Client

Highlights

Improved CLI support for connection poolers

Introspection support for PostgreSQL views

Improved introspection for unsupported database functionality & partitioned tables

Smaller engine size used in Prisma CLI

Fixes and improvements

Prisma Client

Prisma

Language tools (e.g. VS Code)

Credits

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