Database features matrix (Prisma ORM v6) (/docs/orm/v6/reference/database-features)

For the complete Prisma documentation index, see llms.txt. A markdown version of any docs page is available by appending .md to its URL.

Learn which database features are supported in Prisma ORM and how they map to the different Prisma ORM tools.

Location: ORM > v6 > Reference > Database features matrix

This page gives an overview of the features which are provided by the databases that Prisma ORM supports. Additionally, it explains how each of these features can be used in Prisma ORM with pointers to further documentation.

This section describes which database features exist on the relational databases that are currently supported by Prisma ORM. The Prisma schema column indicates how a certain feature can be represented in the Prisma schema and links to its documentation. Note that database features can be used in Prisma Client even though they might not yet be representable in the Prisma schema.

[!NOTE] These features are only for relational databases. Supported features for NoSQL databases, like MongoDB, can be found below.

* Caveats apply when using the UNIQUE constraint with Microsoft SQL Server † Only supported in MySQL in version 8 and higher. ‡ Only supported in PostgreSQL.

* RESTRICT is not supported in Microsoft SQL Server.

Algorithm specified via USING:

• * Not supported for MySQL and SQLite
• † Available with the PostgreSQL connector only in Prisma ORM versions 4.0.0 and later.

• * Not supported by Microsoft SQL Server
• † JSON and Enum types are supported in SQLite as of Prisma ORM 6.2.0.
• ‡ Not supported by SQLite

This section describes which database features exist on the NoSQL databases that are currently supported by Prisma ORM.

The following table lists common MongoDB features and describes the level of support offered by Prisma ORM:

• Connection URLs: Learn about the format and syntax Prisma ORM uses for defining database connection URLs for PostgreSQL, MySQL and SQLite.
• Environment variables reference: This page gives an overview of all environment variables available for use.
• Error message reference: Prisma Client, Migrate, Introspection error message reference
• Preview features: Previews are typically available behind a feature flag or require some form of opt-in.
• Prisma CLI reference: This page gives an overview of all available Prisma CLI commands, explains their options and shows numerous usage examples.