Prisma Next Queries
prisma/prisma-next/skills/prisma-next-queriesby prisma55458c441d2cNo license415 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 6 weeks ago
Write Prisma Next queries for Postgres, SQLite, or Mongo — pick a lane (Postgres/SQLite `db.orm.<Model>` + `db.sql.<table>`; Mongo `db.orm.<root>` + `db.query.from(...)` pipeline builder), filter / project / sort / paginate, eager-load with `.include(...)`, Postgres/SQLite `db.transaction(...)`, Postgres/SQLite ORM `.aggregate(...)`, Mongo aggregations via query builder, namespace-aware accessors (`db.orm.<ns>.<Model>`, `db.sql.<ns>.<table>`). Triggers: query, where, match, select, project, orderBy, take, skip, include, lookup, first, all, count, aggregate, group, create, update, delete, upsert, returning, transaction, db.close, script teardown, variant, polymorphism, drizzle-style, kysely-style. Notes: `.all()` is a Thenable (just `await` it), iterators are single-use (`RUNTIME.ITERATOR_CONSUMED`), Postgres `count` is `number` while sum/avg/min/max are `number | null`, ranges use chained `.where()` or `and(...)` (no `.between(...)`).
Only the file list is public. File contents are available once the skill is installed in a workspace.
| Path | Size | Type |
|---|---|---|
| mongo.md | 11.8 KB | text/markdown |
| postgres.md | 18.7 KB | text/markdown |
| SKILL.md | 14.8 KB | text/markdown |
Source and attribution
Source:prisma/prisma-nextinskills/prisma-next-queriesat commit55458c4
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from prisma/prisma-next
Prisma Next Migrations
prisma
Guides authoring Prisma Next database migrations, including choosing db update versus migration plan and filling data-transform placeholders.
Prisma Next Migration Review
prisma
Guides reviewing Prisma Next migrations before deploy, covering migration status, refs, and concurrency conflicts.
Prisma Next Feedback
prisma
Routes Prisma Next bug reports, feature requests and team questions to GitHub Issues or the Prisma Discord.
Prisma Next Debug
prisma
Reads Prisma Next structured error envelopes and routes each error code to the right recovery step.
Prisma Next Contract
prisma
Guides authoring and editing of the Prisma Next data contract source and emitting its contract artifacts.
Prisma Next Build
prisma
Guides wiring the Prisma Next Vite plugin into a project's build system so contract artifacts re-emit during development.
More in Software Development
Playground
anthropics
Builds self-contained interactive HTML playgrounds with controls, live preview, and copyable prompt output.
M5 Onboard
anthropics
Provisions M5Stack ESP32 boards by detecting them on USB, flashing UIFlow 2.0 firmware, and installing a MicroPython app bundle.
Cardputer Buddy
anthropics
Guides iterating on a Cardputer-Adv MicroPython app bundle: adding apps, pushing files over USB-serial, tailing logs, and running REPL commands.
Web Design Guidelines
vercel-labs
Reviews UI code against Web Interface Guidelines fetched from a remote source and reports findings as file:line entries.
Vercel React Native Skills
vercel-labs
React Native and Expo best-practice rules covering list performance, animation, navigation, UI patterns, state, and monorepo setup.
Vercel React Best Practices
vercel-labs
Vercel's React and Next.js performance guidelines, organized as 70 rules for writing, reviewing, and refactoring code.