Explore

Find agent skills by outcome

20,370 skills indexed with the new KISS metadata standard.

Showing 24 of 20,370Categories: Creative, Coding & Debugging, Productivity, Data

RULE: When using this prompt

you must create a file named `TODO_perf-tuning.md`. This file must contain the findings resulting from this research as checkable checkboxes that can be coded and tracked by an LLM.,TRUE,TEXT,wkaandem...

Find agent skills by outcome

**RULE:** When using this prompt

- Starts with measurement

- **Over-caching without invalidation**: Adding caches without invalidation strategies

- **Synchronous blocking in async code**: Blocking the event loop or thread pool with synchronous operations

Write all proposed optimizations and any code snippets to `TODO_perf-tuning.md` only. Do not create any other files. If specific files should be created or edited

- **N+1 query patterns**: Fetching related data in loops instead of using joins or batch queries

- **Missing database indexes**: Full table scans on frequently queried columns

### Database (Query Analyzers

- Use language-specific CPU and memory profilers (pprof for Go

- Deploy Application Performance Monitoring (Datadog

- Run Lighthouse for automated audits covering LCP

- Use reproducible benchmarks with consistent hardware

- [ ] API response times meet SLA: <200ms (p95) for standard endpoints

- Correlate bottlenecks with specific code paths

- **API**: Payload size reduction

- **Frontend**: Code splitting

- **Async**: Promise.all() for parallel operations

- **Techniques**: Dynamic programming

- **Data Structures**: Map vs Object for lookups

- Define performance budgets for critical paths (API response times

- Apply specific optimizations based on profiling data: select optimal data structures

- Analyze database query patterns for N+1 problems

- Record reproducible benchmark conditions (hardware

- Collect database query execution plans to identify slow operations

RULE: When using this prompt

- Over-caching without invalidation: Adding caches without invalidation strategies

- Synchronous blocking in async code: Blocking the event loop or thread pool with synchronous operations

- N+1 query patterns: Fetching related data in loops instead of using joins or batch queries

- Missing database indexes: Full table scans on frequently queried columns

- API: Payload size reduction

- Frontend: Code splitting

- Async: Promise.all() for parallel operations

- Techniques: Dynamic programming

- Data Structures: Map vs Object for lookups