Prisma ORM Setup

Add Prisma ORM to your Node.js project. Schema definition, migration and CRUD operations.

Intermediate20 min

Setup Steps

1. Add Prisma to your project:

npm install prisma --save-dev
npm install @prisma/client

2. Initialize Prisma:

npx prisma init

3. Set the database connection in .env:

DATABASE_URL="mysql://user:password@localhost:3306/database"

4. Define a model in prisma/schema.prisma:

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())
}

model Post {
  id        Int      @id @default(autoincrement())
  title     String
  content   String?  @db.Text
  author    User     @relation(fields: [authorId], references: [id])
  authorId  Int
}

5. Create a migration:

npx prisma migrate dev --name init

6. Prisma Client usage:

javascript
import { PrismaClient } from '@prisma/client'
const prisma = new PrismaClient()
const users = await prisma.user.findMany()
const newUser = await prisma.user.create({ data: { email: 'a@b.com', name: 'Ali' } })

7. Prisma Studio (visual database management):

npx prisma studio

Related Guides

MySQL Database Setup

Install MySQL database server, secure it and learn basic operations.

PostgreSQL Setup

Install and configure PostgreSQL database server.

MongoDB Setup

Install MongoDB NoSQL database and learn basic CRUD operations.

Redis Setup

Install Redis in-memory data store. Caching and session management.