Prisma (Database ORM)

Overview

Prisma is a next-generation ORM with auto-generated TypeScript types from your database schema. Define models in schema.prisma, run migrations, get fully typed queries.

Version: Prisma 6.x/7.x (2024-2025)
Prisma 7 Changes: ES module by default, prisma.config.ts, middleware deprecated

Key Benefit: Change schema → regenerate client → TypeScript errors show everywhere you need updates.

When to Use This Skill

✅ Use Prisma when:

• Building TypeScript backend with PostgreSQL/MySQL/SQLite
• Need type-safe database queries
• Want declarative schema with migrations
• Working with relational data and relations
• Building APIs with tRPC (perfect pair)