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

20202026

Releases

6.5.0-dev.421 Mar 2025pre-release
Nothing published for this version
6.5.0-dev.4128 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.4028 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3928 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3828 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3728 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3628 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3527 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3427 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3327 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3226 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3126 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.3026 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2926 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2825 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2725 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2625 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2525 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2425 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2325 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2224 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2124 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.2024 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1924 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1824 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1724 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1624 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1524 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1424 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1322 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1221 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1121 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.1021 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.921 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.821 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.721 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.621 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.521 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.421 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.320 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.220 Feb 2025pre-release
Nothing published for this version
6.5.0-dev.119 Feb 2025pre-release
Nothing published for this version
6.4.120 Feb 2025
Release notes
Today, we are issuing the 6.4.1 patch release. It fixes a few issues with the NPS survey and makes it respect the --no-hints CLI flag.

Fixes

Prisma CLI
- https://github.com/prisma/prisma/issues/26364
Open source →
6.4.1-dev.120 Feb 2025pre-release
Nothing published for this version
6.4.018 Feb 2025
Release notes
Today, we are excited to share the 6.4.0 stable release 🎉

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

Highlights

TypeScript-based configuration with prisma.config.ts (Early Access)

In this release, we're introducing an Early Access version of a TypeScript-based configuration file for Prisma ORM: prisma.config.ts.

This file will serve as a central configuration point for Prisma ORM:
```
import path from 'node:path'

export default {
  earlyAccess: true, // required while in Early Access

  schema: {
    kind: 'single', // use 'multi' if you're using the `prismaSchemaFolder` preview feature
    filePath: path.join('custom', 'prisma', 'schema.prisma')
  }
  
})
```
With this file you are able to run any arbitrary code needed to get values required by Prisma ORM, such as database URLs from a secret store or fine-grained control of settings. It needs to live in the current working directory from where you're executing Prisma CLI commands (typically, the root of your project).

Note: If you're using prisma.config.ts, the Prisma CLI will not load environment variables from .env files. If you want to use a .env file with prisma.config.ts, you'll need to load the environment variables manually using the dotenv package (see here).

Learn more about the new prisma.config.ts file in the docs.

Case-insensitive mode in JSON filters

You can now do case-insensitive filtering on JSON data.

Just use the new mode option when filtering using string_contains, string_starts_with or string_ends_with in a JSON object and set it to "insensitive":
```
await prisma.user.findMany({
  where: {
    pets: {
      path: ['favorites', 'catBreed'],
      string_contains: 'Van',
      mode: "insensitive",
    },
  },
});
```
The above query returns all users where the favorites.catBreed value contains "Van" or "van".

Thanks to @lubosmato who implemented this feature 🎉

Improved CockroachDB migration speed

In this release we found some inefficiencies in our migration engine that was impacting CockroachDB migrations. In 6.4.0, CockroachDB migrations should be significantly faster.

Calling all devs: Give us your feedback!

Prisma ORM's community keeps us going. To make sure that we're focused on what the community needs, we would like to get your feedback via our online feedback form.

Credits

Huge thanks to @lubosmato, @notomo, @Mayureshd-18, @mydea, @omar-dulaimi and @Hazmi35 for helping out with this release!
Open source →
6.4.0-integration-studio-release-version-05090.118 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-push-rxrkoptlzzms.118 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-fix-config-types.318 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-fix-config-types.218 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-fix-config-types.118 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-fix-accelerate-engine-crash-policy.16 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-7-chore-rename-error-kinds-6ade8eb07ce6ee78cd81baad86b254c457300340.23 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-7-chore-rename-error-kinds-6ade8eb07ce6ee78cd81baad86b254c457300340.13 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-5-chore-rename-error-kinds-6be5d359e3dccb7e8b623fad8d36236047e2936f.131 Jan 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-28-integration-sql-nested-transactions-fba3682185fb5027c810216c59359fba8e1cdbb3.217 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-28-integration-sql-nested-transactions-fba3682185fb5027c810216c59359fba8e1cdbb3.117 Feb 2025pre-release
Nothing published for this version
6.4.0-integration-engines-6-4-0-1-fix-cockroachdb-slow-migrations-workaround-7f2ebe4987f4376912fd7d7e638148a3943dbc78.129 Jan 2025pre-release
Nothing published for this version
6.4.0-dev.6418 Feb 2025pre-release
Nothing published for this version
6.4.0-dev.6318 Feb 2025pre-release
Nothing published for this version
6.4.0-dev.6218 Feb 2025pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Fixes

Prisma CLI

Highlights

TypeScript-based configuration with prisma.config.ts (Early Access)

Case-insensitive mode in JSON filters

Improved CockroachDB migration speed

Calling all devs: Give us your feedback!

Credits

TypeScript-based configuration with `prisma.config.ts` (Early Access)