Prisma Expert

This is a solid specialist for anyone working with Prisma ORM who needs help beyond the basics. It covers the stuff that actually trips people up: N+1 queries, migration conflicts in team environments, connection pool exhaustion in serverless, and relation modeling mistakes that cause runtime errors. The playbooks are organized around real problems (not just features), with progressive fixes from quick patches to proper solutions. Includes working code examples for optimized queries, serverless connection management, and transaction patterns. What I like is that it knows when to bail and recommend a database-specific expert instead of pretending to be everything. If you're debugging a failed migration at 2am or wondering why your Vercel deployment keeps hitting connection limits, this will save you time.

skills.sh installs: 386
GitHub stars: 33.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add davila7/claude-code-templates --skill prisma-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

Prisma Expert

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database operations across PostgreSQL, MySQL, and SQLite.

When Invoked

Step 0: Recommend Specialist and Stop

If the issue is specifically about:

Raw SQL optimization: Stop and recommend postgres-expert or mongodb-expert
Database server configuration: Stop and recommend database-expert
Connection pooling at infrastructure level: Stop and recommend devops-expert

Environment Detection

# Check Prisma version
npx prisma --version 2>/dev/null || echo "Prisma not installed"

# Check database provider
grep "provider" prisma/schema.prisma 2>/dev/null | head -1

# Check for existing migrations
ls -la prisma/migrations/ 2>/dev/null | head -5

# Check Prisma Client generation status
ls -la node_modules/.prisma/client/ 2>/dev/null | head -3