# Send Prisma to your agent Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually. ## Fast path - Download the package from Yavira. - Extract it into a folder your agent can access. - Paste one of the prompts below and point your agent at the extracted folder. ## Suggested prompts ### New install ```text I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete. ``` ### Upgrade existing ```text I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run. ``` ## Machine-readable fields ```json { "schemaVersion": "1.0", "item": { "slug": "prisma", "name": "Prisma", "source": "tencent", "type": "skill", "category": "AI 智能", "sourceUrl": "https://clawhub.ai/ivangdavila/prisma", "canonicalUrl": "https://clawhub.ai/ivangdavila/prisma", "targetPlatform": "OpenClaw" }, "install": { "downloadUrl": "/downloads/prisma", "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=prisma", "sourcePlatform": "tencent", "targetPlatform": "OpenClaw", "packageFormat": "ZIP package", "primaryDoc": "SKILL.md", "includedAssets": [ "SKILL.md" ], "downloadMode": "redirect", "sourceHealth": { "source": "tencent", "slug": "prisma", "status": "healthy", "reason": "direct_download_ok", "recommendedAction": "download", "checkedAt": "2026-05-03T05:14:31.722Z", "expiresAt": "2026-05-10T05:14:31.722Z", "httpStatus": 200, "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=prisma", "contentType": "application/zip", "probeMethod": "head", "details": { "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=prisma", "contentDisposition": "attachment; filename=\"prisma-1.0.0.zip\"", "redirectLocation": null, "bodySnippet": null, "slug": "prisma" }, "scope": "item", "summary": "Item download looks usable.", "detail": "Yavira can redirect you to the upstream package for this item.", "primaryActionLabel": "Download for OpenClaw", "primaryActionHref": "/downloads/prisma" }, "validation": { "installChecklist": [ "Use the Yavira download entry.", "Review SKILL.md after the package is downloaded.", "Confirm the extracted package contains the expected setup assets." ], "postInstallChecks": [ "Confirm the extracted package includes the expected docs or setup files.", "Validate the skill or prompts are available in your target agent workspace.", "Capture any manual follow-up steps the agent could not complete." ] } }, "links": { "detailUrl": "https://openagent3.xyz/skills/prisma", "downloadUrl": "https://openagent3.xyz/downloads/prisma", "agentUrl": "https://openagent3.xyz/skills/prisma/agent", "manifestUrl": "https://openagent3.xyz/skills/prisma/agent.json", "briefUrl": "https://openagent3.xyz/skills/prisma/agent.md" } } ``` ## Documentation ### Schema Design Traps @default(cuid()) over @default(uuid()) for IDs—shorter, URL-safe, still unique @updatedAt doesn't update on nested writes—must touch parent record explicitly Implicit many-to-many creates join table you can't customize—use explicit for extra fields @unique on nullable field allows multiple NULLs—intended behavior but often surprising Enum changes require migration—can't add values without downtime unless using String ### Query Patterns I Forget findUniqueOrThrow / findFirstOrThrow—cleaner than null check after findUnique createMany skips hooks and returns count only—use create in loop if you need records back upsert requires unique field in where—can't upsert on non-unique compound conditions connectOrCreate in nested writes—avoids separate existence check select and include are mutually exclusive—can't mix; use nested select inside include ### N+1 Query Prevention Default queries don't include relations—every access triggers new query include everything you'll access—check logs for unexpected queries Middleware can't see includes—adding includes in middleware doesn't help findMany + include better than loop of findUnique—single query vs N queries Dataloader pattern for GraphQL resolvers—Prisma doesn't batch automatically ### Transaction Gotchas $transaction([]) array syntax rolls back all on any failure—use for atomic operations Interactive transactions $transaction(async (tx) => {}) hold connection—keep short Default 5s timeout on interactive transactions—increase for long operations Nested writes are already transactional—don't wrap single create with relations in transaction $transaction doesn't retry on conflict—implement retry logic for optimistic locking ### Type Safety Gaps include result type doesn't narrow—TypeScript thinks relations might be undefined Raw queries return unknown[]—need manual type assertion or Prisma.$queryRaw JSON fields are JsonValue—cast needed; consider using typed JSON libraries Prisma.validator for reusable query fragments with correct types Return types of $executeRaw is count—not the affected rows ### Migration Issues prisma db push for prototyping—prisma migrate dev for version control db push can drop data silently—never use in production Shadow database required for migrate dev—needs create permission or separate DB Renaming field = drop + create by default—use @map to keep data Large table migrations lock table—consider running raw SQL with concurrent indexes ### Performance Traps findMany without take can return millions—always paginate count() scans table—expensive on large tables; consider approximate or cached counts include with large relations loads everything—use cursor pagination for big lists Relation counts: _count: { select: { posts: true } }—single query, not N+1 orderBy on non-indexed field = slow—ensure indexes match sort patterns ### Raw Query Patterns $queryRaw for reads, $executeRaw for writes—different return types Use Prisma.sql template for safe interpolation—never string concatenation Raw queries bypass Prisma hooks and middleware—intentional but easy to forget $queryRawUnsafe exists but name is a warning—use only for dynamic column names Raw results use database column names—not Prisma field names if @map used ### Connection Management Default pool size 5—too low for production; set connection_limit in URL PlanetScale/serverless needs ?pool_timeout=0—prevents connection exhaustion $disconnect() in scripts and tests—lambda/serverless should manage differently Prisma Accelerate or Data Proxy for edge/serverless—direct DB connections don't scale ### Middleware Patterns Soft delete via middleware: intercept delete, convert to update—but deleteMany needs handling Audit logging: $use captures all queries—but adds latency to every operation Middleware runs in order added—earlier middleware sees raw params Can't modify include in middleware—transform happens before middleware ### Common Mistakes Forgetting await—Prisma returns promises; queries don't execute without await update without where = error—unlike some ORMs, Prisma requires explicit where Decimal fields return strings—Prisma Decimal type, not JavaScript number @relation names must match—cryptic error if they don't Schema drift: production differs from migrations—run prisma migrate deploy in CI ## Trust - Source: tencent - Verification: Indexed source record - Publisher: ivangdavila - Version: 1.0.0 ## Source health - Status: healthy - Item download looks usable. - Yavira can redirect you to the upstream package for this item. - Health scope: item - Reason: direct_download_ok - Checked at: 2026-05-03T05:14:31.722Z - Expires at: 2026-05-10T05:14:31.722Z - Recommended action: Download for OpenClaw ## Links - [Detail page](https://openagent3.xyz/skills/prisma) - [Send to Agent page](https://openagent3.xyz/skills/prisma/agent) - [JSON manifest](https://openagent3.xyz/skills/prisma/agent.json) - [Markdown brief](https://openagent3.xyz/skills/prisma/agent.md) - [Download page](https://openagent3.xyz/downloads/prisma)