Database Features (Prisma ORM v7) (/docs/orm/v7/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.

Database features supported in Prisma ORM

Location: ORM > v7 > Reference > Database Features

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:

• Config API: Complete reference for prisma.config.ts configuration options
• Connection URLs: Learn about the format and syntax Prisma ORM uses for defining database connection URLs for PostgreSQL, MySQL and SQLite
• Environment Variables: Reference for Prisma environment variables
• Error Reference: Prisma Client, Migrate, and Introspection error codes
• Prisma CLI reference: This page gives an overview of all available Prisma CLI commands, explains their options and shows numerous usage examples