Can it help fix migration drift in production?

Yes, it provides specific diagnosis commands like 'prisma migrate status' and offers resolution strategies using 'migrate resolve' to synchronize your schema without data loss.

Does it support connection pooling for Vercel or AWS Lambda?

Absolutely. It includes patterns for global Prisma Client instantiation and connection limit configurations specifically designed for serverless environments to prevent database exhaustion.

How does this skill handle N+1 query problems?

The skill analyzes your Prisma Client usage and recommends optimized query patterns using 'include' for relation fetching or 'select' for specific field requirements to reduce database round-trips.

Which database providers are supported?

The skill is optimized for PostgreSQL, MySQL, and SQLite, providing provider-specific syntax and optimization strategies for each.

Prisma ORM Expert

Name: Prisma ORM Expert
Author: claudiodearaujo

byclaudiodearaujo

•

Database Management

Optimizes Prisma ORM workflows through expert schema design, migration management, and high-performance query tuning.

The Prisma Expert skill provides comprehensive guidance for developers working with the Prisma ORM across PostgreSQL, MySQL, and SQLite. It automates the diagnosis of common database issues such as migration drift, N+1 query patterns, and connection pool exhaustion. By applying progressive fix strategies—from minimal relation adjustments to complete schema normalization—this skill ensures your database layer is scalable, type-safe, and highly performant while offering specific playbooks for transaction management and serverless deployment.

Key Features

01Migration conflict resolution and production deployment safety

02Connection pool management for serverless and high-traffic apps

03Automated schema validation and relation modeling

04Advanced transaction pattern implementation and debugging

05N+1 query detection and optimization with select/include

061 GitHub stars

Use Cases

01Resolving failed production migrations using safe rollback strategies

02Optimizing slow application performance by identifying unindexed fields

03Refactoring complex database schemas with explicit many-to-many relations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro prisma-expert

For use in Claude.ai and ChatGPT

Download Skill