rembSupported databases
Overview
Prisma ORM supports PostgreSQL, MySQL, SQLite, MongoDB, SQL Server, CockroachDB, and serverless databases
Self-hosted
Managed/Serverless
| Database | Notes |
|---|---|
| Neon | Serverless Postgres |
| Supabase | Postgres |
| PlanetScale | MySQL |
| Turso | libSQL (SQLite) |
| Cloudflare D1 (Preview) | SQLite |
| AWS Aurora | MySQL/Postgres |
| MongoDB Atlas | MongoDB |
Constraints
| Feature | PostgreSQL | MySQL | SQLite | SQL Server | MongoDB |
|---|---|---|---|---|---|
| PRIMARY KEY | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| FOREIGN KEY | ✔️ | ✔️ | ✔️ | ✔️ | — |
| UNIQUE | ✔️ | ✔️ | ✔️ | ✔️* | ✔️ |
| NOT NULL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| DEFAULT | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
*SQL Server has limitations with UNIQUE constraints
Data types
| Feature | PostgreSQL | MySQL | SQLite | SQL Server | MongoDB |
|---|---|---|---|---|---|
| Arrays | ✔️ | — | — | — | ✔️ |
| JSON | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Enums | ✔️ | ✔️ | ✔️ | — | ✔️ |
- PostgreSQL — Self-hosted, Neon, Supabase, and CockroachDB
- MySQL/MariaDB — Self-hosted and PlanetScale
- SQLite — Local, Turso, and Cloudflare D1
- SQL Server
- MongoDB
Driver adapters
For custom database drivers, see Driver adapters.