1.1 Data Model

Prisma is a NodeJS and TS ORM toolkit that makes it easy to interact with relational databases like

• PostgreSQL
• MySQL
• MariaDB
• SQLite
• SQL Server

1.2 DB-Agnostic

It has an advantage over libraries such as pg or mongoose by being database agnostic and it provides good types when data is passed or retrieved from databases.

1.3 Type Safety

Prisma generates a type-safe database client based on the Prisma schema.

1.4 Migration

Migration are automatic in prisma.

Prisma’s auto-migrations come from a combination of:

1. Your Prisma Schema (schema.prisma)
2. The Prisma Migrate engine
3. A versioned migrations folder
4. SQL generated automatically based on schema diffs