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.17.0-dev.2410 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.239 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.229 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.219 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.209 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.199 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.185 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.173 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.163 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.153 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.143 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.133 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.123 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.113 Jul 2024pre-release
Nothing published for this version
- 5.17.0-dev.1028 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.928 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.828 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.728 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.628 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.528 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.428 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.227 Jun 2024pre-release
Nothing published for this version
- 5.17.0-dev.126 Jun 2024pre-release
Nothing published for this version
- 5.16.29 Jul 2024
Release notes
Open source →Today, we are issuing the 5.16.2 patch release to fix an issue in Prisma client.
Fix in Prisma Client
- 5.16.2-dev.19 Jul 2024pre-release
Nothing published for this version
- 5.16.127 Jun 2024
Release notes
Open source →Today, we are issuing the 5.16.1 patch release to fix an issue in Prisma client.
Fix in Prisma Client
- 5.16.1-dev.127 Jun 2024pre-release
Nothing published for this version
- 5.16.025 Jun 2024
Release notes
Open source →🌟 Help us spread the word about Prisma by starring the repo or tweeting about the release. 🌟
Highlights
Omit model fields globally
With Prisma ORM 5.16.0 we’re more than happy to announce that we’re expanding the
omitApiPreview feature to also include the ability to omit fields globally.When the Preview feature is enabled, you’re able to define fields to omit when instantiating Prisma Client.
const prisma = new PrismaClient({ omit: { user: { // make sure that password is never queried. password: true, }, }, });You’re also able to omit fields from multiple models and multiple fields from the same model
const prisma = new PrismaClient({ omit: { user: { // make sure that password and internalId are never queried. password: true, internalId: true, }, post: { secretkey: true, }, }, });With both local and global
omit, you now have the flexibility to completely remove sensitive fields while also tailoring individual queries. If you need the ability to generally omit a field except in a specific query, you can also overwrite a global omit locallyconst prisma = new PrismaClient({ omit: { user: { // password is omitted globally. password: true, }, }, }); const userWithPassword = await prisma.user.findUnique({ omit: { password: false }, // omit now false, so password is returned where: { id: 1 }, });Changes to
prismaSchemaFolderIn
5.15.0we released theprismaSchemaFolderPreview feature, allowing you to create multiple Prisma Schema files in aprisma/schemadirectory. We’ve gotten a lot of great feedback and are really excited with how the community has been using the feature.To continue improving our multi-file schema support, we have a few breaking changes to the
prismaSchemaFolderfeature:- When using relative paths in Prisma Schema files with the
prismaSchemaFolderfeature, a path is now relative to the file it is defined in rather than relative to theprisma/schemafolder. This means that if you have a generator block in/project/prisma/schema/config/generator.prismawith anoutputof./foothe output will be resolved to/project/prisma/schema/config/foorather than/project/prisma/foo. The path to a SQLite file will be resolved in the same manner. - We realized that during migration many people would have
prisma/schemaas well asprisma/schema.prisma. Our initial implementation looked for a.prismafile first and would ignore theschemafolder if it exists. This is now an error.
Changes to
fullTextSearchIn order to improve our full-text search implementation we have made a breaking change to the
fullTextSearchPreview feature.Previously, when the feature was enabled we updated the
<Model>OrderByWithRelationInputTypeScript type with the<Model>OrderByWithRelationAndSearchRelevanceInputtype. However, we have noted that there are no cases where relational ordering is needed but search relevance is not. Thus, we have decided to remove the<Model>OrderByWithRelationAndSearchRelevanceInputnaming and only use the<Model>OrderByWithRelationInputnaming.Fixes and improvements
Prisma
- Wrong Parameterized Types Sent for SQL Server Queries
Prisma has no exported member named OrderByWithRelationInput. Did you mean OrderByWithAggregationInput?- [Driver Adapters]: missing provider compatibility validation
- Disable "Start using Prisma Client" hint logs on
prisma generate - Deploying prisma to CloudFlare pages using Nuxt/Nitro and node-postgres (pg) is using the wrong(vercel) wasm path
@prisma/adapter-pgmodifies node-postgres global type parsers- @prisma/adapter-d1 is failing with an import error when called inside vitest tests
db pullfails with[libs\user-facing-errors\src\quaint.rs:136:18] internal error: entered unreachable codeon invalid credentials
Language tools (e.g. VS Code)
- Make prisma-fmt logs to work with language server
- Spans and positions get shifted out of sync when schema includes multibyte characters
- VSCode extension panics when opening an empty prisma schema
Prisma Engines
- [DA] Planetscale engine tests: one2m_mix_required_writable_readable
- [DA] Planetscale engine tests: apply_number_ops
Credits
Huge thanks to @key-moon, @pranayat, @yubrot, @skyzh, @brian-dlee, @mydea, @nickcarnival, @eruditmorina, @nzakas, @gutyerrez, @avallete, @ceddy4395, @Kayoshi-dev, @yehonatanz for helping!
- When using relative paths in Prisma Schema files with the
- 5.16.0-integration-vitest-workaround.225 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-vitest-workaround.117 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-sqlite-fix.111 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-optimize-login-v2.519 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-optimize-login-v2.418 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-optimize-login-v2.318 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-optimize-login-v2.218 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-optimize-login-v2.118 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-joel-repro-gh-11789.218 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-joel-repro-gh-11789.118 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-janpio-studio-prisma-config.314 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-janpio-studio-prisma-config.214 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-janpio-studio-prisma-config.114 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-fix-empty-schema.110 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-engines-5-16-0-15-fix-fts-relation-input-name-9388ddb70ab6bc6cba66ec9b351906f857af5d3f.117 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-engines-5-16-0-1-fix-sqlite-concurrent-writes-74a48e9f33b0a8b403045af35430ce444541be88.15 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-crypto-client-vercel.25 Jun 2024pre-release
Nothing published for this version
- 5.16.0-integration-crypto-client-vercel.15 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.6425 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.6325 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.6224 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.6124 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.6024 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5921 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5821 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5720 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5620 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5520 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5420 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5319 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5119 Jun 2024pre-release
Nothing published for this version
- 5.16.0-dev.5019 Jun 2024pre-release
Nothing published for this version