skills.rest
tranhieutt
tranhieuttCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

prisma-expert

Diagnose Prisma schema, migration, and query performance issues in Node.js projects.

70|42|Updated Mar 27, 2026
Search Tags:#migrations#orm#transactions#query-optimization#prisma#schema-design#database-operations
One-click install
npx skills add https://github.com/tranhieutt/software_development_department --skill prisma-expert-tranhieutt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: prisma-expert
Source: https://github.com/tranhieutt/software_development_department/tree/main/.claude/skills/prisma-expert
Command: npx skills add https://github.com/tranhieutt/software_development_department --skill prisma-expert-tranhieutt

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill removes uncertainty when Prisma schemas, migrations, and queries start failing or slowing down by providing structured diagnostics and prioritized remediation paths.

Core Features & Use Cases

  • Schema design oversight: Validate relations, indexes, enums, and normalization with Prisma-aware best practices to prevent runtime errors and drift.
  • Migration safety: Analyze migration conflicts, status, and shadow databases, then recommend minimal to complete fixes plus safe deployment commands.
  • Query and connection tuning: Spot N+1 patterns, over-fetching, and connection pool issues, offering optimized query patterns, logging setups, and pooling advice.
  • Use Case: When a Postgres-backed Next.js app ships a Prisma schema change that breaks migrations and slows queries, invoke this Skill to review schema changes, adjust migrations, and tune queries before deployment.

Quick Start

Provide the Prisma schema, migration context, and any errors so I can recommend prioritized fixes.

Frequently Asked Questions about prisma-expert

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

FAQPage Schema
How do I resolve Prisma schema migration conflicts in a Node.js project?▼

Resolve Prisma migration conflicts by analyzing migration status and shadow databases, then applying minimal fixes and safe deployment commands for Node.js projects. Provide schema files and migration context to receive prioritized remediation steps.

What is the best way to optimize Prisma ORM queries to prevent N+1 patterns?▼

Optimize Prisma ORM queries by identifying N+1 patterns and over-fetching, then applying optimized query patterns and logging setups. This tuning process addresses connection pool issues to improve database operations performance.

How do I validate relations and indexes in a Prisma schema design?▼

Validate Prisma schema design by checking relations, indexes, enums, and normalization against Prisma-aware best practices. This oversight prevents runtime errors and schema drift in ORM-driven applications.

Can I use this to fix connection management issues for a Postgres-backed Next.js app?▼

Yes, you can fix connection management issues for a Postgres-backed Next.js app by tuning connection pools and reviewing query performance. Provide schema files and errors to receive targeted pooling advice and actionable fixes.

Why do my Prisma migrations break after schema changes and how do I deploy safely?▼

Prisma migrations break after schema changes due to drift or conflicts, requiring analysis of migration status and shadow databases. Apply minimal to complete fixes and execute safe deployment commands via Prisma CLI.

Related Skills

Explore More Software Engineering Skills→
botPhUbotPhU

prisma-expert

Design Prisma schemas, plan migrations, and optimize queries across PostgreSQL, MySQL, and SQLite.

Community
Advanced
KhaledaunKhaledaun

prisma-expert

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

Community
Advanced
zizzfizzixzizzfizzix

migrate-orm

Automate database schema migrations for ORM-based applications.

Community
Intermediate
jnlanahanjnlanahan

setup-database

Detect the ORM and generate reviewed migration steps for database schema changes.

Community
Advanced