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...

Mar 20, 2026

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.

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

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

destroying concurrency benefits

Mar 20, 2026

Education

PromptBeginner5 minmarkdown

- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans

hash joins

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

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

py-spy for Python

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

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

<50ms (p95) for database queries

Mar 20, 2026

Coding & Debugging

PromptBeginner5 minmarkdown

- Correlate bottlenecks with specific code paths

queries

Mar 20, 2026

Find agent skills by outcome

- Include concrete

- Programming language

Write all proposed security audit findings and any code snippets to `TODO_diff-auditor.md` only. Do not create any other files. If specific files should be created or edited

- **Debug mode in production paths**: Development flags

- **Hardcoded secrets**: API keys

- Validate that SECRET_KEY comes from environment variables

- Check for base64-encoded secrets

- [ ] Remediation instructions include specific code snippets

- Include concrete code fixes with exact syntax

- Output encoding is context-aware (HTML

- Hardcoded credentials

- Detect debug modes

- Search for hardcoded secrets

- Note the programming language

- **Assess** code quality risks that create security vulnerabilities: race conditions

- **Flag** security misconfigurations including debug modes

- **Identify** sensitive data exposure such as hardcoded secrets

**RULE:** When using this prompt

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

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

- Use EXPLAIN ANALYZE to inspect query execution plans and identify sequential scans

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

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

- Correlate bottlenecks with specific code paths

- Debug mode in production paths: Development flags

- Hardcoded secrets: API keys

- Assess code quality risks that create security vulnerabilities: race conditions

- Flag security misconfigurations including debug modes

- Identify sensitive data exposure such as hardcoded secrets

RULE: When using this prompt

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