Prisma

What is Prisma?

Prisma is a next-generation ORM that consists of Prisma Client (auto-generated type-safe query builder for Node.js/TypeScript), Prisma Migrate (declarative data modeling & migration system), and Prisma Studio (GUI to view and edit database data). It is designed for any Node.js or TypeScript backend application, including serverless and microservices.

How to use Prisma?

Install the @prisma/client npm package, which invokes prisma generate. Define a Prisma schema file with a data source, generator, and data model. Then import and instantiate PrismaClient in your code to send queries to your database.

Key features of Prisma

• Auto-generated, fully type-safe query builder for Node.js & TypeScript
• Declarative data modeling and migration system
• Visual GUI (Prisma Studio) to view and edit data
• Supports PostgreSQL, SQLite, and existing databases via introspection
• Extensible with Prisma Accelerate, Optimize, and Studio
• Works with REST, GraphQL, gRPC, and other API stacks

Use cases of Prisma

• Building type-safe REST or GraphQL APIs backed by a database
• Developing serverless applications with database access
• Prototyping applications with Prisma Postgres or SQLite
• Adding Prisma to an existing project with a custom database

FAQ from Prisma

What databases does Prisma support?

Prisma supports PostgreSQL, SQLite, and can work with existing databases via introspection. Quickstarts are available for Prisma Postgres and SQLite.

Does Prisma work with TypeScript?

Yes, Prisma Client provides full type-safety for all queries when using