Data
PromptBeginner5 minmarkdown
- **Dynamic query construction**: String concatenation used to build SQL
LDAP
0
Explore
Find agent skills by outcome
15,801 skills indexed with the new KISS metadata standard.
Showing 24 of 15,801Categories: Productivity, Data, Creative, Cursor-rules
Data
PromptBeginner5 minmarkdown
- Verify raw SQL queries use parameterized statements
not f-strings
0
Data
PromptBeginner5 minmarkdown
- Classify changes by risk category (auth
data handling
0
Data
PromptBeginner5 minmarkdown
- **Scan** staged git diffs for injection flaws including SQLi
command injection
0
Productivity
PromptBeginner5 minmarkdown
- Treat every requirement below as an explicit
trackable task.
0
Productivity
PromptBeginner5 minmarkdown
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
0
Creative
PromptBeginner5 minmarkdown
- Starts with measurement
not assumptions
0
Data
PromptBeginner5 minmarkdown
- **Over-caching without invalidation**: Adding caches without invalidation strategies
serving stale data and creating consistency bugs
0
Data
PromptBeginner5 minmarkdown
- **Missing database indexes**: Full table scans on frequently queried columns
causing query times to grow linearly with data volume
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
Data
PromptBeginner5 minmarkdown
- Deploy Application Performance Monitoring (Datadog
New Relic
0
Productivity
PromptBeginner5 minmarkdown
- Run Lighthouse for automated audits covering LCP
FID
0
Data
PromptBeginner5 minmarkdown
- Use reproducible benchmarks with consistent hardware
data volume
0
Productivity
PromptBeginner5 minmarkdown
- **Async**: Promise.all() for parallel operations
worker threads for CPU-bound tasks
0
Data
PromptBeginner5 minmarkdown
- **Data Structures**: Map vs Object for lookups
Set vs Array for uniqueness
0
Data
PromptBeginner5 minmarkdown
- Apply specific optimizations based on profiling data: select optimal data structures
implement caching
0
Data
PromptBeginner5 minmarkdown
- Record reproducible benchmark conditions (hardware
data volume
0
Data
PromptBeginner5 minmarkdown
- Analyze database query patterns for N+1 problems
unnecessary joins
0
Data
PromptBeginner5 minmarkdown
- Collect database query execution plans to identify slow operations
missing indexes
0
Data
PromptBeginner5 minmarkdown
- **Tune database query performance** by analyzing execution plans
eliminating N+1 problems
0
Productivity
PromptBeginner5 minmarkdown
- Treat every requirement below as an explicit
trackable task.
0
Productivity
PromptBeginner5 minmarkdown
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
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