Coding & Debugging
PromptBeginner5 minmarkdown
- **Identify** sensitive data exposure such as hardcoded secrets
API keys
0
Explore
Find agent skills by outcome
21,480 skills indexed with the new KISS metadata standard.
Showing 24 of 21,480Categories: Writing & Content, Creative, Data, Coding & Debugging
Data
PromptBeginner5 minmarkdown
- **Scan** staged git diffs for injection flaws including SQLi
command injection
0
Creative
PromptBeginner5 minmarkdown
- Starts with measurement
not assumptions
0
Coding & Debugging
PromptBeginner5 minmarkdown
**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...
0
Data
PromptBeginner5 minmarkdown
- **Over-caching without invalidation**: Adding caches without invalidation strategies
serving stale data and creating consistency bugs
0
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
- **Missing database indexes**: Full table scans on frequently queried columns
causing query times to grow linearly with data volume
0
Coding & Debugging
PromptBeginner5 minmarkdown
- **Synchronous blocking in async code**: Blocking the event loop or thread pool with synchronous operations
destroying concurrency benefits
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
### 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
Coding & Debugging
PromptBeginner5 minmarkdown
- **Frontend**: Code splitting
tree shaking
0
Writing & Content
PromptBeginner5 minmarkdown
- Design cache-aside
write-through
0
Writing & Content
PromptBeginner5 minmarkdown
- Query optimization: rewrite queries using execution plan analysis
eliminate unnecessary subqueries and joins
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