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

3.9.210 Feb 2022
Release notes
Today, we are issuing the 3.9.2 patch release.

Fixes
Open source →
3.9.2-dev.210 Feb 2022pre-release
Nothing published for this version
3.9.2-dev.19 Feb 2022pre-release
Nothing published for this version
3.9.12 Feb 2022
Release notes
Today, we are issuing the 3.9.1 patch release.

Fixes
- prisma db pull doesn't read .env file and errors with Environment variable not found: DATABASE_URL
- Prisma Client: .count does not work with where
Open source →
3.9.1-dev.32 Feb 2022pre-release
Nothing published for this version
3.9.1-dev.22 Feb 2022pre-release
Nothing published for this version
3.9.1-dev.12 Feb 2022pre-release
Nothing published for this version
3.9.01 Feb 2022
Release notes
Today, we are excited to share the 3.9.0 stable release 🎉

🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟

Major improvements and new features

Prisma Migrate improvements to troubleshoot migrations

Last year, we released Prisma Migrate for General Availability. Since then, we've gotten feedback from you to understand the challenges you experience building, testing, and deploying migrations.

We're thrilled to announce that we're introducing new CLI commands to improve the experience troubleshooting migrations:
- prisma migrate diff
- prisma db execute
The prisma migrate diff command creates a diff of your database schema, Prisma schema file, or the migration history. All you would have to do is feed the command with a schema from state and a schema to state to get an SQL script or human-readable diff in return.

As a companion to the prisma migrate diff, we also built prisma db execute to execute SQL scripts against a database. You can pipe the output from prisma migrate diff directly to prisma db execute.

Both commands are non-interactive, so it's possible to build many new workflows such as forward and backward migrations with some automation tooling.

Both commands are in Preview, and we are looking forward to learning how they work for you and how we could make them better.

You can learn about them here and give us feedback on the issue.

Preview support for CockroachDB

We are excited to announce Preview support for CockroachDB :tada:

CockroachDB is a distributed SQL database that shines in its ability to scale efficiently while maintaining developer agility and reducing operational overhead.

CockroachDB support in Prisma is the product of collaboration with the Cockroach Labs team, and with this release you can use Prisma in existing CockroachDB projects with introspection.
- Learn more in the release blog post
- Try it out with the getting started guide
- Share your feedback
- Join us this Thursday for What's new in Prisma 3.9.0 where Aydrian Howard from Cockroach Labs will be joining us to discuss CockroachDB and give a demo.
Raw query support for MongoDB

Prisma version 3.9.0 introduces raw queries to the MongoDB (Preview) connector. Raw queries help writing queries that Prisma doesn't support yet, such as:
```
// To find zero or more documents matching a filter
const result = await prisma.user.findRaw({
  filter: { age: { $gt: 25 } },
  options: { projection: { _id: false } },
})

// To perform aggregation operations on a collection
await prisma.user.aggregateRaw({
  pipeline: [
    { $match: { status: 'registered' } },
    { $group: { _id: '$country', total: { $sum: 1 } } },
  ],
})

// To run a command against the database
await prisma.$runCommandRaw({
  aggregate: 'User',
  pipeline: [
    { $match: { name: 'Bob' } },
    { $project: { email: true, _id: false } },
  ],
  explain: false,
})
```
The raw query API for MongoDB differs from Prisma's $queryRaw SQL API to handle some low-level differences between databases to give you a better API and developer experience.

Learn more about Prisma's new raw query API and how you can use it in our documentation.

Concurrency issues with Interactive Transactions

In 3.9.0, we fixed a number of issues around timeouts and rollbacks when there were concurrent reads and writes.

This is part of the Interactive Transactions preview release, so you'll need to enable the interactiveTransactions preview feature to enable this feature.

If you experienced timeouts or your interactive transactions weren't working quite as you expected, now's the time to upgrade and give it another go!

Learn more about Interactive Transactions in our documentation.

Fixes and improvements

Prisma Client
Prisma Migrate
Prisma Studio
- Can't view any models: ENOENT error no such file or directory when the Prisma schema filename is not schema.prisma
Prisma Engines
- Update MongoDB to 2.1.0 (latest)
Credits

Huge thanks to @dusandz, @hyochan, @cesconix, @benkroeger, @YassinEldeeb, @chenkie, @Akxe, @safareli for helping!

Change in release cadence

We're making a slight change to our release cadence to every 3 weeks from every 2 weeks.

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

Learn about the latest release and other news from the Prisma community by joining us for another "What's new in Prisma" livestream.

The stream takes place on YouTube on Thursday, February 03 at 5 pm Berlin | 8 am San Francisco.
Open source →
3.9.0-integration-migrate-diff.227 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-migrate-diff.127 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-feat-tracing.426 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-feat-tracing.326 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-feat-tracing.214 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-feat-tracing.114 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.1027 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.926 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.826 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.726 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.626 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.525 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.425 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.325 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.225 Jan 2022pre-release
Nothing published for this version
3.9.0-integration-cli-db-execute.125 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.671 Feb 2022pre-release
Nothing published for this version
3.9.0-dev.661 Feb 2022pre-release
Nothing published for this version
3.9.0-dev.651 Feb 2022pre-release
Nothing published for this version
3.9.0-dev.641 Feb 2022pre-release
Nothing published for this version
3.9.0-dev.6331 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.6231 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.6131 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.6031 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5931 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5831 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5731 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5631 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5531 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5431 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5328 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5228 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5128 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.5027 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4927 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4827 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4726 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4626 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4526 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4426 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4326 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4226 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4126 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.4026 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3924 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3824 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3724 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3624 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3524 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3424 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3321 Jan 2022pre-release
Nothing published for this version
3.9.0-dev.3221 Jan 2022pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Fixes

Fixes

Major improvements and new features

Prisma Migrate improvements to troubleshoot migrations

Preview support for CockroachDB

Raw query support for MongoDB

Concurrency issues with Interactive Transactions

Fixes and improvements

Prisma Client

Prisma Migrate

Prisma Studio

Prisma Engines

Credits

Change in release cadence

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