Agent skill · data analytics · aiskillstore
performance-fundamentals
Auto-invoke when reviewing loops, data fetching, rendering, database queries, or resource-intensive operations. Identifies N+1 queries, unnecessary re-renders, memory leaks, and scalability issues.
Why this skill is useful
Provides domain-specific knowledge on performance optimization patterns and anti-patterns that the AI wouldn't reliably generate on its own.
What it needs
About 3k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
Performance Fundamentals Review "Premature optimization is the root of all evil, but mature ignorance is worse." When to Apply Activate this skill when reviewing: Database queries (especially in loops) React/Vue render logic API response payloads Data transformations File operations Caching decisions --- Review Checklist Database Performance [ ] No N+1 queries: Are related records fetched in bulk, not loops? [ ] Indexes: Are frequently queried fields indexed? [ ] Pagination: Do list endpoints paginate results? [ ] Select only needed fields: Are we fetching entire records unnecessarily? Frontend Performance [ ] Memoization: Are expensive computations cached? [ ] Re-render prevention: Will state changes cause unnecessary re-renders? [ ] Bundle size: Are heavy libraries lazy-loaded? [ ] Image optimization: Are images properly sized and formatted? API Performance [ ] Response size: Is the payload minimal? [ ] Compression: Is gzip/brotli enabled? [ ] Caching headers: Are cacheable responses marked? [ ] Async processing: Are slow operations queued? Memory & Resources [ ] Cleanup: Are subscriptions/timers cleaned up? [ ] Memory leaks: Are event listeners removed? [ ] Connection pooling: Are DB connections reused? --- Common Mistakes (Anti-Patterns) 1. The N+1 Query Problem 2. Unnecessary Re-renders 3. Computing in Render 4. Fetching Everything 5. Missing Cleanup --- Socratic Questions Ask the junior these questions instead of giving answers: 1. Scale: "What happens when there are 10,000 items? 1,000,000?" 2. Queries: "How many database queries does this operation make?" 3. Re-renders: "When this state changes, what components re-render?" 4. Memory: "Is anything holding a reference after it's no longer needed?" 5. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/performance-fundamentals