Prisma 2.0: TypeScript-first ORM with declarative schema

Cloud & Web Apps

Development of modern web applications and APIs, cloud native architectures, containers, CI/CD. End-to-end open source tech stack.

Discover →

Node.js ORM: a gap

The Node ecosystem has historically had problematic ORMs:

• Sequelize — Active Record pattern, TypeScript often “added later”
• TypeORM — decorators, known bugs, slow maintenance
• Mikro-ORM, Objection.js, Knex — niche

A schema-first, type-safe, modern-DX approach is needed.

The release

Prisma 2.0 is released by Prisma Labs (Berlin) on 23 June 2020. Apache 2.0 licence. Founders: Søren Bramer Schmidt, Johannes Schickling. Version 1.x was GraphQL-focused; 2.0 pivots to general-purpose ORM.

Architecture

• Schema DSL (schema.prisma) — declarative definition of models, fields, relations
• Prisma Client — TypeScript client generated from schema
• Prisma Migrate — schema-diff based migrations
• Prisma Studio — GUI for DB browsing

model User {
  id    Int    @id @default(autoincrement())
  email String @unique
  posts Post[]
}

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

const users = await prisma.user.findMany({
  where: { email: { endsWith: '@example.com' } },
  include: { posts: true }
});
// users is typed: User & { posts: Post[] }[]

Features

• End-to-end type safety — types generated from schema, zero manual typing
• Fluent query builder — no raw SQL (though supported with $queryRaw)
• Declarative migrations
• Full auto-complete in IDE
• Nested writes — create related records in one call
• Introspection — generate schema from existing DB (prisma db pull)
• Seed data
• Multi-DB: PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, CockroachDB

Prisma Accelerate & Pulse

Prisma commercial products:

• Accelerate — connection pooling and global cache (Edge-compatible)
• Pulse — real-time change data capture
• Prisma Data Platform — cloud console

Versions

• 2.0 (June 2020) — first stable ORM
• 3.0 (September 2021) — referential actions, PlanetScale support
• 4.0 (June 2022) — Node 14+, MongoDB GA
• 5.0 (July 2023) — Node 16+, performance boost
• 6.0 (November 2024) — Node 18+, Rust → TypeScript query engine migration

Competitors

• Drizzle ORM (2022+) — TypeScript SQL-like, zero-abstraction, Edge-friendly — strong growth
• Kysely — type-safe query builder, no schema
• TypeORM, Sequelize — legacy
• Mikro-ORM — Data Mapper alternative

In the Italian context

Prisma is widely adopted in:

• TypeScript-first Italian startups (fintech, SaaS, AI)
• Node teams migrating from Sequelize/TypeORM
• NestJS projects (via community @nestjs/prisma wrappers)
• Next.js fullstack apps
• Edge runtime (Cloudflare Workers) with Accelerate

Many Italian TypeScript bootcamps teach Prisma as default ORM in 2024-2026.

References: Prisma 2.0 (23 June 2020). Prisma Labs, Berlin. Søren Bramer Schmidt, Johannes Schickling. Apache 2.0 licence. Schema DSL, Client, Migrate, Studio. Multi-DB. Current version 6.x (2024).