prisma-expert

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

Updated Jan 21, 2026
One-click install
npx skills add https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation --skill prisma-expert-mahamaneharouna9-cpu
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: prisma-expert
Source: https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation/tree/main/.opencode/skill/prisma-expert
Command: npx skills add https://github.com/mahamaneharouna9-cpu/Apex-invoice-billing-automation --skill prisma-expert-mahamaneharouna9-cpu

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses complex challenges in Prisma ORM, including schema design, migration failures, query performance bottlenecks, and database connection issues, ensuring efficient and reliable data management.

Core Features & Use Cases

  • Schema Design & Validation: Guides users in creating optimal Prisma schemas, defining relations, and validating schema integrity.
  • Migration Management: Assists in resolving migration conflicts, fixing failed migrations, and implementing safe deployment workflows.
  • Query Optimization: Identifies and resolves N+1 query problems, over-fetching, and slow database queries.
  • Connection Handling: Provides strategies for managing database connections, especially in serverless environments.
  • Use Case: A developer is encountering frequent "Too many connections" errors in their Node.js application using Prisma. This Skill can analyze their connection configuration and suggest optimizations for the DATABASE_URL and provide best practices for connection pooling.

Quick Start

Use the prisma-expert skill to help optimize the following Prisma query for better performance.

Frequently Asked Questions about prisma-expert

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

FAQPage Schema
How do I resolve migration conflicts and failed Prisma migrations?

To resolve Prisma migration conflicts, you must analyze the migration history and resolve schema drift. This Skill assists in fixing failed migrations and implementing safe deployment workflows by validating schema integrity through Prisma CLI commands.

How do I fix Prisma N+1 query problems and slow database performance?

Fixing Prisma N+1 query problems involves optimizing query selection strategies to prevent over-fetching. This Skill identifies slow database queries and provides query optimization techniques to improve overall Prisma ORM performance.

What is the best way to manage database connection pool exhaustion in Prisma?

Managing database connection pool exhaustion in Prisma requires adjusting the DATABASE_URL connection parameters. This Skill provides strategies for managing database connections and optimizing connection pooling, especially in serverless environments.

How do I define relation modeling and validate schema design in Prisma?

Defining relation modeling in Prisma requires structuring schema definitions correctly to avoid relation definition errors. This Skill guides optimal schema design, validates schema integrity, and ensures adherence to Prisma best practices.

Does Prisma ORM work with PostgreSQL, MySQL, and SQLite for schema design?

Prisma ORM works with PostgreSQL, MySQL, and SQLite for schema design and connection management. This Skill provides expert assistance covering schema design, migrations, and query optimization across these specific database systems.