AgentSkillify

Explore

Find agent skills by outcome

17,983 skills indexed with the new KISS metadata standard.

Showing 24 of 17,983Categories: Creative, Communication, Coding & Debugging, Research & Learning, Data
Coding & Debugging
PromptBeginner5 minmarkdown

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

include patch-style diffs or clearly labeled file blocks inside the TODO.

0
Data
PromptBeginner5 minmarkdown

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

multiplying database round-trips linearly

0
Data
PromptBeginner5 minmarkdown

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

causing query times to grow linearly with data volume

2
Data
PromptBeginner5 minmarkdown

### Database (Query Analyzers

Index Tuning)

0
Coding & Debugging
PromptBeginner5 minmarkdown

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

py-spy for Python

0
Data
PromptBeginner5 minmarkdown

- Deploy Application Performance Monitoring (Datadog

New Relic

0
Data
PromptBeginner5 minmarkdown

- Use reproducible benchmarks with consistent hardware

data volume

0
Coding & Debugging
PromptBeginner5 minmarkdown

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

<50ms (p95) for database queries

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Correlate bottlenecks with specific code paths

queries

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **API**: Payload size reduction

compression (gzip

0
Communication
PromptBeginner5 minmarkdown

- **Microservices**: gRPC for inter-service communication

message queues for decoupling

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Frontend**: Code splitting

tree shaking

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Techniques**: Dynamic programming

memoization

0
Data
PromptBeginner5 minmarkdown

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

Set vs Array for uniqueness

0
Coding & Debugging
PromptBeginner5 minmarkdown

- Define performance budgets for critical paths (API response times

page load metrics

0
Data
PromptBeginner5 minmarkdown

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

implement caching

0
Data
PromptBeginner5 minmarkdown

- Analyze database query patterns for N+1 problems

unnecessary joins

0
Data
PromptBeginner5 minmarkdown

- Record reproducible benchmark conditions (hardware

data volume

0
Data
PromptBeginner5 minmarkdown

- Collect database query execution plans to identify slow operations

missing indexes

0
Coding & Debugging
PromptBeginner5 minmarkdown

Follow this systematic approach to deliver measurable

data-driven performance improvements while maintaining code quality and reliability.

0
Data
PromptBeginner5 minmarkdown

- **Tune database query performance** by analyzing execution plans

eliminating N+1 problems

0
Coding & Debugging
PromptBeginner5 minmarkdown

- **Accelerate frontend rendering** via code splitting

tree shaking

0
Data
PromptBeginner5 minmarkdown

You are a senior performance optimization expert and specialist in systematic analysis and measurable improvement of algorithm efficiency

database queries

0
Coding & Debugging
PromptBeginner5 minmarkdown

**RULE:** When using this prompt

you must create a file named `TODO_optimization-auditor.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...

0