Data
PromptBeginner5 minmarkdown
- **Scan** staged git diffs for injection flaws including SQLi
command injection
0
Explore
Find agent skills by outcome
77,096 skills indexed with the new KISS metadata standard.
Showing 24 of 77,096Categories: Data & Insights, General, Data
General
PromptBeginner5 minmarkdown
Diff Security Auditor Agent Role
# Security Diff Auditor
0
General
PromptBeginner5 minmarkdown
- Considers full-system impact
not just local improvements
0
General
PromptBeginner5 minmarkdown
- [ ] Trade-offs between performance
readability
0
General
PromptBeginner5 minmarkdown
Before finalizing
verify:
0
General
PromptBeginner5 minmarkdown
Use checkboxes and stable IDs (e.g.
`PERF-ITEM-1.1`):
0
General
PromptBeginner5 minmarkdown
Use checkboxes and stable IDs (e.g.
`PERF-PLAN-1.1`):
0
General
PromptBeginner5 minmarkdown
- **Trade-offs**: Complexity
maintainability
0
General
PromptBeginner5 minmarkdown
In `TODO_perf-tuning.md`
include:
0
General
PromptBeginner5 minmarkdown
- Baseline metrics: response time (p50
p95
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
General
PromptBeginner5 minmarkdown
- Monitor slow query logs and set appropriate thresholds (e.g.
>50ms for OLTP queries)
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
General
PromptBeginner5 minmarkdown
- **Memory leaks under load**: Allocations growing without bound in long-running processes
leading to OOM crashes in production
0
Data
PromptBeginner5 minmarkdown
### Database (Query Analyzers
Index Tuning)
0
General
PromptBeginner5 minmarkdown
- Implement distributed tracing (Jaeger
Zipkin) to identify cross-service latency bottlenecks
0
General
PromptBeginner5 minmarkdown
- Run load tests with k6
JMeter
0
Data
PromptBeginner5 minmarkdown
- Deploy Application Performance Monitoring (Datadog
New Relic
0
General
PromptBeginner5 minmarkdown
### Frontend (Chrome DevTools
Lighthouse
0
General
PromptBeginner5 minmarkdown
### Backend (APM
Profilers
0
General
PromptBeginner5 minmarkdown
- Address scalability: proactively consider expected input size
memory limitations
0
General
PromptBeginner5 minmarkdown
- Identify constraints
input/output requirements
0
General
PromptBeginner5 minmarkdown
- Provide alternative solutions when trade-offs exist (in-place vs additional memory
speed vs memory)
0