Description
prisma-patterns is an agent skill from the ECC collection by affaan-m, listed on skills.sh. It gives production patterns for the Prisma ORM in TypeScript backends, covering schema design, query optimisation, transactions and pagination, along with the traps that are not obvious, such as how updateMany reports its result. The skill stresses checking the installed Prisma version first, because the API has changed across major releases. It notes differences such as relation joins, which can reduce queries but may explode rows on large one-to-many relations, the omit modifier and the $extends client extensions API, and newer setups where the package is called prisma, the client needs a driver adapter, and the datasource URL can sit in prisma.config.ts. The CLI commands for migrations and generation are the same across versions. It applies when an agent works on a Prisma-backed backend. A skill is a SKILL.md file of instructions that an AI agent loads when a task calls for it. It is free and open source, and the skills.sh listing shows all three security audits passing.…
Highlights
- Schema design and query optimisation
- Transactions and pagination
- Version-aware API notes
- Known traps such as updateMany results
Ratings & Reviews
No ratings yet
Be the first to rate prisma-patterns.
People also visit
prisma-cli
Complete reference for Prisma CLI commands, options, and workflows across setup
kotlin-exposed-patterns
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions
prisma-driver-adapter-implementation
Required reference for Prisma ORM 7 SQL driver adapter work
prisma-upgrade-v7
Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes
prisma-patterns FAQ
What does the prisma-patterns skill do?
It guides an agent in building Prisma ORM code for TypeScript backends, including schemas, queries, transactions, pagination and known pitfalls.
Why check the version first?
The skill says the Prisma API has changed across major releases, so the right pattern depends on the installed version.
Are the CLI commands the same?
Yes. The skill notes that migrate dev, migrate deploy and generate are unchanged across versions.
How do I install it?
Run: npx skills add https://github.com/affaan-m/ecc --skill prisma-patterns
Is it free?
Yes. It is free and open source.
Are there security findings?
The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.
What are the best prisma-patterns alternatives?
Popular alternatives to prisma-patterns include prisma-cli, prisma-orm-setup and kotlin-exposed-patterns. See all prisma-patterns alternatives