Compétences prisma-next-queries

📦

prisma-next-queries

Name: prisma-next-queries
Author: prisma

Révision du contenu r1 Sûr ⚙️ Commandes externes📁 Accès au système de fichiers

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.

Prend en charge: Claude Codex Code(CC)

🥉 77 Bronze

Maintain this Skill? Claim it 🥉 77 Bronze

Installer avec mon Agent

Copiez cette demande dans votre Agent. Elle contient la page Skill de référence et le manifeste.

Demande d’agent

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.

Votre Agent doit toujours présenter son plan et demander toute confirmation exigée par la politique de sécurité.

Ressources lisibles par les agents

Utilisez ces liens lorsqu’un Agent IA, un crawler ou un script a besoin d’un contexte propre au lieu de lire toute la page.

Détail Markdown GET /skills/prisma-prisma-next-queries.md manifest signé GET /api/skills/prisma-prisma-next-queries/manifest lockfile signé GET /api/skills/prisma-prisma-next-queries/lockfile

Tester

Utilisation de « prisma-next-queries ». Fetch the newest posts with authors from a Postgres project.

Résultat attendu:

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

Utilisation de « prisma-next-queries ». Count Mongo posts by category for one author.

Résultat attendu:

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

Utilisation de « prisma-next-queries ». Create a user and post atomically.

Résultat attendu:

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

Audit de sécurité

Sûr

v1 • 17/08/2026 Ouvrir le rapport versionné

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.

Fichiers analysés

792

Lignes analysées

Éléments à examiner

Faux positifs ignorés

Facteurs de risque

⚙️ Commandes externes (50)

📁 Accès au système de fichiers (6)

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

Le dernier audit statique et sémantique terminé n’a détecté aucun constat de sécurité confirmé. Cela ne prouve pas que le skill est sans effets secondaires.

Audité par: codex

Partager et citer ce rapport

Partagez le rapport d’évaluation versionné, le badge neutre, la carte intégrable et les citations. Skillstore présente les preuves sans décider si ce Skill est sûr.

Ouvrir le rapport versionné

Copier le lien du rapport

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

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

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>

Carte intégrable

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

Citations académiques (APA · BibTeX · CFF)

Citation 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

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

Score Skillstore

Pourquoi ce score Niveau de confiance des preuves: Moyen

Architecture

Maintenabilité

Contenu

Communauté

Conformité aux spécifications

Ce que vous pouvez créer

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.

Essayez ces 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.

Bonnes pratiques

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.

Éviter

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.

Foire aux 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.

Détails du développeur

Auteur

prisma

Licence

MIT

Révision Skillstore

Avis de version

L’auteur n’a déclaré aucune version.

Dépôt

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

Réf

2b5eb09b8a8d063f44990dafee9dfeaa98332939

Récence de maintenance

17/08/2026

Utilisation

0 téléchargements · 0 vues

Structure de fichiers

📄 mongo.md

📄 postgres.md

📄 SKILL.md