Last 7 days
0
Features: 0
Changes: 0
Fixes: 0
Deprecations: 0
Type-safe database toolkit for application developers.
Latest Prisma changelog updates, official release notes, breaking changes, security patches, pricing changes, and developer reactions in one product feed.
Follow this Prisma release-notes page to spot useful features, risky migrations, noisy announcements, and source links before they hit your backlog.
Changes.Watch links back to official changelog and release-note sources so summaries stay easy to verify.
Use channels to follow groups of tools around a stack, workflow, or topic.
Rolling windows show how many product updates landed in the last 7, 30, 90, and 365 days, grouped by existing changelog semantics.
0
2
3
28
Introduce a new @prisma package namespace where each app uses a single @prisma/orm facade (postgres, sqlite, or mongo), retiring @prisma/next and making all other packages publish under @prisma scope.
Patch updates a transitive dependency of Prisma CLI (via @prisma/dev) to resolve a security advisory (issue #29780).
Added shell tab completions for the Prisma CLI across bash, zsh, fish, and PowerShell, integrated via @bomb.sh/tab and package managers
Client generation handles workspace output paths more consistently.
Added queryPlanCacheMaxSize option to PrismaClient for fine‑grained query‑plan cache control.
Added an interactive `prisma bootstrap` command that automates full Prisma Postgres setup (init, link, install deps, migrate, generate, seed).
Updated the effect dependency to remediate a security vulnerability.
Introduced a new Prisma Postgres CLI group with a link command and added streaming schema parsing for extremely large files.
Added nested transaction rollback support with savepoints, ensuring inner transactions roll back when an outer transaction fails.
- Fixed case‑insensitive IN/NOT IN filter regression in Prisma Client.
Fix cursor‑based pagination regression and preserve Prisma.skip in query extensions
Introduce an ORM caching layer with an LRU cache to reuse compiled query plans and reduce event‑loop contention
Added a `compilerBuild` option (fast or small) allowing users to choose between speed‑optimized or size‑optimized query compiler engines.
Fixed Prisma Accelerate support issue in edge runtime configurations when the @prisma/client/edge entrypoint was not used.
Add SQL commenter plugin for query insights metadata
Patch release 6.19.1 fixes diffing bug introduced in 6.13.1 that reported empty diffs.
Introduce SQL commenter plugins for Prisma Client, allowing query tags, trace‑context and custom metadata in SQL queries.
Fixed multiple Prisma Studio issues: added Deno 1.4–2.2 and Bun 1 support, resolved column‑collision bugs, added SQLite‑file missing warnings, addressed issue 1363, and sorted tables alphabetically.
Prisma Client is now ESM‑only by default, with 90% smaller bundles and up to 3× faster queries; requires explicit adapter or accelerateUrl, and removes legacy client instantiation options.
Added connection pooling support for Prisma Postgres via `pool=true` query parameter.
prisma init now scaffolds a prisma.config.ts and enables datasource and engine configuration via this file, preparing for Prisma 7 requirements
Fix regression in v6.17.0 where diffing of unsupported types caused unnecessary or incorrect migration changes.
Added Entra ID (Active Directory) authentication support for the MS SQL driver and relaxed the @opentelemetry/instrumentation version range.
Fixed missing JSON null type definitions in Prisma Client’s browser entrypoint.
Fix validation to clearly error when Prisma Postgres URL and driver adapter are both specified (mutually exclusive)
Fixed leftover code in Prisma client TS generator that forced preview features in edge runtimes.
Migrated Prisma ORM core from Rust to TypeScript, offering a Rust‑free version (opt‑in) with ~90% smaller bundle size, faster queries and lower CPU usage
Added AI safety guardrails: CLI now requires explicit confirmation for destructive commands when invoked by popular AI assistants, protecting against accidental data loss.
Introduced the @unique attribute for SQL views (preview), enabling relationships, findUnique queries, and cursor‑based pagination on views.
Prisma Config file (prisma.config.ts) and multi‑schema support are now General Availability, dropping early‑access flags.
Introduced preview of an ESM‑compatible Prisma client generator, set to become the default in v7
Fixed PrismaClientInitializationError when using @prisma/client with @prisma/extension accelerate on a prisma+postgres:// connection string during client generation.
Added preview driver adapters for MySQL/MariaDB, Neon, and CockroachDB, enabling a Rust‑free Prisma ORM version; CLI now supports stopping and removing local Prisma Postgres instances and introduces a more flexible Prisma client generato...
Fix incomplete PostgreSQL connection termination on Windows for Prisma Migrate.
Preview Rust‑engine‑free query compiler for MS SQL Server and PlanetScale via adapter packages
Preview release of Rust‑engine‑free Prisma ORM for PostgreSQL & SQLite using queryCompiler and driverAdapters flags.
- Fixed prisma init and prisma dev commands on Windows that were broken after 6.8.1
Fix prisma init command on Windows
Added `prisma dev` command for local Prisma Postgres development without Docker
Introduced Rust‑free Query Compiler for PostgreSQL and SQLite (early access) requiring new flags and driver adapters
Early‑access Prisma client generator with full ESM support, requiring an explicit output path and emitting plain TypeScript.
Removed interactive reset prompt; migrations now exit with an error unless `prisma migrate reset` is run explicitly
Fixed issues with the NPS survey functionality
Introduce early‑access TypeScript configuration file (prisma.config.ts) for custom runtime config
Improved Prisma init output when using the `db` option
Added Prisma Studio to the Console with a new model viewer, edit sidebar, and “Close all” button for a better developer experience.
Fix omission of omitApi preview checks when promoting to GA.
Imported from changelog source; review and generate a concise summary before publishing.
Tracing preview upgraded to GA – stable without preview flag, updated span format, and @opentelemetry/api now a peer dependency; adjust dependencies accordingly
Fixed issue with Prisma Client generated in a custom output path when used with Next.js
Upgrade to Prisma ORM v6 requires newer runtimes (Node.js ≥18.18.0, TypeScript ≥5.1.0) and introduces breaking schema changes: primary key on implicit many‑to‑many tables, replacement of Buffer with Uint8Array, removal of NotFoundError, ...
Added OpenTelemetry‑compatible tracing spans for database client calls, improving compatibility with tools like DataDog and Sentry
Fixed bug where migrations didn't use the shadow database in certain edge cases
Added full MongoDB support to the tracing preview feature, enabling OpenTelemetry instrumentation for Prisma Client.
Introduces preview feature `strictUndefinedChecks` that throws runtime errors for explicit undefined values, with `Prisma.skip` to retain old behavior; recommended alongside TS `exactOptionalPropertyTypes`.
Fixed multiple runtime bugs reported in issues #25101, #25103, #25104, and #25137
Added TypedSQL preview: write .sql files in a prisma/sql folder, type‑checked at generate time and importable via @prisma/client/sql.
Add native support for UUID v7 via updated uuid() function with optional version argument
Added native “find references”, hover previews, and quick‑fix actions to the Prisma VSCode extension
Fixed Prisma Client failure when importing the WASM module in Next.js apps deployed to Vercel Edge.
Fixed Prisma Client dotenv loading issue causing DATABASE_URL errors
Added global omitApi preview to omit model fields across all queries
Fix internal error "entered unreachable code" in Prisma Client during upserts
Added preview support for multi‑file Prisma schemas via the `prismaSchemaFolder` flag, allowing a `prisma/schema` directory with multiple .prisma files.
Introduce top‑level `createManyAndReturn()` query with RETURNING support for PostgreSQL, CockroachDB, and SQLite, allowing immediate retrieval of created records and field selection.
Added preview `omit` API to Prisma Client, enabling exclusion of fields in queries (mutually exclusive with `select`).
Fixed Windows-only CLI flags for Cloudflare D1 migration diff and db pull introduced in 5.12.0.
Added preview support for Cloudflare D1 via the @prisma/adapter D1 driver and driverAdapters feature
Add preview support for deploying Prisma ORM to Vercel Edge Functions, Vercel Edge Middleware, Cloudflare Workers and Cloudflare Pages (requires compatible database drivers).
Fix persistent "Invalid character" error in Prisma CLI affecting Prisma Studio
Fixes Prisma Client and CLI error caused by non‑ASCII characters (e.g., Chinese) in schema.prisma comments
Added MySQL preview feature `relationJoins` with `relationLoadStrategy` (join or query) for optimized relation queries (MySQL ≥ 8.0.14).
Fixed TypeScript type breakage caused by conditional exports in @prisma/client.
Introduced JOIN-based relation queries and optimized result sets, expanding RETURNING support to SQLite and more operations, reducing unnecessary SELECTs.
Fixed Prisma Client parallel execution error (P2024) caused by connection limits in version 5.8.0
Added preview option to specify per‑query relation loading strategy (join or separate queries) via `relationLoadStrategy`.
- Fixed multiple bugs in the relationJoins preview feature, including Int[] returning null and filtering issues with isNot: null.
Preview support for JOINs in relation queries for PostgreSQL and CockroachDB.
Prisma Accelerate (global edge cache and connection pooling) is now generally available.
Fixes Prisma CLI checksum validation error for Windows query_engine.dll.node.gz
Fix regression in Prisma Client 5.5.0 causing a TypeScript error when passing PrismaPlanetScale adapter to the constructor
Added three new flags to `prisma init` for setting default generator, preview features, and client output location.
Fix subquery column overflow issue in Prisma Client 5.4.0
Fix Prisma Client error where .findMany() reported a missing column j1.id
Added preview support for PlanetScale and Neon serverless drivers and early‑access Turso driver via the driverAdapters flag
Fixed duplicated keys in metrics properties within Prisma Client
Added runtime validation for undefined values in JSON array fields and improved memory usage for models with many @unique constraints.
Added a `noEngine` flag to omit the Query Engine from generated Prisma Client, optimizing bundle size for Accelerate and Data Proxy usage.
Fixed unhandled runtime error in Prisma Client Browser bundle when upgrading from 5.0.0 to 5.1.0
Optimized Prisma Client to generate fewer SQL statements for PostgreSQL and CockroachDB updates/inserts, cutting unnecessary queries and transactions.
Default JSON wire protocol is now GA, delivering faster performance, along with GA of fieldReference and extendedWhereUnique features.
Fix incorrect generated types for MongoDB list composites
Restored proper field references and type generation for extended Prisma clients, including $extend handling with composite compilerOptions
Prisma Client extensions are now generally available and production‑ready, with added $allOperations method, updated import path, and middleware deprecated in favor of query extensions.
Adds support for custom arguments to the `prisma db seed` command, enabling environment‑specific or partial seeding.
Fixes Prisma Client edge build failing on Cloudflare Workers due to unresolved "os" module
Added new preview capabilities such as PostgreSQL extensions, extended unique constraints, field reference support, order‑by‑nulls, and filtered count, plus extra introspection warnings for check, exclusion, and $jsonSchema features.
Added introspection warnings for unsupported database features (e.g., partitioned tables, row‑level security, TTL) and improved documentation links
Introduced a preview feature to introspect SQL views, generating .sql files alongside the Prisma schema.
Early preview JSON protocol added to improve Prisma Client startup performance, enabled via preview flag or PRISMA_ENGINE_PROTOCOL env var (with known limitations).
Fix false validation of the directUrl environment variable in Prisma Client, preventing erroneous P1012 errors.
Added `directUrl` datasource option for separate connection strings, improving support for connection poolers like Prisma Data Proxy and pgBouncer.
Imported from changelog source; review and generate a concise summary before publishing.
Fix TypeScript type conflicts in Prisma Client for custom many‑to‑many relations
Reduce engine binary size by ~50% (e.g., Query Engine from 39 MB to 14 MB) and speed up schema loading for better serverless performance
Fix missing Enum field types in select when using clientExtensions preview feature
Interactive transactions are now Generally Available, enabling async functions in $transaction with support for isolation levels and Data Proxy.
Fix Prisma Client regression causing panics in findMany after upgrading to 4.6.0
Enables preview of interactive transactions with Prisma Data Proxy (still requires the preview flag)
Added preview support for non‑unique fields in unique‑record where clauses (e.g., findUnique, update).
Added support for setting transaction isolation levels on sequential transactions and introduced new P2034 error code for write conflicts or deadlocks.
Fix Prisma Client compatibility with TypeScript 4.8
Added preview support for field references, filtered‑relation count, and multi‑schema (PostgreSQL/SQL Server) via feature flags.
Fixed cold start performance regression in Prisma Client
Preview support for Prisma Client tracing, enabling distributed request tracking with tools like Jaeger, Honeycomb, or DataDog.
Fixed regression in Prisma Studio where horizontal scrolling sometimes failed
Added preview support for ordering null values via the `orderByNulls` flag
General Availability for preview features (extendedIndexes, filterJson, improvedQueryRaw) and new defaults for scalar lists and embedded MongoDB documents.
Introduce PRISMA_GENERATE_DATAPROXY environment variable to enable Data Proxy generation via Prisma Client without running the CLI command
Fixed regression from 3.15.0 that caused database connection errors on macOS
Improved Prisma Client for Data Proxy with a new generation flag and Edge import (@prisma/client/edge) for Cloudflare Workers and Edge environments
GA release of CockroachDB connector with full Prisma Client and Migrate support.
GA for `prisma migrate diff` and `prisma db execute` commands, removing the preview flag and enabling automated migration workflows
MongoDB support graduates to GA with type‑safe embedded document queries, schema‑driven index management, introspection and raw query APIs.
Changed default filter behavior: undefined fields are excluded by default, breaking existing queries that relied on them being returned;
Added experimental support for filtering and sorting embedded documents, with preview for "contains many" relationships
Added preview support for embedded documents with a new `type` keyword and enabled their introspection by default
Fixed Fluent API chaining issue for PascalCase columns
Fix Prisma DB pull to correctly read .env files
Added preview CLI commands `prisma migrate diff` and `prisma db execute` for generating schema diffs and applying SQL scripts, enabling automated migration workflows.
Fix runtime error in @prisma/sdk v3.8.0 where the 'fs jetpack' module could not be found.
Added preview support for MySQL full‑text search via `@@fulltext()` and new schema flags.
Imported from changelog source; review and generate a concise summary before publishing.
Preview support for full‑text indexes in MySQL & MongoDB and hash indexes in PostgreSQL.
Add ordering by relevance for PostgreSQL full‑text search (feature flag)
Resolve Prisma Client Data Proxy crash when handling multi-byte characters
Bugfix for MongoDB preview feature: resolves failure when creating many‑to‑many (m‑n) relationships.
Added PostgreSQL 14 support and new MongoDB features: orderBy on aggregate groups, initial db push sync for uniques/indexes, and embedded document introspection.
Early Access Prisma Data Proxy adds connection pooling and enables Prisma Client use in serverless environments such as Cloudflare Workers.
Fixed Prisma Client generation errors on Alpine 3.14 with Node 14 caused by missing libssl.so.3
Added preview support for MongoDB introspection via `prisma db pull`, generating a Prisma schema from existing collections with type conflict comments and manual relation handling.
Introduced the referentialIntegrity preview flag (renamed from planetScaleMode) to enable Prisma‑level referential integrity for databases without foreign keys, defaulting to Prisma for MongoDB
Patch release 3.0.2.
Promoted several preview features to General Availability (Referential Actions, Named Constraints, Microsoft SQL Server/Azure SQL support, prisma db seed, Node API, Order‑by‑Aggregate in Group‑by, and Order‑by‑Relation).
Improved Prisma CLI with a revamped update notifier for major version upgrades
Fixes an issue where a NOT within another NOT generated SQL with only a single NOT
Added preview support for Full‑Text Search on PostgreSQL via the `fullTextSearch` flag.
Fix 'debug' namespace resolution error in Prisma Client
Introduces Interactive Transactions as a preview feature (opt‑in via schema flag) for transactional writes with dependency handling.
Fixed multiple MongoDB connector bugs (findUnique errors, relation filtering, array ID filtering) and assorted Prisma Client, Migrate, and Studio issues.
Added preview support for MongoDB, enabling Prisma schemas to target mongodb and generate a compatible client.
Added a preview "referentialActions" feature allowing fine‑grained ON DELETE/ON UPDATE control in the Prisma schema; defaults shift to RESTRICT/SET NULL and Prisma Client no longer pre‑checks deletes, which may be a breaking change for e...
Added human‑readable drift diagnostics to `prisma migrate dev` for easier debugging.
Fixed panic in Prisma Client createMany caused by a missing scalar field in FundMangerTeamMemberExperience.
Added JSON and enum support to the MongoDB provider for Prisma Client.
Added preview JSON filtering for PostgreSQL and MySQL, enabling queries on JSON fields
Fix Prisma CLI Prisma Migrate error on SQL Server caused by invalid data source URL
prisma db push promoted to General Availability, enabling schema updates without migrations
Fixed Prisma Client MaxListenersExceededWarning memory leak warning.
Imported from changelog source; review and generate a concise summary before publishing.
Added preview support for ordering groupBy results by aggregate values (orderByAggregateGroup flag).
Imported from changelog source; review and generate a concise summary before publishing.
Added preview support for relation count queries and a Node API binding Prisma’s Rust engine directly to the client; GA for groupBy/createMany and new PostgreSQL array push operation.
Prisma Migrate is now GA, removing the preview flag and automatically triggering client generation after migrate commands.
Add new `prisma db pull` command to replace `prisma introspect`, with a deprecation path for the old command.
Native database types are now GA, enabling @db.* column attributes and ignore directives for unsupported fields
Fixed localhost connection failures for MySQL, MariaDB, and SQL Server when run via Docker
Move Prisma CLI to the `prisma` npm package and deprecate `@prisma/cli`, requiring a find‑replace in codebases.
Adds native database type support in Prisma Migrate and introduces a preview db seed command for fast data seeding.
Added preview support for Group By queries in Prisma Client (enable via generator flag).
Fixed reintrospection bug on relations in Introspection.
Introduce Prisma Migrate Preview with deterministic plain‑SQL migrations, breaking the previous experimental API
Fixed a client-breaking issue where error classes were incorrectly exported as types
Added a standalone Prisma Studio macOS app with Windows/Linux support planned.
Introduced native database type mapping and preview scalar types (BigInt, Bytes, Decimal).
Fix env variable loading conflict when .env already exists in project root
Fix CLI engine usage and ensure Prisma Client loads root .env
Added preview support for Microsoft SQL Server via a new `sqlserver` connector (requires preview flag)
Added clientVersion field to Prisma Client error objects and improved $transaction error messages.
Fixed invalid DMMF Enum value types in Prisma Client.
Introduced findFirst API that applies full findMany filters while returning only the first matching record
Fix for Prisma Client JS connection errors when the connection string contains a dollar sign
Prisma Studio promoted to stable and can be launched with `prisma studio` without the experimental flag.
Fixes broken update queries introduced in Prisma Client JS 2.6.0
Fixes for broken update queries introduced in Prisma Client JS 2.6.0
Prisma introspect now preserves manual schema changes by default (re‑introspection), with a new `--force` flag to override and avoid breaking existing workflows.
Fix Prisma Client JS list relation filter issue introduced in 2.5.0
Promoted middlewares, distinct query, and aggregation API to stable, removing the need for preview feature flags.
Adjusted Order by Multiple Fields API to ensure stable property ordering in JavaScript objects
Added ability to order query results by multiple fields via the new orderBy object syntax
Added a rename helper tool to the VS Code extension and made introspection preserve column order in generated models
Fixed the incorrect binary that was released in version 2.2.1
Fixed Prisma CLI env loading when both ./prisma/.env and ./.env are present
VS Code extension now provides quick‑fix suggestions for Prisma schema typos
Released patch 2.1.3 with various fixes and improvements.
Fixes the new table grid component in Studio
Mask datasource URLs in migration files to prevent credential leakage.
Added JSON field filtering, prepared‑statement caching for PostgreSQL, and new experimental feature flags (connectOrCreate, transaction API, re‑introspection, custom @@map).
First patch release 2.0.1 using the new patch process
Launches Prisma 2.0 GA with Prisma Client, a type‑safe auto‑generated query builder for databases.