Menu
Procedural knowledge for identifying bottlenecks and optimizing system performance.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Procedural knowledge for generating and maintaining code documentation, API specs, and architecture diagrams.
Procedural knowledge for orchestrating multi-agent systems and Agent-to-Agent (A2A) handoffs.
Procedural knowledge for designing autonomous AI agents with tools, memory, and reasoning loops.
Procedural knowledge for implementing the Model Context Protocol (MCP) to expose local tools to LLMs.
Procedural knowledge for ensuring frontend interfaces comply with WCAG standards.
Procedural knowledge for designing and configuring continuous integration and deployment pipelines.
| name | performance-optimization |
| description | Procedural knowledge for identifying bottlenecks and optimizing system performance. |
Procedural knowledge for identifying bottlenecks and optimizing system performance.
Enable the Developer and Architect roles to systematically identify, measure, and resolve performance bottlenecks in frontend, backend, or database layers.
Step 1: Database Profiling
- Identify N+1 query problems.
- Check for missing indexes on frequently queried columns.
- Analyze slow query logs and optimize JOINs.
Step 2: Caching Strategy
- Implement Redis/Memcached for expensive, rarely-changing queries.
- Use HTTP caching headers (ETag, Cache-Control) where appropriate.
Step 3: Algorithm Analysis
- Review Big-O complexity of loops and data processing.
- Offload heavy computation to background workers (e.g., Celery, BullMQ).
Step 1: Asset Delivery
- Ensure JS/CSS is minified and compressed (Gzip/Brotli).
- Implement lazy loading for images and non-critical components.
Step 2: Rendering Performance
- Reduce DOM depth and complexity.
- Prevent unnecessary re-renders in frameworks like React (use memo, useMemo).
"Apply the performance-optimization skill from .ace/skills/performance-optimization/SKILL.md
to analyze and speed up this database query."