skills.rest
GP-CRM-System
GP-CRM-SystemOFFICIAL
Explore all skills by this author →
GitHub

prisma-expert

Diagnose and resolve Prisma ORM schema, migration, and query performance issues.

Updated Mar 12, 2026
Search Tags:#migrations#orm#query-optimization#prisma#schema-design#database-design
One-click install
npx skills add https://github.com/GP-CRM-System/E-Commerce-CRM --skill prisma-expert-gp-crm-system
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-expert
Source: https://github.com/GP-CRM-System/E-Commerce-CRM/tree/main/.agents/skills/prisma-expert
Command: npx skills add https://github.com/GP-CRM-System/E-Commerce-CRM --skill prisma-expert-gp-crm-system

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prisma ORM issues in schema design, migrations, and query performance are identified, diagnosed, and resolved with proven best practices, playbooks, and concrete commands.

Core Features & Use Cases

  • Schema design guidance for PostgreSQL, MySQL, and SQLite with explicit relations
  • Migration strategies, validation steps, and performance-oriented query optimization
  • Practical playbooks for debugging, refactoring, and preventing regressions in Prisma projects

Quick Start

Configure Prisma in your project, run migrations, and start optimizing queries to improve performance.

Frequently Asked Questions about prisma-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow Prisma queries in a PostgreSQL database?▼

Optimize slow Prisma queries by applying query performance playbooks that diagnose inefficient schema relations and generate optimized database access patterns for PostgreSQL.

What's the best way to design a Prisma schema with explicit relations?▼

Design a Prisma schema with explicit relations by following schema design guidance that structures relation modeling across multi-database environments to ensure correctness and maintainability.

How do I manage Prisma migrations safely across different database environments?▼

Manage Prisma migrations safely by using safeguarded workflows with validation steps that handle migration strategies across PostgreSQL, MySQL, and SQLite to prevent regressions.

Why does my Prisma migration keep failing during schema refactoring?▼

Prisma migration failures during schema refactoring occur when validation steps are skipped, which diagnostic commands and debugging playbooks identify and resolve before applying changes.

Can I use Prisma ORM with both MySQL and SQLite in the same project?▼

Yes, Prisma ORM supports multi-database environments including MySQL and SQLite, providing schema design guidance and migration strategies tailored to each database's specific constraints.

When do I need to run diagnostics commands for Prisma query tuning?▼

Run diagnostics commands for Prisma query tuning when detecting performance regressions, needing to refactor database access, or validating that query optimization patterns match best practices.

Related Skills

Explore More Software Engineering Skills→
R2W1csR2W1cs
1

prisma-expert

Optimize Prisma ORM schemas, migrations, queries, connections, and transactions.

Community
Advanced
kensauruskensaurus
8

database-optimization

Profile slow queries and optimize indexes in PostgreSQL, Prisma, and Supabase.

Community
Advanced
mgd34msumgd34msu
4

prisma

Define Prisma schemas, run migrations, and write type-safe queries for Node.js and TypeScript.

Community
Advanced
ripgraphicsripgraphics

prisma-expert

Assist with Prisma ORM schema design, migrations, and query optimization.

Community
Advanced