What is Prisma ORM?

Prisma ORM is an open-source next-generation ORM. It consists of the following parts:

• Prisma Client: Auto-generated and type-safe query builder for Node.js & TypeScript
• Prisma Migrate: Migration system
• Prisma Studio: GUI to view and edit data in your database.

Prisma Client can be used in any Node.js (supported versions) or TypeScript backend application (including serverless applications and microservices). This can be a REST API, a GraphQL API, a gRPC API, or anything else that needs a database.

You can build, optimize, and grow your application easily with an intuitive data model, type-safety, automated migrations, connection pooling, caching, and real-time database subscriptions.

GitHub: https://github.com/prisma

Why Prisma ORM?

Working with relational databases is a major bottleneck in application development. Debugging SQL queries or complex ORM objects often consume hours of development time.

Prisma ORM makes it easy for developers to reason about their database queries by providing a clean and type-safe API for submitting database queries which returns plain old JavaScript objects.

TLDR

Prisma ORM's main goal is to make application developers more productive when working with databases. Here are a few examples of how Prisma ORM achieves this:

• Thinking in objects instead of mapping relational data
• Queries not classes to avoid complex model objects
• Single source of truth for database and application models
• Healthy constraints that prevent common pitfalls and anti-patterns
• An abstraction that makes the right thing easy ("pit of success")
• Type-safe database queries that can be validated at compile time
• Less boilerplate so developers can focus on the important parts of their app
• Auto-completion in code editors instead of needing to look up documentation