技能 prisma-next-queries

📦

prisma-next-queries

Name: prisma-next-queries
Author: prisma

内容修订 r1 安全 ⚙️ 外部命令📁 文件系统访问

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.

支持: Claude Codex Code(CC)

🥉 77 青铜

使用我的智能体安装

将此请求复制给你的智能体，其中包含权威 Skill 页面和清单。

智能体请求

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.

你的智能体仍应展示其计划，并按安全策略请求必要确认。

Agent 可读资源

当 AI Agent、爬虫或脚本需要干净上下文，而不是读取完整页面时，请使用这些链接。

Markdown 详情 GET /skills/prisma-prisma-next-queries.md 已签名 manifest GET /api/skills/prisma-prisma-next-queries/manifest 已签名 lockfile GET /api/skills/prisma-prisma-next-queries/lockfile

测试它

正在使用“prisma-next-queries”。 Fetch the newest posts with authors from a Postgres project.

预期结果:

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

正在使用“prisma-next-queries”。 Count Mongo posts by category for one author.

预期结果:

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

正在使用“prisma-next-queries”。 Create a user and post atomically.

预期结果:

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

安全审计

安全

v1 • 2026/8/17 打开版本化报告

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.

已扫描文件

792

分析行数

复核项

已忽略误报

风险因素

⚙️ 外部命令 (50)

📁 文件系统访问 (6)

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

最新一次完成的静态与语义审计未检测到已确认的安全发现。这并不能证明该 Skill 没有副作用。

审计者: codex

分享与引用此报告

分享版本化评估报告、中性徽章、嵌入卡片和引用。Skillstore 只报告证据，不判断该 Skill 是否安全。

打开版本化报告

复制报告链接

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

Markdown 徽章

[![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 徽章

<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>

嵌入卡片

<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>

学术引用 (APA · BibTeX · CFF)

APA 引用

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 引用

@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 评分

评分依据证据置信度: 中

架构

可维护性

内容

社区

规范符合性

你能构建什么

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.

试试这些提示

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.

最佳实践

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.

避免

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.

常见问题

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.

开发者详情

作者

prisma

许可证

MIT

Skillstore 修订

版本提示

作者未声明版本。

仓库

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

引用

2b5eb09b8a8d063f44990dafee9dfeaa98332939

维护新鲜度

2026/8/17

使用量

0 次下载 · 0 次浏览

文件结构

📄 mongo.md

📄 postgres.md

📄 SKILL.md