prisma

Automate Prisma schema design, migrations, and query optimization across PostgreSQL, MySQL, and SQLite.

2|Updated Oct 28, 2022

Search Tags:#postgresql #migrations #orm #query-optimization #prisma #schema-design #relational-modeling

Ready to run

npx skills add https://github.com/jmanuelrosa/dotfiles --skill prisma-jmanuelrosa

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: prisma
Source: https://github.com/jmanuelrosa/dotfiles/tree/main/roles/ai/files/claude/skills/prisma
Command: npx skills add https://github.com/jmanuelrosa/dotfiles --skill prisma-jmanuelrosa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Prisma schema design, migrations, and query optimization are complex tasks across PostgreSQL, MySQL, and SQLite; this skill provides expert guidance, repeatable playbooks, and guardrails to reduce drift and errors.

Core Features & Use Cases

Schema design best practices for relational data across multiple databases
Safe migrations, drift detection, and Prisma Client generation
Performance tuning, complex relation modeling, and query optimization

Quick Start

Request Prisma schema help and I will diagnose issues, apply fixes, and validate migrations end-to-end.

Frequently Asked Questions about prisma

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

FAQPage Schema

How do I design a Prisma schema for relational data across multiple databases?▼

Designing a Prisma schema for multiple databases requires applying relational modeling best practices to ensure correctness. This process involves diagnosing schema issues, implementing structural fixes, and validating migrations end-to-end to reduce drift and maintain data integrity.

What is the best way to handle Prisma migrations and drift detection?▼

Handling Prisma migrations and drift detection requires applying safe migration playbooks and guardrails to prevent database schema errors. This involves validating changes, generating the Prisma Client, and documenting best practices to synchronize your database state with your schema definition.

How do I optimize Prisma queries for PostgreSQL performance?▼

Optimizing Prisma queries for PostgreSQL involves performance tuning and applying query optimization techniques to complex relation models. This process diagnoses performance bottlenecks, applies structural schema improvements, and validates that the queries execute efficiently against the relational data.

Does this Prisma guidance work for both MySQL and SQLite?▼

Yes, this Prisma guidance works for MySQL and SQLite, supporting multi-database schema design and migrations. It provides expert direction for managing schemas across PostgreSQL, MySQL, and SQLite, addressing relational modeling and performance issues specific to each database platform.

Why does my Prisma schema lose sync during multi-database migrations?▼

Prisma schema sync issues during migrations occur due to drift between your database state and schema definition across PostgreSQL, MySQL, or SQLite. Resolving this requires diagnosing schema correctness, applying safe migration fixes, and validating changes to prevent future relational modeling errors.