Prisma Client & Prisma schema

When we release a new Prisma Client or Prisma schema feature, it often starts in Preview so that you can test it and submit your feedback. After we improve the feature with your feedback and are satisfied with the internal test results, we promote the feature to general availability.

For more information, see ORM releases and maturity levels.

Currently active Preview features

The following Preview feature flags are available for Prisma Client and Prisma schema:

FeatureReleased into PreviewFeedback issue
fullTextSearch
fullTextIndex
metrics
tracing
postgresqlExtensions
deno
views
driverAdapters
relationJoins
nativeDistinct

To enable a Preview feature, add the feature flag to the generator block in your schema.prisma file. .

Enabling a Prisma Client Preview feature

To enable a Prisma Client Preview feature:

  1. Add the Preview feature flag to the generator block:

    generator client {
    provider = "prisma-client-js"
    previewFeatures = ["fullTextSearch"]
    }
  2. Re-generate Prisma Client:

    $npx prisma generate
  3. If you are using Visual Studio Code and the Preview feature is not available in your .ts file after generating Prisma Client, run the TypeScript: Restart TS server command.

Preview features promoted to general availability

In the list below, you can find a history of Prisma Client and Prisma schema features that were in Preview and are now in general availability. The features are sorted by the most recent version in which they were promoted to general availability.

FeatureReleased into PreviewReleased into General Availability
jsonProtocol
extendedWhereUnique
fieldReference
clientExtensions
filteredRelationCount
orderByNulls
referentialIntegrity
interactiveTransactions
  • with Prisma Accelerate
extendedIndexes
filterJson
improvedQueryRaw
cockroachdb
  • migrations in CockroachDB in
mongodb
  • introspection of MongoDB in
  • introspection of embedded documents in
  • MongoDB embedded documents in
  • introspection of embedded documents in
  • raw query support for MongoDB in
  • filters in embedded documents as an Experimental Feature in
  • order by embedded documents in
microsoftSqlServer
namedConstraints
referentialActions
orderByAggregateGroup
orderByRelation
  • order by aggregates of relations in
selectRelationCount
napi
groupBy
createMany
nativeTypes
uncheckedScalarInputs
transactionApi
connectOrCreate
atomicNumberOperations
insensitiveFilters (PostgreSQL)
middlewares
aggregateApi
distinct