Prisma is a ORM (Object-Relational Mapping) tool. It helps you interact with your database in a type-safe and developer-friendly way.

Core Components of Prisma

1. Prisma Client
2. Prisma Migrate
3. Prisma Studio

Prisma Client

• This is an auto-generated query builder that is created based on your database schema.
• With it, instead of writing queries directly in the database, you can perform CRUD operations using TypeScript/JavaScript.

Prisma Migrate

A migration tool for your database schema. It allows you to easily make and track schema changes.

Prisma Studio

A browser-based GUI interface where you can view and edit your data.

Prisma Setup for Postgres database

1. Prisma Install

npm install prisma --save-dev

npm install @prisma/client

2. Initialize Prisma

npx prisma init

This creates two files:

• .env (for your database connection string)