Ln 651 Query Efficiency Auditor
Audits database query patterns for common performance killers: redundant fetches where the same entity is loaded twice in a call chain, N+1 update loops that should be batch operations, over-fetching full models when you only need three fields, and request-scoped caches for data that changes once a week. Uses a two-layer detection system to avoid false positives and supports hex-graph MCP tools to trace call paths when available. Returns findings with severity ratings, effort estimates, and a compliance score. Most useful during code review or when you're trying to figure out why your API suddenly needs 47 database round trips per request.
- skills.sh installs
- 380
- GitHub stars
- 591
- last updated
- Aug 21, 2026
Install
$ npx -y skills add levnikolaevich/claude-code-skills --skill ln-651-query-efficiency-auditor --agent claude-codeInstalls into .claude/skills of the current project.
Files
Audits database query patterns for common performance killers: redundant fetches where the same entity is loaded twice in a call chain, N+1 update loops that should be batch operations, over-fetching full models when you only need three fields, and request-scoped caches for data that changes once a week. Uses a two-layer detection system to avoid false positives and supports hex-graph MCP tools to trace call paths when available. Returns findings with severity ratings, effort estimates, and a compliance score. Most useful during code review or when you're trying to figure out why your API suddenly needs 47 database round trips per request.
Browse the repository on GitHubSponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/levnikolaevich/claude-code-skills
- First seen
- Jun 3, 2026
More from levnikolaevich/claude-code-skills
All 128- Ln 110 Project Docs Coordinator379
- Ln 111 Root Docs Creator379
- Ln 643 Api Contract Auditor379
- Ln 731 Docker Generator379
- Ln 733 Env Configurator379
- Ln 402 Task Reviewer378
- Ln 404 Test Executor378
- Ln 720 Structure Migrator378
- Ln 721 Frontend Restructure378
- Ln 743 Test Infrastructure378
- Ln 230 Story Prioritizer376
- Ln 635 Test Isolation Auditor376
- Ln 646 Project Structure Auditor376
- Ln 722 Backend Generator376
- Ln 771 Logging Configurator376
- Ln 783 Container Launcher376
- Ln 220 Story Coordinator375
- Ln 300 Task Coordinator375
- Ln 500 Story Quality Gate375
- Ln 780 Bootstrap Verifier375
- Ln 112 Project Core Creator373
- Ln 130 Tasks Docs Creator373
- Ln 770 Crosscutting Setup373
- Ln 400 Story Executor372
Recommended
cavemanjuliusbrussee/cavemanUltra-compressed communication mode. Cuts output tokens 65% (measured) by speaking like caveman while keeping full technical accuracy. Supports intensity levels618.3Kskills.sh installs
improveshadcn/improveSurvey any codebase as a senior advisor and produce prioritized, self-contained implementation plans for OTHER models/agents to execute. Strictly read-only on s40Kskills.sh installs
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes326.7Kskills.sh installs
karpathy-guidelinesforrestchang/andrej-karpathy-skillsBehavioral guidelines to reduce common LLM coding mistakes through explicit assumptions, simplicity, and verifiable success criteria.17.9Kskills.sh installs
find-skillsvercel-labs/skillsHelps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express int4.3Mskills.sh installs