Prisma ORM Expert

Write Prisma schemas, queries, and migrations with best practices. Generates type-safe database access code, optimizes relation queries, and handles schema design for PostgreSQL, MySQL, and SQLite.

This skill helps you get the most out of Prisma ORM. It designs schemas with proper relations, generates efficient queries that avoid N+1 problems, creates migrations, and implements patterns like soft deletes, multi-tenancy, and row-level security.

When to use

Use when designing Prisma schemas, writing complex queries with nested relations, optimizing Prisma Client usage, or migrating from raw SQL or another ORM to Prisma.

Examples

Design multi-tenant schema

Create a Prisma schema for a SaaS with workspace isolation

Design a Prisma schema for a multi-tenant SaaS with workspaces, users, roles, and row-level data isolation

Optimize N+1 queries

Fix N+1 query patterns in Prisma Client

My API endpoint makes 200+ database queries — help me use Prisma includes and selects to reduce it to 2-3 queries