Prisma ORM Workflow

Overview

Prisma ORM Workflow streamlines database development with Prisma. From schema design to query optimization, this skill helps you build type-safe, performant database layers for your applications.

Key Features

• Schema Design: Creates Prisma schemas with proper model relations (one-to-one, one-to-many, many-to-many), composite indexes, unique constraints, and default values. Uses enums and composite types effectively.
• Query Optimization: Analyzes existing Prisma queries and suggests optimizations — replacing eager loading with selective includes, adding proper indexes for frequently filtered fields, and using raw queries for complex aggregations.
• Advanced Patterns: Implements common database patterns including soft delete with filtered queries, row-level multi-tenancy with Prisma Client extensions, and automatic audit logging.
• Migration Management: Generates clean migrations from schema changes, handles data backfills, and manages the migration history for team collaboration.

Performance

The skill identifies common Prisma performance pitfalls: implicit many-to-many table scans, missing indexes on filtered fields, over-fetching with nested includes, and connection pool exhaustion. Each finding comes with a specific fix.

Prisma Client Extensions

Generates Prisma Client extensions for cross-cutting concerns: query logging, performance monitoring, automatic timestamps, and tenant isolation. Extensions compose cleanly without modifying the base client.