prisma-expert

Installation
Summary

Expert guidance on Prisma schema design, migrations, query optimization, and database operations.

  • Diagnoses and fixes schema design issues including relation definitions, indexing, and field type mismatches across PostgreSQL, MySQL, and SQLite
  • Provides migration strategies for resolving conflicts, failed deployments, and shadow database issues with safe production workflows
  • Optimizes queries to eliminate N+1 problems, over-fetching, and missing indexes through progressive fixes from minimal to complete solutions
  • Covers connection management, transaction patterns, and serverless deployment configurations with code examples and best practices
SKILL.md

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
Related skills
Installs
3.5K
GitHub Stars
37.3K
First Seen
Jan 20, 2026