Skills prisma-next-queries

📦

prisma-next-queries

Name: prisma-next-queries
Author: prisma

Content revision r1 Safe ⚙️ External commands📁 Filesystem access

Write Prisma Next Queries Across Database Targets

Prisma Next query APIs differ across Postgres, SQLite, and Mongo, which makes correct lane selection difficult. This skill provides target-specific patterns for typed reads, writes, relations, aggregates, pagination, and transactions.

Supports: Claude Codex Code(CC)

🥉 77 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request

Review the Skillstore skill "prisma-next-queries" from https://skillstore.io/skills/prisma-prisma-next-queries.md and its manifest at https://skillstore.io/api/skills/prisma-prisma-next-queries/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Agent-readable resources

Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.

Markdown detail GET /skills/prisma-prisma-next-queries.md Signed manifest GET /api/skills/prisma-prisma-next-queries/manifest Signed lockfile GET /api/skills/prisma-prisma-next-queries/lockfile

Test it

Using "prisma-next-queries". Fetch the newest posts with authors from a Postgres project.

Expected outcome:

Uses the Postgres ORM, includes the author relation, applies descending creation order, limits results, and awaits the collection once.

Using "prisma-next-queries". Count Mongo posts by category for one author.

Expected outcome:

Uses the Mongo query builder with an author match, category grouping, count accumulator, plan construction, and runtime execution.

Using "prisma-next-queries". Create a user and post atomically.

Expected outcome:

Uses one Postgres transaction and its shared context, while noting that the Mongo facade does not support this transaction workflow.

Security Audit

Safe

v1 • 8/17/2026 Open versioned report

All 103 static findings are false positives caused by Markdown code notation, fixed relative imports, and Prisma query terminology. No command execution, unsafe filesystem access, system reconnaissance, prompt injection, or malicious intent was found.

Files scanned

792

Lines analyzed

Review items

False positives ignored

Risk Factors

⚙️ External commands (50)

📁 Filesystem access (6)

mongo.md:34 mongo.md:152 postgres.md:33 postgres.md:34 postgres.md:235 SKILL.md:130

No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.

Audited by: codex

Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report

Copy report link

https://skillstore.io/skills/prisma-prisma-next-queries/audits/1?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/prisma-prisma-next-queries/security.svg)](https://skillstore.io/skills/prisma-prisma-next-queries?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/prisma-prisma-next-queries?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/prisma-prisma-next-queries/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/prisma-prisma-next-queries.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>

Academic citations (APA · BibTeX · CFF)

APA citation

prisma. (2026). prisma-next-queries security audit report (audit version 1) [Author version unspecified]. Skillstore. https://skillstore.io/skills/prisma-prisma-next-queries/audits/1

BibTeX citation

@techreport{prisma-prisma-prisma-next-queries-2026,
  author = {prisma},
  title = {prisma-next-queries security audit report (audit version 1)},
  institution = {Skillstore},
  year = {2026},
  number = {1},
  url = {https://skillstore.io/skills/prisma-prisma-next-queries/audits/1},
  note = {Author version unspecified}
}

CITATION.cff

cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "prisma-next-queries security audit report (audit version 1)"
version: "unspecified"
type: report
authors:
  - name: "prisma"
date-released: "2026-08-17"
url: "https://skillstore.io/skills/prisma-prisma-next-queries/audits/1"
identifiers:
  - type: other
    value: "skillstore:prisma-prisma-next-queries:audit:1"
    description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: Medium

Architecture

Maintainability

Content

Community

Spec Compliance

What You Can Build

Build application queries

Create typed reads, writes, relation includes, and pagination for an application service.

Create database analytics

Build Postgres aggregates or Mongo pipelines with grouping, projection, and joins.

Translate query styles

Convert familiar Prisma, Drizzle, or Kysely patterns into supported Prisma Next APIs.

Try These Prompts

Write a basic query

Write a Prisma Next query for [target] that returns [records] filtered by [condition].

Add relations and pagination

Create a [target] query for [model] with [relation], selected fields, stable sorting, and [page size] results.

Build an aggregate

Build a Prisma Next [Postgres or Mongo] aggregation that groups by [field] and calculates [metrics].

Design an atomic workflow

Design a Prisma Next workflow for [operations], using transactions where supported and explaining target limitations.

Best Practices

Confirm the runtime target before choosing model names, filters, or query lanes.
Use the ORM for standard CRUD and relations, then use builders for unsupported shapes.
Apply filters to mutations and consume each asynchronous result only once.

Avoid

Do not mix Postgres model accessors with Mongo collection accessors.
Do not use unrestricted reads when a single-row method or bounded page is required.
Do not invent raw SQL, Mongo transactions, or ORM aggregate APIs that are unavailable.

Frequently Asked Questions

Which databases does this skill cover?

It covers Prisma Next query patterns for Postgres, SQLite, and Mongo.

Does it generate data contracts?

No. Use the Prisma Next contract workflow to create or change models.

When should I use the ORM?

Use the ORM for standard CRUD, filtering, projection, pagination, and relation loading.

When should I use a lower-level builder?

Use it for explicit joins, computed projections, Mongo pipelines, or other shapes the ORM cannot express.

Does Mongo support transactions through this facade?

No. The current Mongo facade requires direct driver sessions for multi-document transactions.

How should I consume all query results?

Await the result directly for an array, or iterate once when incremental processing is needed.

Developer Details

Author

prisma

License

MIT

Skillstore revision

Version notice

The author did not declare a version.

Repository

https://github.com/prisma/prisma-next/tree/e0e739ca6a0e076c97733ef30ec3bf7b1f43a27b/skills/prisma-next-queries

Ref

2b5eb09b8a8d063f44990dafee9dfeaa98332939

Maintenance freshness

8/17/2026

Usage

0 downloads · 0 views

File structure

📄 mongo.md

📄 postgres.md

📄 SKILL.md