What is Prisma ORM?

Prisma is the database ORM (Object-Relational Mapping), offering type-safe database access with zero boilerplate and AI-friendly schema definitions.

Core Features:

1. Schema Definition:

// prisma/schema.prisma
model User {
  id        String   @id @default(cuid())
  email     String   @unique
  name      String?
  posts     Post[]
  createdAt DateTime @default(now())
}

model Post {
  id        String   @id @default(cuid())
  title     String
  content   String?
  author    User     @relation(fields: [authorId], references: [id])
  authorId  String
}

2. Type-Safe Queries:

// Automatic TypeScript types generated
const user = await prisma.user.findUnique({
  where: { email: 'user@example.com' },
  include: { posts: true }
});
// user is fully typed with User & { posts: Post[] }

3. Migrations:

• Automatic migration generation: npx prisma migrate dev
• Version-controlled database schema changes
• Rollback support for production safety

AI-Friendly Design:

Prisma's schema is declarative and human-readable, making it perfect for AI-native development:

• AI tools instantly understand relationships
• Schema modifications are clear and predictable
• Type generation eliminates guesswork
• Query API is self-documenting