Why Developers Choose Prisma?

Prisma is not just another ORM — it’s built with developers in mind. Unlike traditional ORMs, Prisma focuses on productivity, type safety, and ease of use. Here’s why many teams prefer it:

• Type-Safe Queries – Prisma generates a fully type-safe client from your schema. You get instant feedback in your editor and avoid common runtime errors.
• 
  

• Schema-First Approach – Define your data models in schema.prisma. It’s clean, human-readable, and serves as your single source of truth.

• 
  

• Cross-Database Support – Whether you’re using PostgreSQL, MySQL, SQLite, SQL Server, CockroachDB, or MongoDB, Prisma has you covered. Switching databases is seamless.

• 
  

• Auto-Generated Client – Forget writing complex SQL. Prisma gives you an intuitive, auto-generated API to interact with your data.

npm install prisma --save-dev  
npx prisma init  

This creates a schema.prisma file and a .env file for your database connection.

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}
generator client {
  provider = "prisma-client-js"
}
model User {
  id    Int     @id @default(autoincrement())
  name  String
  email String  @unique
  posts Post[]
}
model Post {
  id       Int    @id @default(autoincrement())
  title    String
  content  String?
  author   User   @relation(fields: [authorId], references: [id])
  authorId Int
}

npx prisma migrate dev --name init

import { PrismaClient } from '@prisma/client'

const prisma = new PrismaClient()

async function main() {
  // Create a new user
  const user = await prisma.user.create({
    data: {
      name: "Alice",
      email: "alice@example.com",
      posts: {
        create: { title: "My first post" },
      },
    },
  })

  // Fetch all users with posts
  const users = await prisma.user.findMany({
    include: { posts: true },
  })

  console.log(users)
}

main()

Keep schema.prisma well-structured — it’s your single source of truth.