Which databases does the Prisma Expert skill support?

The skill provides deep expertise for PostgreSQL, MySQL, and SQLite, tailoring recommendations to the specific provider used in your Prisma schema.

Can this skill help solve N+1 query problems?

Yes, it is designed to detect inefficient query patterns and suggest optimizations using 'include', 'select', or raw SQL for complex aggregations.

How does it assist with failed migrations?

It provides a step-by-step diagnosis and resolution path using Prisma CLI commands like 'migrate resolve' or 'migrate reset' to handle drift and conflicts safely.

Does it handle serverless database connection issues?

Absolutely. It includes patterns for managing connection limits and implementing the singleton pattern for Prisma Client in environments like Vercel or AWS Lambda.

Prisma Database Expert

Name: Prisma Database Expert
Author: claudiodearaujo

byclaudiodearaujo

0•

Database Management

Optimizes Prisma ORM workflows including schema design, migrations, query performance, and database connection management.

The Prisma Expert skill empowers Claude to handle complex database tasks with precision, covering everything from initial schema modeling to advanced query optimization and production-safe migrations. It provides automated environment diagnosis, specific playbooks for resolving common anti-patterns like N+1 queries, and guidance on managing connection pools in serverless environments. Whether you are debugging a failed migration or refactoring relations for better performance, this skill ensures best practices are followed across PostgreSQL, MySQL, and SQLite to maintain a healthy and scalable data layer.

Key Features

01Safe migration management and conflict resolution strategies

02Connection pooling and lifecycle management for serverless environments

03Advanced Prisma schema design and relation modeling

04Query performance optimization and N+1 problem detection

05Transaction pattern implementation and deadlock prevention

060 GitHub stars

Use Cases

01Refactoring complex database schemas with explicit relations and indexes

02Optimizing slow database queries using selects, includes, and raw SQL

03Troubleshooting and resolving failed production migrations or schema drift

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill