PackageTrack

npm · #3659

@prisma/client

7.10.0prisma/prisma ↗

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.

Release timeline

10652 releases since 2020
2020202120222023202420252026

Releases

  1. 6.15.0-integration-fix-prisma-client-dirname-aws-lambda.119 Aug 2025pre-release

    Nothing published for this version

  2. 6.15.0-integration-feat-prisma-client-default-runtime.122 Aug 2025pre-release

    Nothing published for this version

  3. 6.15.0-dev.3027 Aug 2025pre-release

    Nothing published for this version

  4. 6.15.0-dev.2927 Aug 2025pre-release

    Nothing published for this version

  5. 6.15.0-dev.2826 Aug 2025pre-release

    Nothing published for this version

  6. 6.15.0-dev.2726 Aug 2025pre-release

    Nothing published for this version

  7. 6.15.0-dev.2622 Aug 2025pre-release

    Nothing published for this version

  8. 6.15.0-dev.2522 Aug 2025pre-release

    Nothing published for this version

  9. 6.15.0-dev.2422 Aug 2025pre-release

    Nothing published for this version

  10. 6.15.0-dev.2321 Aug 2025pre-release

    Nothing published for this version

  11. 6.15.0-dev.2221 Aug 2025pre-release

    Nothing published for this version

  12. 6.15.0-dev.2121 Aug 2025pre-release

    Nothing published for this version

  13. 6.15.0-dev.2021 Aug 2025pre-release

    Nothing published for this version

  14. 6.15.0-dev.1921 Aug 2025pre-release

    Nothing published for this version

  15. 6.15.0-dev.1821 Aug 2025pre-release

    Nothing published for this version

  16. 6.15.0-dev.1721 Aug 2025pre-release

    Nothing published for this version

  17. 6.15.0-dev.1621 Aug 2025pre-release

    Nothing published for this version

  18. 6.15.0-dev.1520 Aug 2025pre-release

    Nothing published for this version

  19. 6.15.0-dev.1420 Aug 2025pre-release

    Nothing published for this version

  20. 6.15.0-dev.1320 Aug 2025pre-release

    Nothing published for this version

  21. 6.15.0-dev.1219 Aug 2025pre-release

    Nothing published for this version

  22. 6.15.0-dev.1119 Aug 2025pre-release

    Nothing published for this version

  23. 6.15.0-dev.1019 Aug 2025pre-release

    Nothing published for this version

  24. 6.15.0-dev.919 Aug 2025pre-release

    Nothing published for this version

  25. 6.15.0-dev.819 Aug 2025pre-release

    Nothing published for this version

  26. 6.15.0-dev.718 Aug 2025pre-release

    Nothing published for this version

  27. 6.15.0-dev.618 Aug 2025pre-release

    Nothing published for this version

  28. 6.15.0-dev.518 Aug 2025pre-release

    Nothing published for this version

  29. 6.15.0-dev.415 Aug 2025pre-release

    Nothing published for this version

  30. 6.15.0-dev.315 Aug 2025pre-release

    Nothing published for this version

  31. 6.15.0-dev.215 Aug 2025pre-release

    Nothing published for this version

  32. 6.15.0-dev.113 Aug 2025pre-release

    Nothing published for this version

  33. 6.14.012 Aug 2025
    Release notes

    Today, we are excited to share the 6.14.0 stable release 🎉

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

    Highlights

    @unique attributes for SQL views (Preview)

    Last release, we improved the robustness of SQL views defined in the Prisma schema. Views are virtual tables that don't allows for defining unique constraints, indexes or foreign keys in the underlying database.

    However, as an application developer, it can be convenient to also define relationships involving views or paginate them using cursors. We've received this feedback from several people who had been using views in that way with Prisma ORM, so in this release we're re-introducing the @unique attribute for views. This attribute enables:

    • relationships involving views
    • findUnique queries, cursor-based pagination & implicit ordering for views

    Here's an example schema using @unique and defining a relationship from a model to a view:

    model User {
  id        Int            @id @default(autoincrement())
  email     String         @unique
  posts     Post[]
  stats     UserPostStats? @relation(fields: [email], references: [userEmail])
}

model Post {
  id        Int      @id @default(autoincrement())
  title     String
  published Boolean  @default(false)
  createdAt DateTime @default(now())
  authorId  Int?
  author    User?    @relation(fields: [authorId], references: [id])
}

view UserPostStats {
  userEmail        String    @unique
  totalPosts       BigInt?
  publishedPosts   BigInt?
  unpublishedPosts BigInt?
  latestPostDate   DateTime? @db.Timestamp(6)
  user             User?
}

    <details><summary>Expand to view the SQL code for this view</summary>

    CREATE OR REPLACE VIEW "UserPostStats" AS
SELECT 
    u.email AS "userEmail",
    u.name AS "userName",
    COUNT(p.id) AS "totalPosts",
    COUNT(CASE WHEN p.published = true THEN 1 END) AS "publishedPosts",
    COUNT(CASE WHEN p.published = false THEN 1 END) AS "unpublishedPosts",
    MAX(p."createdAt") AS "latestPostDate"
FROM "User" u
LEFT JOIN "Post" p ON u.id = p."authorId"
GROUP BY u.id, u.email, u.name;

    </details>

    You can now query this view and its relationship using include:

    const userPostStats = await prisma.userPostStats.findMany({
  include: {
    user: true,
  }
})

    📚 Learn more in the docs.

    Various fixes & stability improvements

    • Fixed several issues related to new prisma-client generator and the queryCompiler Preview feature (aka “Prisma Client without Rust engines”). Both will become the default in the upcoming Prisma 7 release and we're working hard on bringing these features into General Availability. You can try them out with your favorite stack with our ready-to-run examples.
    • Fixed several regressions, e.g. related to Prisma Config
    • Removed middleware from Prisma Client (i.e. the prisma.$use method), which was deprecated since v4.16.0. Use Prisma Client extensions instead.
    • Deprecated metrics Preview feature (which will be removed in Prisma 7)

    Improved type performance

    In this release, we also addressed some type performance issues that led to slower editors and lagging auto-complete. If you're curious about the details, you can check the description and changes in this PR.

    Other news

    Increased robustness of Management API (Early Access)

    We recently released an API for programmatically managing Prisma Postgres instances that's perfect for CI/CD workflows and scripting.

    In this release, we made it more robust and are bringing it closer to its General Availability release.

    Revoke OAuth tokens in Prisma Console

    If you use OAuth to authorize third-party applications to act on your behalf in the Prisma Console, you can now revoke any app's access at any time. The Prisma Console shows a list of your authorized (connected) apps, and you can easily remove one to immediately block further access.

    ICYMI

    Last release was huge, so just in case you missed it, here's the TLDR of what we put out last time:

    • Prisma ORM
      • Prisma Config file (prisma.config.ts) is Generally Available – Native way to configure schema paths, migrations, seeds, and more; no need for earlyAccess flag anymore.
      • Multi-schema support is Generally Available – Allows assigning models to different database schemas in Postgres and SQL Server using @@schema.
      • Improved SQL views support (still in Preview) – Adds guardrails for views by disabling unsupported features.
      • Externally managed tables – Lets you exclude specific tables from Prisma Migrate while still querying them via Prisma Client.
    • Prisma Postgres
      • Extension support for Prisma Postgres – Prisma Postgres now supports pgvector, pg_search, pg_stat_statements, citext, pg_trgm, fuzzystrmatch, and unaccent. If you don't see the extension you need, you can request it here. Extensions only work on new instances, if you want to use any of them on your existing instance, reach out to us.
      • Management API for Prisma Postgres – REST API to provision, delete, and manage Prisma Postgres instances programmatically, perfect for CI/CD and scripting workflows.
      • GitHub Actions for Prisma Postgres – Actions for creating and deleting databases in CI/CD workflows, available on GitHub Marketplace.
      • New CLI: npx create-db – Instantly spin up a new Postgres database—no authentication required.
    Open source →
  34. 6.14.0-integration-feat-prisma-client-cjs-fixes.26 Aug 2025pre-release

    Nothing published for this version

  35. 6.14.0-integration-feat-prisma-client-cjs-fixes.15 Aug 2025pre-release

    Nothing published for this version

  36. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.62 Aug 2025pre-release

    Nothing published for this version

  37. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.51 Aug 2025pre-release

    Nothing published for this version

  38. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.41 Aug 2025pre-release

    Nothing published for this version

  39. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.31 Aug 2025pre-release

    Nothing published for this version

  40. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.21 Aug 2025pre-release

    Nothing published for this version

  41. 6.14.0-integration-feat-client-wasm-base64-on-nodejs.11 Aug 2025pre-release

    Nothing published for this version

  42. 6.14.0-integration-engines-6-14-0-23-push-konntwtrzysp-9279378d80744cb329a71a7c98ff1cc7039b45c7.112 Aug 2025pre-release

    Nothing published for this version

  43. 6.14.0-integration-engines-6-14-0-21-push-konntwtrzysp-0e768eccd6709956ac7bcb59cdaf092a0f3d0dc4.111 Aug 2025pre-release

    Nothing published for this version

  44. 6.14.0-integration-engines-6-14-0-10-push-lxtyopotuyqp-22388fea2e3afc80047dd711818db40954b7128c.17 Aug 2025pre-release

    Nothing published for this version

  45. 6.14.0-dev.4412 Aug 2025pre-release

    Nothing published for this version

  46. 6.14.0-dev.4312 Aug 2025pre-release

    Nothing published for this version

  47. 6.14.0-dev.4212 Aug 2025pre-release

    Nothing published for this version

  48. 6.14.0-dev.4112 Aug 2025pre-release

    Nothing published for this version

  49. 6.14.0-dev.4012 Aug 2025pre-release

    Nothing published for this version

  50. 6.14.0-dev.3912 Aug 2025pre-release

    Nothing published for this version

  51. 6.14.0-dev.3812 Aug 2025pre-release

    Nothing published for this version

  52. 6.14.0-dev.3711 Aug 2025pre-release

    Nothing published for this version

  53. 6.14.0-dev.3611 Aug 2025pre-release

    Nothing published for this version

  54. 6.14.0-dev.3511 Aug 2025pre-release

    Nothing published for this version

  55. 6.14.0-dev.3411 Aug 2025pre-release

    Nothing published for this version

  56. 6.14.0-dev.3311 Aug 2025pre-release

    Nothing published for this version

  57. 6.14.0-dev.3211 Aug 2025pre-release

    Nothing published for this version

  58. 6.14.0-dev.3111 Aug 2025pre-release

    Nothing published for this version

  59. 6.14.0-dev.3011 Aug 2025pre-release

    Nothing published for this version

  60. 6.14.0-dev.298 Aug 2025pre-release

    Nothing published for this version