基于 SOC 职业分类
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/dipro-vn/dipro-ai-boost --skill prisma-query-pattern命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
正在显示 SKILL.md
Use when a task that changed backend code is finishing, before reporting it done. Symptoms — a migration was added, a request or response shape changed, a new route exists, a cache key was added, something could not be verified, a problem was found and deliberately left alone.
Use when adding or changing a protected route, a guard, a role check, or any query that reads or writes records belonging to a user or tenant. Symptoms — a findById that takes only an id, a route with no guard, a role checked in the controller but not the query, an ID read straight from params, a new public endpoint, a service method reachable from more than one caller.
Use when choosing which exception to throw, shaping an error response, or deciding what to log. Symptoms — a caught error that returns 200, a try/catch that swallows the cause, a 500 where the client should see 400, an error message exposing a stack trace or SQL, a log line with no request context, the same failure logged at every layer.
| name | prisma-query-pattern |
| description | null |
Category: prisma · Status: 🟢 Active
Khi truy vấn dữ liệu: findUnique/findMany, select/include, tránh over-fetch & N+1.
findUnique cho 1 bản ghi theo khóa; findMany cho list có where.select; tránh trả nguyên model khi UI chỉ dùng vài cột.include/nested select trong 1 query, không loop query con (N+1).take/skip (phân trang) + orderBy xác định.const posts = await prisma.post.findMany({
where: { status: 'PUBLISHED' },
select: { id: true, title: true, author: { select: { name: true } } },
orderBy: { createdAt: 'desc' },
take: 20,
});
Good: select đúng field, include/nested gộp 1 query, có phân trang + orderBy.
Avoid: lấy toàn bộ model, loop gọi query trong vòng lặp (N+1), findMany không giới hạn.
select chỉ field cần dùng