• Full type safety
• Smart automated migrations generation
• No ORM learning curve
• SQL-like syntax for table definitions and queries
• Best in class fully typed joins
• Fully typed partial and non-partial selects of any complexity
• Auto-inferring of TS types for DB models for selections and insertions separately
• Zod schema generation
• Zero dependencies

PRISMA SCHEMA

Data model you can read

The Prisma schema is intuitive and lets you declare your database tables in a human-readable way — making your data modeling experience a delight. You define your models by hand or introspect them from an existing database.

PRISMA CLIENT

Type-safe database client

Prisma Client is a query builder that’s tailored to your schema. We designed its API to be intuitive, both for SQL veterans and developers brand new to databases. The auto-completion helps you figure out your query without the need for documentation.

PRISMA MIGRATE

Hassle-free migrations

Prisma Migrate auto-generates SQL migrations from your Prisma schema. These migration files are fully customizable, giving you full control and ultimate flexibility — from local development to production environments.

PRISMA STUDIO

Visual database browser

Prisma Studio is the easiest way to explore and manipulate data in your Prisma projects. Understand your data by browsing across tables, filter, paginate, traverse relations and edit your data with safety.