# What changed in prisma

> 302 changes in prisma 6 to 7 from its official release notes, upgrade guides and advisories: 93 breaking, 3 deprecations, 8 security, 61 new APIs and options. Each one cited. Sources checked 2026-10-17. HTML: https://unstale.sh/npm/prisma/

To see which of these apply to a repository, run `npx @unstale/cli init` in it.

## prisma 7

### Breaking changes

- Automatically batched calls now reject every missing record with P2025 instead of resolving later misses to undefined. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- PostgreSQL deadlocks with SQLSTATE 40P01 are now reported as P2034 transaction write conflicts. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Previously unhandled SQLite result codes now become typed database errors instead of raw driver errors. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Invalid Date values now throw PrismaClientValidationError instead of a generic error. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- db pull, db push, and migrate dev now report a consistent datasource error for empty or generator-only schemas. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The complete SQLITE_BUSY family now maps to socket timeout errors while preserving numeric extended result codes where available. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Destructive Prisma commands are refused when an AI agent is detected unless the user gives explicit consent. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Invalid Date values now fail fast with a validation error instead of being serialized as null. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- The migrate-reset tool is removed from the prisma mcp server because resetting a database is destructive. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Unmapped driver-adapter database errors now surface as PrismaClientKnownRequestError with the original code and message. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- A rolled-back migration still present on disk is now reported as unapplied instead of up to date. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Invalid Date values now fail fast with a validation error instead of being serialized as null. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- The XOR type helper now rejects primitive values at compile time instead of accepting values that fail at runtime. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Savepoint operations now silently no-op with debug logging instead of executing SQL statements. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- AccelerateEngine has been removed; Accelerate now uses RemoteExecutor. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The adapter setting has been removed from Prisma config. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The BinaryEngine and its long-running executable binary mode have been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Driver adapters inherit connection pool settings from the underlying Node.js database driver, which may differ from Prisma ORM v6 defaults. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- DataProxyEngine has been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- datasource.directUrl has been removed as unnecessary. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- datasource.url is now configured in the Prisma config file instead of schema.prisma. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx)
- Migration connections previously supplied through directUrl must now be supplied as url in prisma.config.ts. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Creating Prisma Client now requires a driver adapter for all databases. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- For prisma-client-js, the edge runtime path now uses /edge instead of /wasm. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The engine setting with js or classic values has been removed from Prisma config. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The Prisma CLI no longer automatically loads environment variables; developers must load them explicitly. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma ORM now ships as an ES module, requiring projects to configure package and TypeScript module settings. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The react-native generator runtime value has been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The LibraryEngine and its Node-API client engine mode have been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Generated TypeScript enum values use schema names instead of mapped database values, matching Prisma ORM v6 behavior. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The deprecated metrics preview feature has been fully removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- MongoDB is not supported in Prisma 7; MongoDB users should remain on Prisma 6. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Node.js 20.19.0 is the minimum supported version for Prisma ORM v7. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Generated Client runtime and project types now require an output path in schema.prisma. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The prisma package.json block for schema and seed configuration has been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Projects consuming Prisma ORM as ESM need to set the package type to module. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma Postgres projects now use the @prisma/adapter-pg driver adapter when constructing Prisma Client. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_CLI_QUERY_ENGINE_TYPE was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_CLIENT_ENGINE_TYPE was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_CLIENT_NO_RETRY was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- prisma-client-js users using output must install this runtime utilities package. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Generated Prisma Client must now be imported from the configured custom output path. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --schema flag was removed; the schema path must be configured in prisma.config.ts. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --url flag was removed; the database connection must be configured in prisma.config.ts. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --local-d1 flag has been removed; local D1 uses config datasource settings instead. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The undocumented --url flag has been removed from prisma db pull. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The --skip-generate flag was removed from prisma db push. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Database seeding must now be invoked explicitly with prisma db seed. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma no longer runs generate implicitly after installation or migration. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --accelerate flag has been removed from prisma generate. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The --allow-no-models flag has been removed from prisma generate. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The --data-proxy flag has been removed from prisma generate. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The Prisma-specific environment variable PRISMA_GENERATE_DATAPROXY was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_GENERATE_IN_POSTINSTALL was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --no-engine flag has been removed from prisma generate. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The Prisma-specific environment variable PRISMA_GENERATE_NO_ENGINE was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_GENERATE_SKIP_AUTOINSTALL was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The deprecated prisma introspect command has been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The --skip-generate flag was removed from prisma migrate dev. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --skip-seed flag was removed from prisma migrate dev. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --from-schema-datasource option was removed and replaced by --from-config-datasource. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The local D1 diff flags were removed and replaced by config datasource flags. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The schema-datamodel diff flags were removed and replaced by the corresponding schema flags. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The schema-datasource diff flags were removed and replaced by config datasource flags. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The URL diff flags were removed and replaced by config datasource flags. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The --from-url option was removed and replaced by --from-config-datasource. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --shadow-database-url option was removed; configure the shadow database URL in prisma.config.ts. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --to-schema-datasource option was removed and replaced by --to-config-datasource. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The --to-url option was removed and replaced by --to-config-datasource. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- prisma migrate reset no longer automatically runs seed scripts. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_MIGRATE_SKIP_GENERATE was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_MIGRATE_SKIP_SEED was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_QUERY_ENGINE_BINARY was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_QUERY_ENGINE_LIBRARY was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma migrate no longer runs seed implicitly. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The Prisma-specific environment variable PRISMA_SKIP_POSTINSTALL_GENERATE was removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The client middleware API has been removed; Client Extensions are the replacement. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- prisma.config.ts is now required for projects performing introspection or migration. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The driver adapter name changed from PrismaBetterSQLite3 to PrismaBetterSqlite3. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Creating PrismaClient now requires either a driver adapter or accelerateUrl. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- PrismaClient no longer accepts the datasources option. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- PrismaClient no longer accepts the datasourceUrl option. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Calling PrismaClient without constructor arguments is no longer supported. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Calling PrismaClient with an empty options object is no longer supported. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The driver adapter name changed from PrismaD1HTTP to PrismaD1Http. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The driver adapter name changed from PrismaLibSQL to PrismaLibSql. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The driver adapter name changed from PrismaNeonHTTP to PrismaNeonHttp. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- ReactNativeEngine has been removed. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Invalid SSL certificates are no longer ignored by default when Prisma ORM v7 uses node-pg. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- TypeScript 5.4.0 is the minimum supported version for Prisma ORM v7. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Hardcoded URL validation was removed; users must avoid sensitive information in config files. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)

### Security

- Deserialized Bytes values now own standalone ArrayBuffers instead of exposing unrelated contents from Node.js's shared Buffer pool. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The AI-agent safety checkpoint now also covers interactive confirmations involving data-loss warnings. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The AI-agent safety checkpoint now covers interactive confirmations involving data-loss warnings, not only invocations using --accept-data-loss. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Studio now binds to 127.0.0.1 and restricts browser origins, preventing network clients or malicious websites from accessing database endpoints. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Resolves a security advisory in a transitive Prisma CLI dependency to prevent false positives from security scanners; no urgent action is required. (7.9.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.1)
- The Prisma Platform credentials file and directory now use restrictive permissions so OAuth tokens are not world-readable. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- The AI safety checkpoint now also guards db push --accept-data-loss. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Potential vulnerabilities in installed Prisma CLI dependencies are fixed. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)

### Deprecations

- The datasource directUrl field is deprecated and should be configured in Prisma Config. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx)
- Datasource connection fields are deprecated in the schema and should be configured in Prisma Config. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- The older prisma-client-js provider is deprecated and will be removed in a future Prisma ORM release. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)

### New APIs and options

- Result-extension compute callbacks receive the current model name as a typed second argument, preserved across composed extensions. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The MariaDB adapter accepts an existing mariadb pool, with optional disposal through disposeExternalPool. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- A compatibility package enables Prisma 7 CLI and configuration alongside Prisma 8 in the same project. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The Prisma 7 executable is available as prisma7 for version-specific commands such as generate, migrate dev, and db push. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Prisma 7 now prefers version-specific configuration files, allowing its configuration to coexist with Prisma 8 configuration files. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Prisma Studio can visualize Prisma Next migration history with timelines, schema diffs, SQL statements, and model changes. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Prisma now provides shell tab completions for commands, subcommands, options, flags, and option values. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Prisma Compute is available in public beta for deploying long-lived TypeScript applications near Prisma Postgres. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- prisma init installs the Prisma agent skills catalog in freshly scaffolded projects, with an option to opt out. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Studio adds a dedicated stream browser with aggregations, diagnostics, routing-key browsing, and WAL-history handoff. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Studio adds an optional Queries view backed by query-insights snapshots. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Adds fine-grained control over the query plan cache, including disabling it with 0. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- New interactive command sequences Prisma Postgres setup, including initialization, linking, dependency installation, migration, generation, and seeding. (7.7.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.7.0)
- Supports supplying an API key for non-interactive bootstrapping in CI. (7.7.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.7.0)
- Supports supplying a database identifier for non-interactive bootstrapping in CI. (7.7.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.7.0)
- Supports selecting a starter template when bootstrapping a project. (7.7.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.7.0)
- Prisma Studio can copy one or more rows as CSV or Markdown. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Prisma Studio can generate SQL statements from natural-language requests using AI. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Prisma Studio can use natural language and AI to generate SQL statements for database inspection. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Prisma Studio supports editing multiple cells and prompts users to save or discard changes. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- The constructor now accepts connection strings directly for improved ergonomics. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Adds a command that connects a local project to a Prisma Postgres database. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Allows custom prepared statement name generation so users can leverage pg statement caching. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Adds a constructor option to choose between text and binary protocols. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Studio in Console now supports AI-generated filters. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma Studio adds a cmd+k command palette for performing most actions by keyboard. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma Studio now supports searching across database tables and cells. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma Studio now allows selecting multiple database cells at once. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma Studio filtering now includes an option to use raw SQL filters. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma Studio adds an SQL sidebar tab for running raw SQL queries against database data. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Interactive transaction clients can now use $transaction to create nested transactions. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Supports a where argument on field-level @unique declarations for partial indexes. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Adds partial index support behind the partialIndexes preview feature for PostgreSQL, SQLite, SQL Server, and CockroachDB. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- The client generator supports fast and small query compiler builds; fast is the default, while small reduces size with a speed tradeoff. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- Adds a -url flag for more flexible connection configuration. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Adds a -url flag for more flexible connection configuration. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Adds a -url flag for more flexible connection configuration. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Adds a SQL commenter plugin to support query insights metadata. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Adds a PrismaClient option for configuring SQL commenter plugins that append metadata to SQL queries. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Adds query tag plugins and async-context helpers for attaching arbitrary metadata to queries. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Adds a plugin that appends W3C Trace Context metadata for distributed tracing correlation. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Adds a plugin type for creating custom SQL commenter metadata plugins. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- datasource.shadowDatabaseUrl is now configured in the Prisma config file. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx)
- The D1 adapter provides listLocalDatabases to configure local D1 database connections. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The @map attribute can now be used on enum members to set their runtime values. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- NODE_EXTRA_CA_CERTS can configure database certificate authorities for Prisma ORM v7. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- SQLite projects can use the @prisma/adapter-better-sqlite3 driver adapter. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma Studio can inspect a remote database using the --url flag. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Prisma Studio can inspect remote databases by passing a --url flag. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- Prisma Config is now the default place for configuring database URLs, schema location, migrations, and seed scripts. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- A serverless client library supports edge runtimes, streaming results, pipelined queries, parameterized SQL, transactions, and batch operations. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- A serverless client library supports edge and serverless runtimes, streaming results, pipelining queries, and transactions. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)

### Performance

- Fluent-relation field maps are now built lazily and linearly; non-fluent queries no longer construct them. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Field maps are constructed lazily and in linear time, and non-fluent queries no longer build them, reducing ordinary query setup overhead. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Query plans now eagerly perform one unconditional database operation and synchronously interpret remaining pure operations while keeping cached plans immutable. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Plans with one unconditional database operation are evaluated eagerly and remaining pure plan steps are interpreted synchronously; cached plans remain immutable. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Restoring the OmitOpts generic default lets tsc reuse cached type instantiations, reducing type-checking time on large schemas. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Prisma Client now caches compiled query plans for repeated query shapes, reducing compiler overhead and event loop contention. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- Raw queries can bypass the query compiler and interpreter infrastructure, sending them directly to the driver adapter to reduce overhead. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- The new prisma-client provider uses the Rust-free client, with faster queries, smaller bundles, and fewer deployment resources. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)

### Behavior and default changes

- MariaDB connection strings now support bracketed IPv6 addresses. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- MySQL connection strings now support bracketed IPv6 addresses. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Remote query events now share matching spans and traces, record errors as span exceptions, and continue logging when tracing is unavailable. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Prisma Postgres Serverless now prefers named constraints and falls back to parsed field names for unique violations. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Chunked statements now execute atomically in a transaction and roll back if a later chunk fails. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Version output now includes the resolved Prisma CLI package path, helping diagnose global-versus-local installation issues. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- JSON version output now includes the resolved Prisma CLI package path. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Without an explicit config option, Prisma 7 searches version-specific config locations before falling back to existing prisma.config.* files. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Windows engine binaries are cached in a stable user-level directory instead of a cwd-relative node_modules cache. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Freshly scaffolded projects receive version-relevant Prisma agent skills, and installation is best-effort. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Missing driver adapter errors now include a copy-pasteable example and a link to the driver adapters documentation. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- MariaDB statement caching is disabled by default to address a reported leak. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Prisma schema parsing now streams with automatic fallback for extremely large intermediate strings exceeding V8 limits. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- SQL databases now support nested transaction rollbacks through savepoints, including rollback of inner transactions when an outer transaction fails. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Allows a missing datasource URL and validates it only when needed. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Interactive transactions can now batch multiple queries. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Surfaces DataMapperError as a user-facing error for clearer, more actionable error reporting. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Tailors generated setup based on whether the runtime is Bun or another JavaScript runtime. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- @opentelemetry/api is treated as an external dependency during instrumentation, preventing duplicate copies in applications. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Reports an additional error when constructing PrismaClient without configuration arguments. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- The engines check is relaxed so Node.js 25+ users can adopt Prisma, although Node.js 25+ is not considered stable. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- prisma db seed now shows an informative message when no migrations.seed command is configured. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- Prisma Studio now sorts tables alphabetically. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- Prisma Studio warns when the SQLite file does not exist. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- Prisma Accelerate now serves as a dedicated caching layer while Prisma Postgres provides connection pooling natively. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- With native Prisma Postgres pooling, Prisma Accelerate now serves as a dedicated caching layer. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- The Rust-free ESM Prisma Client is now the default provider for new projects. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0), [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx)

### Tooling

- Generation can offer a one-time, opt-in installation of Prisma's agent skills, with environment skips, a timeout, and no generation failure. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Studio's Query Details view now provides copy actions. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Studio SQL execution, linting, and navigation now resolve unqualified identifiers against the selected schema. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Prisma Studio links records to related records in referenced tables for easier database traversal. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- Relaxes the version constraint to ^8.16.0 for compatibility with newer PostgreSQL type definitions. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- @types/pg is now a direct adapter-pg dependency, improving the out-of-the-box TypeScript experience. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Adds support for object expressions and object members in the schema reformatter. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Prisma Studio now supports Deno >= 1.4 <2.2 and Bun >= 1. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- The Prisma CLI now includes the new Prisma Studio with relationship visualization and remote database inspection. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)
- TypeScript projects need bundler module resolution to consume Prisma's ES modules. (7.0.0) — [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)

### Fixes and other changes

- Combining chunked results containing hundreds of thousands of rows no longer causes call-stack overflows. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- CLI commands tolerate corrupt, unreadable, or unwritable state files through reinitialization, atomic writes, and in-memory fallback. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Date values created in other JavaScript realms, including iframes, jsdom, and vm contexts, are now handled correctly. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Interactive transaction cleanup during disconnect now handles transactions whose driver-level startup is still in progress. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Invalid Date values now throw PrismaClientValidationError instead of a generic error. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Fluent relation queries now work when relation fields are named select or include. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Rendering very large parameter lists and combining huge chunked results no longer causes call-stack overflows. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Rendering very large parameter lists no longer causes call-stack overflows. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The prisma-client generator now infers module format from the nearest package.json type for node16 and nodenext projects. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Nested-write unique constraint errors now identify the violating model, including models using @@map and @@schema. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- PostgreSQL RESTRICT violations with SQLSTATE 23001 are now reported as P2003 with an available field or constraint name. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- The PostgreSQL adapter now preserves database constraint names in P2002 unique constraint violations. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Cleanup failures after transaction timeout or backend termination no longer become unhandled promise rejections. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Uint8Array values created in other JavaScript realms, including iframes, jsdom, and vm contexts, are now handled correctly. (7.10.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.10.0)
- Timed-out interactive transactions now issue ROLLBACK before returning connections to the pool, preventing leaked transaction state. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- PostgreSQL primary-key constraint renames are rendered as separate ALTER TABLE statements to avoid multi-change migration errors. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Setting nullable Bytes fields to null now sends VarBinary parameters instead of implicitly typed nvarchar values. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Reading Bytes columns no longer emits Node.js DEP0005 deprecation warnings. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Reading Bytes columns no longer emits Node.js DEP0005 deprecation warnings. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- P2022 errors now parse quoted and unquoted PostgreSQL column names, including identifiers containing spaces. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- Schema-loading commands no longer hang on symlink cycles or report duplicate files reached through alternate paths. (7.9.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.9.0)
- PostgreSQL introspection now preserves sequence defaults returned in schema-qualified form. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Corrects the P2029 database parameter limit check so over-limit queries are handled accurately. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- PostgreSQL JSON list equality filters no longer panic or emit invalid ::jsonb casts. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Enum values with custom database names are now parameterized correctly. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Case-insensitive JSON field filtering now works correctly with mode: insensitive. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Migration replay now supports PostgreSQL CREATE INDEX CONCURRENTLY statements outside transaction blocks. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Corrects a misleading error message that referenced the removed --shadow-database-url flag. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- Restores required SQL Server VARCHAR casts for parameterized values. (7.8.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.8.0)
- ColumnNotFound errors now correctly extract column names from quoted and unquoted PostgreSQL error messages. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- createMany queries are no longer cached, avoiding cache bloat and potential Node.js crashes during bulk operations. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- The new prisma-client generator now exports this groupBy payload type for TypeScript usage. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- NowGenerator is lazy, avoiding synchronous Date calls that caused Next.js dynamic usage errors in cached components. (7.6.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.6.0)
- adapter-mariadb now uses the binary MySQL protocol, fixing lossy number conversions. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- DateTime fields no longer return Invalid Date in some cases when using unixepoch-ms timestamps. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Cursor-based pagination now works correctly with @db.Date columns. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Partial index predicate comparison now handles quoted and unquoted identifiers correctly, preventing needless index recreation. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Partial unique indexes are excluded from DMMF unique metadata, preventing incorrect findUnique input type generation. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Manual partial indexes are preserved when the partialIndexes preview feature is disabled, avoiding unnecessary migration drops and additions. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Prisma.DbNull no longer serializes as an empty object in some bundled environments such as Next.js. (7.5.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.5.0)
- Fixed query plan mutation that caused cursor queries to break. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed a case-insensitive IN filter regression. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed MySQL joins that relied on non-strict equality. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed a case-insensitive NOT IN filter regression. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed partial index predicate comparison on PostgreSQL and MSSQL. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Updated text column detection to check for a binary collation. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Corrected relationJoins compatibility checks for MariaDB 8.x versions. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed array parameter wrapping in push operations. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixed Uint8Array serialization in nested JSON fields. (7.4.2) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.2)
- Fixes a regression affecting cursor-based pagination when using parameterised values. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Adds missing JSON value deserialization for JSONB parameter fields. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Handles null values in type parsers for nullable columns. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Preserves Prisma.skip when query extension arguments are cloned. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Applies result extensions correctly to nested and fluent relations. (7.4.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.1)
- Prevents BigInt precision loss in JSON aggregation for MySQL and CockroachDB by casting BigInt values to text. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- PostgreSQL migration scripts now permit usage of CREATE INDEX CONCURRENTLY in migrations. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- Connection strings now properly URL-decode non-ASCII database names, preventing connection failures. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- MSSQL connection string parsing now handles curly brace escaping for passwords containing special characters. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- PlanetScale adapter now properly propagates silent transaction commit failures. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- SQL Server adapter serializes commit and rollback operations to resolve EREQINPROG race condition errors. (7.4.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.4.0)
- Mapped enums revert to Prisma 6.19.0 behavior, so generated enum values no longer come from the value passed to @map. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- Mapped enums again follow the v6.19.0 behavior instead of taking generated enum values from the value passed to @map. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- The adapter pins a better-sqlite3 version to avoid an SQLite 3.51.0 bug; users should upgrade to v7.3.0. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- The adapter pins a safer better-sqlite3 version to avoid an underlying SQLite 3.51.0 bug; users should upgrade to v7.3.0. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- BigInt values in JSON aggregation are returned as JSON strings, preserving full precision when parsed in JavaScript. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- BigInt values in JSON aggregation are returned as JSON strings, preserving full precision when parsed in JavaScript. (7.3.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.3.0)
- Improves Postgres adapter error handling for invalid-text-representation errors. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Fixes byte upsert behavior by removing a legacy byte-array representation path. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Prevents issues when multibyte UTF-8 characters are split across chunk boundaries during line processing. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Allows certain workflows to proceed even when URLs are undefined. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Emits machine-readable JSON cleanly to stdout without extra noise. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Resolves issues related to Studio connections, improving reliability for VS Code or language-server integrations. (7.2.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.2.0)
- Allows the env helper's type definition to work with interface-based generics without an index signature. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Treats the peer dependency as external during instrumentation to prevent duplicate bundled copies. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Fixes TypeScript issues involving client runtime utilities in pnpm monorepos. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Adds compatibility with Prisma 7 for the read-replicas extension. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- The read-replicas extension now supports Prisma 7 and can be installed at its latest version. (7.1.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.1.0)
- Prisma updates the underlying better-sqlite3 version to fix a reported issue. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- cockroachdb support is restored in the prisma-client-js generator. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- The exit code regression affecting prisma migrate diff is fixed. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- Prisma Studio no longer has collisions between user and internal columns when querying. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- Prisma Studio fixes issue 1363. (7.0.1) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.1)
- The prisma.config.ts file must be placed at the project root. (7.0.0) — [upgrade guide](https://github.com/prisma/docs/blob/866b345a0371e14ff86228a59f0925f81a6a3ddb/apps/docs/content/docs/guides/upgrade-prisma-orm/v7.mdx), [upgrade guide](https://www.prisma.io/docs/guides/upgrade-prisma-orm/v7)
- Prisma no longer shims WeakRef in Cloudflare Workers, avoiding unexpected memory leaks. (7.0.0) — [release notes](https://github.com/prisma/orm/releases/tag/7.0.0)

## prisma 6

### Breaking changes

- Prisma v7 preparation moves the generator provider from prisma-client-js to prisma-client. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- Projects can define their datasource directly in prisma.config.ts; any datasource in schema.prisma is ignored. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)

### New APIs and options

- The datasource key is available in prisma.config.ts ahead of Prisma v7. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- The engine key is available in prisma.config.ts ahead of Prisma v7. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- Prisma Postgres connection strings can enable connection pooling with pool=true. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- Unified Prisma Config is available for project configuration ahead of Prisma v7. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- Prisma Postgres Console now shows total egress, average response size, and average query duration. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)
- prisma.config.ts supports js or classic engine types, with classic required for Prisma v7. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)
- A new env helper function can be imported from prisma/config for configuration values. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)
- Prisma supports multiple instances configured with different providers. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)
- prisma init now creates a prisma.config.ts file automatically for new projects. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)

### Behavior and default changes

- Naming conventions for fields and relation fields are aligned. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- Bytes maps to Uint8Array depending on the TypeScript version. (6.18.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.18.0)

### Tooling

- Generated client files now include Biome ignore comments. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- The VS Code extension supports using a local Prisma Postgres database without logging in. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)

### Fixes and other changes

- Fixes Prisma Accelerate support in some edge runtime configurations when the @prisma/client/edge entrypoint is not being used. (6.19.2) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.2)
- Fixes incorrectly reported empty diffs caused by a diffing bug introduced in Prisma 6.13.1. (6.19.1) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.1)
- Dropping a model no longer appends the default schema to the migration. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)
- An empty previewFeatures suggestion now results in an empty array value. (6.19.0) — [release notes](https://github.com/prisma/orm/releases/tag/6.19.0)