Agent skill · software engineering · aiskillstore
prisma-expert
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
Why this skill is useful
Adds specific commands and strategies for Prisma schema design, migrations, and query optimization that the AI wouldn't reliably generate on its own.
What it needs
Requires prisma installed locally. About 5k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
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 Apply Strategy 1. Identify the Prisma-specific issue category 2. Check for common anti-patterns in schema or queries 3. Apply progressive fixes (minimal → better → complete) 4. Validate with Prisma CLI and testing Problem Playbooks Schema Design Common Issues: Incorrect relation definitions causing runtime errors Missing indexes for frequently queried fields Enum synchronization issues between schema and database Field type mismatches Diagnosis: Prioritized Fixes: 1. Minimal: Fix relation annotations, add missing @relation directives 2. Better: Add proper indexes with @@index, optimize field types 3. Complete: Restructure schema with proper normalization, add composite keys Best Practices: Resources: https://www.prisma.io/docs/concepts/components/prisma-schema https://www.prisma.io/docs/concepts/components/prisma-schema/relations Migrations Common Issues: Migration conflicts in team environments Failed migrations leaving database in inconsistent state Shadow database issues during development Production deployment migration failures Diagnosis: Prioritized Fixes: 1. Minimal: Reset development database with prisma migrate reset 2. Better: Manually fix migration SQL, use prisma migrate resolve 3. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/prisma-expert