npm · #3659

@prisma/client

Prisma Client is an auto-generated, type-safe and modern JavaScript/TypeScript ORM for Node.js that's tailored to your data. Supports PostgreSQL, CockroachDB, MySQL, MariaDB, SQL Server, SQLite & MongoDB databases.

Last release 2 days ago
25 Aug 2026
Ships fairly regularly
a new release about every 1 weeks
Nearly every release is documented
notes for 60 of the last 60 stable releases
3 versions withdrawn
withdrawn after publishing
7 years old
10652 releases · first in 2020

Release timeline

10652 releases since 2020

2020202120222023202420252026

Releases

7.2.017 Dec 2025
Release notes
Today, we are excited to share the 7.2.0 stable release 🎉

🌟 Star this repo for notifications about new releases, bug fixes & features — or follow us on X!

Highlights

ORM
- #28830: feat: add sqlcommenter-query-insights plugin
  - Adds a new SQL commenter plugin to support query insights metadata.
- #28860: feat(migrate): add -url param for db pull, db push, migrate dev
  - Adds a -url flag to key migrate commands to make connection configuration more flexible.
- #28895: feat(config): allow undefined URLs in e.g. prisma generate
  - Allows certain workflows (such as prisma generate) to proceed even when URLs are undefined.
- #28903: feat(cli): customize prisma init based on the JS runtime (Bun vs others)
  - Makes prisma init tailor generated setup depending on whether the runtime is Bun or another JavaScript runtime.
- #28846: fix(client-engine-runtime): make DataMapperError a UserFacingError
  - Ensures DataMapperError is surfaced as a user-facing error for clearer, more actionable error reporting.
- #28849: fix(adapter-{pg,neon,ppg}): handle 22P02 error in Postgres
  - Improves Postgres adapter error handling for invalid-text-representation errors (22P02).
- #28913: fix: fix byte upserts by removing legacy byte array representation
  - Fixes byte upsert behavior by removing a legacy byte-array representation path.
- #28535: fix(client,internals,migrate,generator-helper): handle multibyte UTF-8 characters split across chunk boundaries in byline
  - Prevents issues when multibyte UTF-8 characters are split across chunk boundaries during line processing.
- #28911: fix(cli): make prisma version --json emit JSON only to stdout
  - Ensures machine-readable JSON output is emitted cleanly to stdout without extra noise.
VS Code Extension
- #1950: fix: TML-1670 studio connections
  - Resolves issues related to Studio connections, improving reliability for VS Code or language-server integrations.
Open roles at Prisma

Interested in joining Prisma? We’re growing and have several exciting opportunities across the company for developers who are passionate about building with Prisma. Explore our open positions on our [Careers page](https://www.prisma.io/careers#current) and find the role that’s right for you.

Enterprise support

Thousands of teams use Prisma and many of them already tap into our Enterprise & Agency Support Program for hands-on help with everything from schema integrations and performance tuning to security and compliance.

With this program you also get priority issue triage and bug fixes, expert scalability advice, and custom training so that your Prisma-powered apps stay rock-solid at any scale. Learn more or join: https://prisma.io/enterprise.
Open source →
7.2.0-integration-fix-sqlite-deadlock-fix.28 Dec 2025pre-release
Nothing published for this version
7.2.0-integration-fix-sqlite-deadlock-fix.18 Dec 2025pre-release
Nothing published for this version
7.2.0-integration-fix-enums-mapped-types-v7.28 Dec 2025pre-release
Nothing published for this version
7.2.0-integration-fix-enums-mapped-types-v7.18 Dec 2025pre-release
Nothing published for this version
7.2.0-integration-engines-7-2-0-3-aqrln-zpupkzknszlw-04d61c41ec1a025cabe14093fa3121a5f45040ab.112 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2716 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2616 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2516 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2416 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2316 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2216 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2116 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.2015 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1915 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1815 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1715 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1612 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1512 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1411 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1311 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1211 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1110 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.1010 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.99 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.89 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.78 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.35 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.24 Dec 2025pre-release
Nothing published for this version
7.2.0-dev.14 Dec 2025pre-release
Nothing published for this version
7.1.1-dev.28 Dec 2025pre-release
Nothing published for this version
7.1.1-dev.15 Dec 2025pre-release
Nothing published for this version
7.1.03 Dec 2025
Release notes
Today, we are excited to share the 7.1.0 stable release 🎉

🌟 Star this repo for notifications about new releases, bug fixes & features — or follow us on X!

This release brings quality of life improvements and fixes various bugs.

Prisma ORM
- #28735: pnpm monorepo issues with prisma client runtime utils Resolves issues in pnpm monorepos where users would report TypeScript issues related to @prisma/client-runtime-utils.
- #28769: implement sql commenter plugins for Prisma Client This PR implements support for SQL commenter plugins to Prisma Client. The feature will allow users to add metadata to SQL queries as comments following the sqlcommenter format.
  
  Here’s two related PRs that were also merged:
  - #28796: implement query tags for SQL commenter plugin
  - #28802: add traceContext SQL commenter plugin
- #28737: added error message when constructing client without configs This commit adds an additional error message when trying to create a new PrismaClient instance without any arguments. Thanks to @xio84 for this community contribution!
- #28820: mark @opentelemetry/api as external in instrumentation Ensures @opentelemetry/api is treated as an external dependency rather than bundled. Since it is a peer dependency, this prevents applications from ending up with duplicate copies of the package.
- #28694: allow env() helper to accept interface-based generics Updates the env() helper’s type definition so it works with interfaces as well as type aliases. This removes the previous constraint requiring an index signature and resolves TS2344 errors when using interface-based env types. Runtime behavior is unchanged. Thanks to @SaubhagyaAnubhav for this community contribution!
Read Replicas extension
- #53: Add support for Prisma 7 Users of the read-replicas extension can now use the extension in Prisma v7. You can update by installing:
```
npm install @prisma/extension-read-replicas@latest
```
  For folks still on Prisma v6, install version 0.4.1:
```
npm install @prisma/[email protected]
```
For more information, visit the repo

SQL comments

We're excited to announce SQL Comments support in Prisma 7.1.0! This new feature allows you to append metadata to your SQL queries as comments, making it easier to correlate queries with application context for improved observability, debugging, and tracing.

SQL comments follow the sqlcommenter format developed by Google, which is widely supported by database monitoring tools. With this feature, your SQL queries can include rich metadata:
```
SELECT "id", "name" FROM "User" /*application='my-app',traceparent='00-abc123...-01'*/
```
Basic usage

Pass an array of SQL commenter plugins to the new comments option when creating a PrismaClient instance:
```
import { PrismaClient } from './generated/prisma/client';
import { PrismaPg } from '@prisma/adapter-pg';
import { queryTags } from '@prisma/sqlcommenter-query-tags';
import { traceContext } from '@prisma/sqlcommenter-trace-context';

const adapter = new PrismaPg({
  connectionString: `${process.env.DATABASE_URL}`,
});

const prisma = new PrismaClient({
  adapter,
  comments: [queryTags(), traceContext()],
});
```
Query tags

The @prisma/sqlcommenter-query-tags package lets you add arbitrary tags to queries within an async context:
```
import { queryTags, withQueryTags } from '@prisma/sqlcommenter-query-tags';

const prisma = new PrismaClient({
  adapter,
  comments: [queryTags()],
});

// Wrap your queries to add tags
const users = await withQueryTags(
  { route: '/api/users', requestId: 'abc-123' },
  () => prisma.user.findMany(),
);
```
Resulting SQL:
```
SELECT ... FROM "User" /*requestId='abc-123',route='/api/users'*/
```
Use withMergedQueryTags to merge tags with outer scopes:
```
import {
  withQueryTags,
  withMergedQueryTags,
} from '@prisma/sqlcommenter-query-tags';

await withQueryTags({ requestId: 'req-123', source: 'api' }, async () => {
  await withMergedQueryTags(
    { userId: 'user-456', source: 'handler' },
    async () => {
      // Queries here have: requestId='req-123', userId='user-456', source='handler'
      await prisma.user.findMany();
    },
  );
});
```
Trace context

The @prisma/sqlcommenter-trace-context package adds W3C Trace Context (traceparent) headers for distributed tracing correlation:
```
import { traceContext } from '@prisma/sqlcommenter-trace-context';

const prisma = new PrismaClient({
  adapter,
  comments: [traceContext()],
});
```
When tracing is enabled and the span is sampled:
```
SELECT * FROM "User" /*traceparent='00-0af7651916cd43dd8448eb211c80319c-b9c7c989f97918e1-01'*/
```
Note: Requires @prisma/instrumentation to be configured. The traceparent is only added when tracing is active and the span is sampled.

Custom plugins

Create your own plugins to add custom metadata:
```
import type { SqlCommenterPlugin } from '@prisma/sqlcommenter';

const applicationTags: SqlCommenterPlugin = (context) => ({
  application: 'my-service',
  environment: process.env.NODE_ENV ?? 'development',
  operation: context.query.action,
  model: context.query.modelName,
});

const prisma = new PrismaClient({
  adapter,
  comments: [applicationTags],
});
```
Framework integration

SQL comments work seamlessly with popular frameworks, e.g., Hono:
```
import { createMiddleware } from 'hono/factory';
import { withQueryTags } from '@prisma/sqlcommenter-query-tags';

app.use(
  createMiddleware(async (c, next) => {
    await withQueryTags(
      {
        route: c.req.path,
        method: c.req.method,
        requestId: c.req.header('x-request-id') ?? crypto.randomUUID(),
      },
      () => next(),
    );
  }),
);
```
Additional framework examples for Express, Koa, Fastify, and NestJS are available in the documentation.

For complete documentation, see SQL Comments. We'd love to hear your feedback on this feature! Please open an issue on GitHub or join the discussion in our Discord community.

Open roles at Prisma

Interested in joining Prisma? We’re growing and have several exciting opportunities across the company for developers who are passionate about building with Prisma. Explore our open positions on our Careers page and find the role that’s right for you.

Enterprise support

Thousands of teams use Prisma and many of them already tap into our Enterprise & Agency Support Program for hands-on help with everything from schema integrations and performance tuning to security and compliance.

With this program you also get priority issue triage and bug fixes, expert scalability advice, and custom training so that your Prisma-powered apps stay rock-solid at any scale. Learn more or join: https://prisma.io/enterprise.
Open source →
7.1.0-integration-fix-fix-missing-cockroach-wasm.225 Nov 2025pre-release
Nothing published for this version
7.1.0-integration-fix-fix-missing-cockroach-wasm.124 Nov 2025pre-release
Nothing published for this version
7.1.0-integration-engines-7-1-0-1-fix-broken-links-4f977cbccf35d76bd3516f82bb56758fe51d4e5e.120 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.393 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.383 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.373 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.363 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.353 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.342 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.332 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.322 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.312 Dec 2025pre-release
Nothing published for this version
7.1.0-dev.3028 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2928 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2828 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2727 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2627 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2527 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2427 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2327 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2227 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2126 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.2026 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.1926 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.1825 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.1725 Nov 2025pre-release
Nothing published for this version
7.1.0-dev.1625 Nov 2025pre-release
Nothing published for this version

@prisma/client

Release timeline

Releases

Highlights

ORM

VS Code Extension

Open roles at Prisma

Enterprise support

Prisma ORM

Read Replicas extension

SQL comments

Basic usage

Query tags

Trace context

Custom plugins

Framework integration

Open roles at Prisma

Enterprise support