Prisma

Prisma 6 (2025) adds multi-schema support and Edge support (Cloudflare Workers) via driver adapters. It is known for its type-safe client.

When to Use

• TypeScript: The PrismaClient generated types are unmatched.
• Relational DBs: Postgres, MySQL, SQL Server.
• Productivity: schema.prisma is an easy-to-read source of truth.

Core Concepts

Schema (schema.prisma)

Defines models and relationships.

Prisma Client

Auto-generated query builder. prisma.user.findMany().