SOC 職業分類に基づく
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/dipro-vn/dipro-ai-boost --skill prisma-indexingコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？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-indexing |
| description | null |
Category: prisma · Status: 🟢 Active
Khi thêm @@index/@unique cho cột hay dùng để query/sort/join.
where, orderBy, hoặc khóa ngoại join.@unique/@@unique cho ràng buộc duy nhất (email, slug, cặp cột).EXPLAIN nếu nghi query chậm.model Post {
id String @id @default(cuid())
slug String @unique
authorId String
status String
@@index([authorId])
@@index([status, createdAt])
@@unique([authorId, slug])
}
Good: index cho FK + cột filter/sort thường dùng, composite đúng thứ tự, unique cho slug. Avoid: index mọi cột, thiếu index trên FK gây full scan, unique nhầm chỗ.