dipro-vn
dipro-vn/dipro-ai-boost
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/dipro-vn/dipro-ai-boost --skill prisma-query-patternコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。
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.
SOC 職業分類に基づく
SKILL.md を表示中
| 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