prisma-expert

What problem does it solve?

This Skill provides expert guidance for Prisma ORM, helping teams design robust database schemas, plan migrations, optimize queries, and model complex relations across PostgreSQL, MySQL, and SQLite.

Core Features & Use Cases

• Schema design and normalization using Prisma schema.prisma with explicit relations.
• Migration planning, execution, and rollback strategies to ensure safe database evolution.
• Query optimization and relation modeling to improve performance and data integrity.
• Diagnostics and tooling guidance for Prisma (validate, migrate diff, format) to maintain healthy schemas.

Quick Start

Create a starter Prisma schema.prisma for a simple blog with User and Post models and a one-to-many relationship; provide basic migrations and a sample query to fetch users with their posts.