prisma-expert

What problem does it solve?

This Skill addresses complex challenges in Prisma ORM, including schema design, migration failures, query performance bottlenecks, and database connection issues, ensuring robust and efficient database interactions.

Core Features & Use Cases

• Schema Design & Validation: Guides users in creating optimal Prisma schemas, defining relations, and adding indexes.
• Migration Management: Assists in resolving migration conflicts, fixing failed migrations, and deploying database changes safely.
• Query Optimization: Identifies and resolves N+1 problems, over-fetching, and slow queries using Prisma's features and raw SQL.
• Connection & Transaction Handling: Provides strategies for managing database connections and implementing reliable transactions.
• Use Case: A developer is encountering "Too many connections" errors in their application. This Skill can analyze their Prisma connection configuration and suggest optimal pool sizes and connection management strategies for their environment.

Quick Start

Use the prisma-expert skill to help optimize the performance of a slow Prisma query by analyzing the provided query and schema.