Build Safer Prisma Client Queries
Prisma Client APIs can be difficult to navigate across queries, filters, relations, transactions, and configuration. This reference provides focused patterns and examples for common Prisma Client tasks.
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "prisma-client-api" from https://skillstore.io/skills/prisma-prisma-client-api.md and its manifest at https://skillstore.io/api/skills/prisma-prisma-client-api/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.
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Using "prisma-client-api". Find active users, return only required fields, and paginate the results.
Expected outcome:
Using "prisma-client-api". Choose a transaction strategy for transferring funds between two accounts.
Expected outcome:
Use an interactive transaction with validated account records, guarded balance changes, a strict timeout, and no external network work inside the transaction.
Using "prisma-client-api". Review a raw SQL search that includes user input.
Expected outcome:
All 151 static findings are false positives caused by Markdown syntax, TypeScript templates, relative imports, environment configuration, SQL examples, and documentation links. No command execution, path traversal, environment-file reading, reconnaissance, unauthorized network behavior, or prompt injection was found. One medium concern remains because examples log raw query parameters without redaction and may expose sensitive data.
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
https://skillstore.io/skills/prisma-prisma-client-api/audits/6?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report[](https://skillstore.io/skills/prisma-prisma-client-api?utm_source=security_passport_badge)<a href="https://skillstore.io/skills/prisma-prisma-client-api?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/prisma-prisma-client-api/security.svg" alt="Skillstore security assessment" loading="lazy"></a><iframe src="https://skillstore.io/embed/skills/prisma-prisma-client-api.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>prisma. (2026). prisma-client-api security audit report (audit version 6) [Author version 7.6.0]. Skillstore. https://skillstore.io/skills/prisma-prisma-client-api/audits/6@techreport{prisma-prisma-prisma-client-api-2026,
author = {prisma},
title = {prisma-client-api security audit report (audit version 6)},
institution = {Skillstore},
year = {2026},
number = {6},
url = {https://skillstore.io/skills/prisma-prisma-client-api/audits/6},
note = {Author version 7.6.0}
}cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "prisma-client-api security audit report (audit version 6)"
version: "7.6.0"
type: report
authors:
- name: "prisma"
date-released: "2026-07-23"
url: "https://skillstore.io/skills/prisma-prisma-client-api/audits/6"
identifiers:
- type: other
value: "skillstore:prisma-prisma-client-api:audit:6"
description: "Skillstore immutable audit report identifier"
Choose typed Prisma methods, filters, relations, and result shapes for an application feature.
Select sequential or interactive transactions and define suitable timeouts, isolation, and rollback behavior.
Check raw SQL parameterization, sensitive field selection, query logging, and destructive operations before release.
Using my User model requirements, explain a Prisma Client findMany query with filters, sorting, and a result limit.
Design a Prisma query that selects specific user fields, includes recent posts, and uses cursor pagination. Explain each option.
Propose an interactive transaction for transferring account funds. Include validation, isolation guidance, rollback behavior, and limits on external work.
Audit my Prisma Client setup and raw SQL approach for injection, connection handling, transaction boundaries, sensitive logging, and type safety.
Author
prismaLicense
MIT
Author version
v7.6.0
Skillstore revision
r2
Repository
https://github.com/prisma/skills/tree/1a9f427e9fe2137298abbcc1a6f372db92e8c40d/prisma-client-apiRef
ebdfe608f5de2b66ff37ab4af12af8ac4f5e8006
Maintenance freshness
7/25/2026
Usage
0 downloads · 0 views
File structure
Configure Prisma for Your Database
Prisma setup varies by database provider and major version. This skill provides provider-specific schemas, connection guidance, adapters, client generation, and troubleshooting steps.
Plan Your Prisma MongoDB Upgrade
Prisma ORM v7 does not support MongoDB, so standard upgrade advice fails. This skill evaluates Prisma Next and provides a staged migration path.
Draft Prisma Next Feedback for the Right Channel
Prisma Next feedback can be difficult to classify and prepare for public submission. This skill routes feedback and drafts complete, redacted reports.
Configure Prisma Next Runtime Clients
Prisma Next runtime setup can fail through incorrect imports, middleware order, or connection lifecycle choices. This skill provides target-specific, typed configuration guidance.
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.
Build Prisma Next Data Contracts
Complex Prisma Next contracts can fail when schemas, extensions, and configuration drift. This skill guides contract edits, configuration, diagnostics, and artifact emission.
Build Reliable Playwright Tests
by C0ntr0lledCha0s
Playwright test suites can become flaky, slow, and difficult to maintain. This skill provides practical patterns for locators, fixtures, page objects, debugging, mocking, and configuration.
Build Starknet Apps with starknet.js
by internet-court
Starknet integrations require precise provider, account, transaction, and fee handling across several APIs. This skill provides focused starknet.js v9.x patterns for reliable TypeScript applications.
Improve Vue 3 Code Quality
by vuejs-ai
Vue projects often collect reactivity, component, and performance mistakes over time. This skill gives targeted Vue 3 guidance for safer patterns and clearer code.
Build Reliable Backend APIs
by alirezarezvani
Backend projects often need consistent planning across APIs, databases, security, and deployment. This skill gives Claude, Codex, and Claude Code structured backend guidance with simple helper scripts and references.
Build Type-Safe React Components
by softaworks
React TypeScript work often needs precise event, hook, and route types. This skill provides focused patterns for typed components, React 19 APIs, and routing.
Improve Vue Options API Code
by vuejs-ai
Vue Options API projects often lose type safety and correct this binding. This skill gives focused rules for safer Vue 3 components.