N+1 查询问题的生产级数据访问规范。当代码在循环中查询数据库、ORM 按行懒加载关联关系、或列表端点 5 行快而 50 行慢时使用。不适用于 HTTP 契约设计或 Go/JavaScript 语言风格。
此技能是专门针对生产环境中 N+1 查询问题的数据访问规范。它详细描述了当 ORM 或循环隐藏了往返次数时，如何避免 N+1 问题、SELECT * 查询以及大列表未分页的情况。该技能适用于任何使用 ORM 或循环查询数据库的代码库，特别是在控制器、服务层或数据访问层中出现懒加载或逐行查询时。它提供了具体的检查清单和“完成条件”，确保每次查询语句数量固定（1 或 2 个），且分页返回正确的父级数量，而不是连接后的行数。同时，技能要求开发者首先阅读 references/bad-vs-good.md 文件，了解实际案例后再进行关联加载或连接操作。
npx skills add https://github.com/sshdkeyu/skill-prod-cursor/tree/HEAD/skills/data-access规则 03 是底线：无 N+1，热路径上无 SELECT *，查询有索引支持，大列表已分页。本技能描述的是当 ORM 或循环隐藏了往返次数时，规则如何失效。
从集合加载关联关系、将映射标记为急加载、或将一对多连接成分页列表之前，请先阅读 references/bad-vs-good.md。
This repo contains 4 individual skills — each has its own dedicated page.
Design or review REST/RPC API contracts that are consistent, evolvable, and hard to misuse. Use when defining new endpoints, reviewing an API surface, or resolving naming/versioning/error-shape questions.
Rigorous, severity-ranked review of a diff, PR, or file. Use when you want a thorough check of correctness, security, performance, design, readability, and test coverage with actionable feedback.
Structured triage → mitigation → root-cause flow for live production incidents. Use when a running system is degraded or down (errors, latency, outages) and you need to restore service safely and then find the cause.
Production Go playbook. Use when writing or reviewing Go: errors, goroutines, byte payloads, parsers, and switches on external input. Worked cases are in references/bad-vs-good.md. Do not use for JavaScript, TypeScript, or API-contract design.
ElevenLabs text-to-speech with mac-style say UX.
Oracle CLI second-model review/debug/refactor/design with selected files, dry-run token checks, API or browser engine.
Capture and automate macOS UI with the Peekaboo CLI.
Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user wants to design an API, explore interface options, compare module shapes, or mentions "design it twice".
Build a throwaway prototype to flesh out a design — a runnable terminal app for state/business-logic questions, or several radically different UI variations toggleable from one route.
Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".