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:

Feature	Released into Preview	Feedback issue
fullTextSearch	2.30.0	Submit feedback
fullTextIndex	3.6.0	Submit feedback
metrics	3.15.0	Submit feedback
tracing	4.2.0	Submit feedback
multiSchema	4.3.0	Submit feedback
postgresqlExtensions	4.5.0	Submit feedback
deno	4.5.0	Submit feedback
views	4.9.0	Submit feedback
driverAdapters	5.4.0	Submit feedback
relationJoins	5.7.0	Submit feedback
nativeDistinct	5.7.0	Submit feedback
omitApi	5.13.0	Submit feedback
prismaSchemaFolder	5.15.0	Submit feedback
typedSql	5.19.0	Submit feedback
strictUndefinedChecks	5.20.0	Submit feedback

To enable a Preview feature, add the feature flag to the generator block in your schema.prisma file. Share your feedback on all Preview features on GitHub.

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.

Feature	Released into Preview	Released into General Availability
jsonProtocol	4.11.0	5.0.0
extendedWhereUnique	4.5.0	5.0.0
fieldReference	4.3.0	5.0.0
clientExtensions	4.7.0	4.16.0
filteredRelationCount	4.3.0	4.16.0
orderByNulls	4.1.0	4.16.0
referentialIntegrity	3.1.1	4.7.0
interactiveTransactions	2.29.0	4.7.0 with Prisma Accelerate 5.1.1
extendedIndexes	3.5.0	4.0.0
filterJson	2.23.0	4.0.0
improvedQueryRaw	3.14.0	4.0.0
cockroachdb	3.9.0 migrations in CockroachDB in 3.11.0	3.14.0
mongodb	2.27.0 introspection of MongoDB in 3.2.0 introspection of embedded documents in 3.4.0 MongoDB embedded documents in 3.10.0 introspection of embedded documents in 3.10.0 raw query support for MongoDB in 3.9.0 filters in embedded documents as an Experimental Feature in 3.11.0 order by embedded documents in 3.11.0	3.12.0
microsoftSqlServer	2.10.0	3.0.1
namedConstraints	2.29.0	3.0.1
referentialActions	2.26.0	3.0.1
orderByAggregateGroup	2.21.0	3.0.1
orderByRelation	2.16.0 order by aggregates of relations in 2.19.0	3.0.1
selectRelationCount	2.20.0	3.0.1
napi	2.20.0	3.0.1
groupBy	2.14.0	2.20.0
createMany	2.16.0	2.20.0
nativeTypes	2.11.0	2.17.0
uncheckedScalarInputs	2.11.0	2.15.0
transactionApi	2.1.0	2.11.0
connectOrCreate	2.1.0	2.11.0
atomicNumberOperations	2.6.0	2.10.0
insensitiveFilters (PostgreSQL)	2.5.0	2.8.0
middlewares	2.3.0	2.5.0
aggregateApi	2.2.0	2.5.0
distinct	2.3.0	2.5.0