Prisma Patterns
Production Prisma ORM patterns for TypeScript: schema design, query optimization, transactions, pagination, and the traps nobody warns you about.
- What
- Production Prisma ORM patterns for TypeScript: schema design, query optimization, transactions, pagination, and the traps nobody warns you about.
- Cost
- Free
- Needs
- a Prisma project (check your version with "npx prisma --version" first, the API differs across major releases). Pure guidance skill, nothing to install.
- Level
- Beginner — a Prisma project (check your version with "npx…
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor: a patterns skill for Prisma ORM that focuses on the non-obvious traps, not just the happy path. It covers ID strategy (cuid vs uuid vs autoincrement), schema defaults with proper indexing, include vs select trade-offs, array vs interactive transaction forms, the PrismaClient singleton pattern, and cursor pagination done right. The anti-patterns section is the real value: updateMany returns a count, not records; the interactive $transaction form times out after 5 seconds; migrate dev can reset your database; manually editing a migration file breaks future deploys with checksum mismatches; @updatedAt silently skips bulk writes; and soft delete plus findUniqueOrThrow leaks deleted records. Serverless connection-pooling guidance included. By @affaan-m, listed here with credit to its creator. From the affaan-m/ECC repository (MIT). Honest caveats: pure guidance, nothing to install; the Prisma API has evolved across major releases, so check your version with npx prisma --version before applying patterns, and never run migrate dev against shared or production databases. Skill Harbor never reviews the code, review it yourself before use.
Version:
Quick answer
Prisma Patterns is a free skill for Muse. a patterns skill for Prisma ORM that focuses on the non-obvious traps, not just the happy path. It covers ID strategy (cuid vs uuid vs autoincrement), schema defaults with proper indexing, include vs select trade-offs, array vs interactive transaction forms, the PrismaClient singleton pattern, and cursor pagination done right.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 4eb71d9Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. Use "Prisma Patterns" with your Muse. Prerequisites: a Prisma project (check your version with "npx prisma --version" first, the API differs across major releases). Pure guidance skill, nothing to install. 1. Open the skill: https://raw.githubusercontent.com/affaan-m/ECC/4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2/skills/prisma-patterns/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Review my schema.prisma for missing indexes and ID strategy issues" or "Is this transaction safe? Check it against the anti-patterns." 3. Before any migration, ask: "Plan a zero-downtime migration for [change] using expand-and-contract." Tip: never run migrate dev on a shared database; ask for "migrate deploy" planning for staging and production instead. Safety: a skill is plain-text instructions; it runs nothing by itself. Back up your database before migrations, and review anything Muse proposes before it touches your schema.
Saved to your recent installs. Find it anytime on /connect.
🔒 Security, provenance and what this touches
- It can download and install software packages.
What the scan found — excerpts from the install prompt
- installs packages — Prerequisites: a Prisma project (check your version with "npx prisma --version" first, the API differs across · Prérequis : un projet Prisma (vérifiez d'abord votre version avec « npx prisma --version », l'API diffère selo
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- 4eb71d9 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 11, 2026
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 21, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : installs packages
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a skill before installing it.