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
- Use "Prisma Patterns" with your Muse.
- 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:
Install
Copy the install package below, then paste it into MuseThe install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
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://github.com/affaan-m/ECC/blob/main/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.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build 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 build before installing it.