Supported databases
Prisma currently supports the following databases:
Database | Version |
---|---|
PostgreSQL ¹ | 9.4 |
PostgreSQL ¹ | 9.5 |
PostgreSQL | 9.6 |
PostgreSQL | 10 |
PostgreSQL | 11 |
PostgreSQL | 12 |
PostgreSQL | 13 |
PostgreSQL | 14 |
PostgreSQL | 15 |
MySQL | 5.6 |
MySQL | 5.7 |
MySQL | 8 |
MariaDB | 10 |
SQLite | * |
AWS Aurora | * |
AWS Aurora Serverless ² | * |
Microsoft SQL Server | 2022 |
Microsoft SQL Server | 2019 |
Microsoft SQL Server | 2017 |
Azure SQL | * |
MongoDB | 4.2+ |
CockroachDB | 21.2.4+ |
Note that a fixed version of SQLite is shipped with every Prisma release.
An asterisk (*) indicates that the version number is not relevant; either all versions are supported, there is not a public version number, etc.
¹ PostgreSQL versions 9.4 and 9.5 are not fully supported. You might see errors when you use Prisma Migrate and Introspection. We recommend that you use PostgreSQL version 9.6 or later.
² This does not include support for Data API for Aurora Serverless.
Preview
Support for the following databases is available as a Preview:
Database | Version |
---|---|
PlanetScale | * |
See also: System requirements