npm · #3659

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

2020202120222023202420252026

Releases

6.11.0-integration-fix-generator-ts-pre-preview.125 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.431 Jul 2025pre-release
Nothing published for this version
6.11.0-dev.421 Jul 2025pre-release
Nothing published for this version
6.11.0-dev.411 Jul 2025pre-release
Nothing published for this version
6.11.0-dev.401 Jul 2025pre-release
Nothing published for this version
6.11.0-dev.3930 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3830 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3730 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3627 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3527 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3427 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3327 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3227 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3127 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.3026 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2926 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2826 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2726 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2626 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2526 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2426 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2325 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2225 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2125 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.2025 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1925 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1825 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1724 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1624 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1523 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1423 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1323 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1221 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1120 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.1020 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.920 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.819 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.719 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.619 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.519 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.419 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.318 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.218 Jun 2025pre-release
Nothing published for this version
6.11.0-dev.118 Jun 2025pre-release
Nothing published for this version
6.10.118 Jun 2025
Release notes
Today, we are issuing a 6.10.1 patch release.

Bug fixes

In Prisma ORM version 6.10.0, we shipped a bug fix for Prisma Migrate that ensured we always gracefully closed PostgreSQL connections by sending the Terminate message and not just abruptly closing the TCP connection. This fix was incomplete because it didn't work on Windows, which is now fixed. We highly recommend upgrading to version 6.10.1 if you are using Windows.

We also recommend upgrading to this version if you are currently using local Prisma Postgres via the prisma dev command with an ORM version older than 6.10.x.

Performance improvements

The queryCompiler preview feature recently introduced a performance regression related to in-memory joins in TypeScript-based query execution (users who use the queryCompiler and the relationJoins preview features together were not affected, unless using relationLoadStrategy: "query"). This has now been fixed, leading to significant performance improvements: in our Query Compiler benchmarks, we are seeing up to 500x performance improvement compared to the previous implementation in the TypeScript-based query executor, or up to 10–20x performance improvement compared to the Rust-based Query Engine.

Other news

Please see the release notes for Prisma ORM 6.10.0 for other recent news and announcements.

Open source →
6.10.1-dev.218 Jun 2025pre-release
Nothing published for this version
6.10.1-dev.118 Jun 2025pre-release
Nothing published for this version
6.10.017 Jun 2025
Release notes
Today, we are excited to share the 6.10.0 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo ☝️ or posting on X about the release.

Highlights

No Rust engines for MS SQL Server & PlanetScale (Preview)

We are in the process of removing the Rust engines from Prisma ORM. If you want to try this, you can configure your generator like this:
```
generator client {
  provider        = "prisma-client-js" // or `prisma-client`
  output          = "../generated/prisma"
  previewFeatures = ["queryCompiler", "driverAdapters"]
}
```
In this release, we are excited to move the queryCompiler (which enables using Prisma ORM without Rust engines) into Preview for MS SQL Server and PlanetScale (via the new @prisma/adapter-mssql and existing @prisma/adapter-planetscale driver adapters).

📚Learn more in the docs.

Manage local Prisma Postgres instances in VS Code

We recently released a database management UI as part of the Prisma VS Code extension to enable visual database management workflows for Prisma Postgres. In this release, we added new functionality to it: You can now manage multiple local Prisma Postgres instances via the same UI. To try it, find the Prisma logo in VS Code’s sidebar and start managing your local Prisma Postgres instances (no Docker required).

📚 Learn more in the docs.

Performance improvements for prisma migrate dev

We improved the prisma migrate dev command by optimizing the interactions with the shadow database. Our measurements show a 2x improvement in speed for some databases!

"Push to Cloud": Easily deploy a local Prisma Postgres instance in VS Code

Local Prisma Postgres instances are perfect for development, but how do you go from local to remote once you’re ready to deploy?

The database management UI in VS Code now has a Push to Cloud button that makes it easy to deploy your local Prisma Postgres so that you can connect to it from your deployed applications.

📚 Learn more in the docs.

Support for shard keys on PlanetScale (Preview)

Sharding is a popular technique to scale up when database load grows. As of this release, Prisma ORM supports sharding on PlanetScale natively via the new @shardKey and @@shardKey attributes in the Prisma schema which you can apply to the fields in your models that should serve as shard keys in your database setup:
```
// Single-column shard key
model User {
  id     String @default(uuid())
  region String @shardKey
}

// Multi-column shard key
model User {
  id         String @default(uuid())
  country    String
  customerId String
  @@shardKey([country, customerId])
}
```
Note that this requires you to set the shardKeys Preview feature flag on your generator definition:
```
generator client {
  provider        = "prisma-client-js" // or `prisma-client`
  output          = "../generated/prisma"
  previewFeatures = ["shardKeys"]
}
```
📚 Learn more in the docs.

Other changes
- We deprecated the pg-worker package. It's not needed any more, you can simply use pg when using Prisma ORM in Cloudflare Workers.
- Entrypoint for new prisma-client generator changed. Learn how this affects imports in the docs.
More news

Local Prisma Postgres now works with any ORM & tool (Early Access)

We recently released direct connections for remote Prisma Postgres so that you can now use it with your favorite ORM or database tool. As of this release, this is also possible for your local Prisma Postgres instances. To try it, run the prisma dev command and use the direct connection string starting with postgres:// in order to connect from any tool.

📚 Learn more in the docs.

Let your favorite AI tool manage Prisma Postgres via remote MCP

We just released a new remote MCP server that helps you manage Prisma Postgres instances! It enables your AI tools to help with these workflows:
- Managing databases and connection strings
- Creating and re-instantiating backups
- Querying databases via plain SQL
- Introspecting database schemas
You can start it using the npx -y mcp-remote https://mcp.prisma.io/mcp command.

📚 Learn more in the docs.
Open source →
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.816 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.713 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.613 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.513 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.413 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.313 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.213 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-fix-orm-1006-fix-subcommands-like-init.112 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-feat-skip-download-in-get-generators-2.14 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-engines-6-10-0-9-push-smusznrwrttt-246c08450a3b0e5cda95f7bf0b62234339c14834.16 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-engines-6-10-0-8-push-smusznrwrttt-a019c72b475a6e71f884e1d99abb283f4c54266a.16 Jun 2025pre-release
Nothing published for this version
6.10.0-integration-engines-6-10-0-37-feat-adapter-mysql2-f08a5631f21ef1d59190236288d46f16dcb851b6.113 Jun 2025pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Bug fixes

Performance improvements

Other news

Highlights

No Rust engines for MS SQL Server & PlanetScale (Preview)

Manage local Prisma Postgres instances in VS Code

Performance improvements for prisma migrate dev

"Push to Cloud": Easily deploy a local Prisma Postgres instance in VS Code

Support for shard keys on PlanetScale (Preview)

Other changes

More news

Local Prisma Postgres now works with any ORM & tool (Early Access)

Let your favorite AI tool manage Prisma Postgres via remote MCP

Performance improvements for `prisma migrate dev`