Prisma Changelog

Prisma ORM v7.7.0 introduces a new prisma bootstrap command that sequences the full Prisma Postgres setup into a single interactive flow.

Prisma ORM v7.6.0 adds support for prisma postgres link and Studio dark mode.

Prisma ORM v7.5.0 adds support for nested transaction rollback behavior for SQL databases through savepoints.

Prisma ORM v7.4.2 is a patch release focused on bug fixes and quality improvements across Prisma Client, driver adapters, and the Schema Engine.

Prisma ORM v7.4.1 is a patch release focused on bug fixes and quality improvements across Prisma Client, driver adapters, and the Prisma Schema Language.

Prisma ORM v7.4.0 introduces a new caching layer for Prisma Client. In Prisma 7, the query compiler runs as a WebAssembly module directly on the JavaScript main thread.

Fast and Small Query Compilers: Introduced new compilerBuild option for the client generator with two options: fast and small. Allows swapping the underlying Query Compiler engine based on performance vs size trade-offs. Default is fast mode.

Raw Query Optimization: Raw queries ($executeRaw, $queryRaw) now skip the query compiler and query interpreter infrastructure, sending them directly to the driver adapter for reduced overhead.

MSSQL Update: Updated @prisma/adapter-mssql to use MSSQL v12.2.0.

SQLite Fixes: Pinned better-sqlite3 version to avoid SQLite 3.51.0 bug. Users of @prisma/better-sqlite3 should upgrade to v7.3.0.

@map Enum Revert: Reverted @map enums to v6.19.0 behavior due to breaking changes introduced in v7.0.

BigInt JSON Precision: Fixed BigInt precision loss in JSON aggregation by casting BigInt columns to ::text inside JSONB_BUILD_OBJECT calls to preserve full precision when parsed in JavaScript.

ORM Features:

• Added sqlcommenter-query-insights plugin for SQL query insights metadata
• Added -url parameter flag for db pull, db push, and migrate dev commands
• Allow undefined URLs in workflows like prisma generate
• Customized prisma init behavior based on JS runtime (Bun vs others)
• Improved error handling for Postgres adapters (22P02 error)

ORM Fixes:

• Made DataMapperError a user-facing error for clearer reporting
• Fixed byte upserts by removing legacy byte array representation
• Fixed handling of multibyte UTF-8 characters split across chunk boundaries
• Fixed prisma version --json to emit JSON only to stdout
• Migrated CLI dev server startup to startPrismaDevServer API

VS Code Extension:

• Fixed Studio connections issues
• Bumped @prisma/dev dependency and integrated its daemon

Prisma ORM Features:

• Resolved pnpm monorepo issues with @prisma/client-runtime-utils TypeScript conflicts
• Implemented SQL commenter plugins for Prisma Client following the sqlcommenter format
• Implemented query tags for SQL commenter plugin
• Added traceContext SQL commenter plugin
• Improved env() helper to accept interface-based generics, removing constraint on index signatures
• Added error message when constructing PrismaClient without configs
• Marked @opentelemetry/api as external in instrumentation to prevent duplicate package copies

Read Replicas Extension:

• Added support for Prisma 7

SQL Comments Feature: Introduced SQL Comments support in Prisma 7.1.0, allowing metadata to be appended to SQL queries as comments for improved observability, debugging, and tracing. Supports basic usage with plugins like queryTags() and traceContext().

Simplified Prisma ORM runtime options for Prisma Client to be more consistent and easier to understand. Key changes: node has been removed (use runtime = "nodejs"), deno-deploy has been removed (use runtime = "deno"), vercel has been replaced by runtime = "vercel-edge", edge-light is now an alias for vercel-edge. Supported runtimes are now: nodejs, deno, bun, workerd (alias cloudflare), vercel-edge (alias edge-light), and react-native. The VS Code extension has been updated to reflect these changes.