performance-optimizer · oakoss — Claude Code skill: how to install
performance-optimizer provides structured workflows for profiling, caching, and full-stack performance tuning. Helps eliminate slow database queries, optimize bundles, and reduce API latency.
MIT 124 installs ★ 29 updated 2026-08-17
npx skills add oakoss/agent-skills --skill performance-optimizer -a claude-codeWhat performance-optimizer does
The skill outlines a six-step performance workflow: profiling, database tuning, caching, frontend adjustments, backend optimization, and monitoring. It defines target budgets such as sub-500ms P95 API responses, sub-100ms database queries, and Core Web Vitals thresholds including LCP under 2.5s and INP under 200ms.
Guidance covers browser caching, CDN layers, and application caches with Redis or Memcached. It flags antipatterns like SELECT *, functions inside WHERE clauses, and synchronous computational loads that belong in background job workers like BullMQ. Without prior measurements from Chrome DevTools, React Profiler, or EXPLAIN ANALYZE, the instructions reject premature code changes.
What it helps with
- fix N+1 database queries and missing indexes
- configure multi-tier caching across HTTP headers, CDN, and Redis
- cut frontend bundle size to hit Core Web Vitals targets
- move heavy request calculations into BullMQ background queues
Example prompts for the agent
- Run EXPLAIN ANALYZE on this slow query and suggest targeted indexes
- Check our API response times against the P95 target and outline a Redis caching strategy
- Audit our bundle size and configure lazy loading for heavy components
How to install performance-optimizer
1Skills CLI (Vercel)
npx skills add oakoss/agent-skills --skill performance-optimizer -a claude-code2Manually: put the files in place
~/.claude/skills/performance-optimizer/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/performance-optimizer/
1Skills CLI (Vercel)
npx skills add oakoss/agent-skills --skill performance-optimizer -a codex2Manually: put the files in place
.agents/skills/performance-optimizer/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add oakoss/agent-skills --skill performance-optimizer -a cursor2Manually: put the files in place
.cursor/skills/performance-optimizer/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install oakoss/agent-skills skills/performance-optimizer2Manually: put the files in place
.github/skills/performance-optimizer/SKILL.md1Skills CLI (Vercel)
npx skills add oakoss/agent-skills --skill performance-optimizer -a gemini-cli2Platform CLI
gemini skills install https://github.com/oakoss/agent-skills --path skills/performance-optimizerManually: put the files in place
.devin/skills/performance-optimizer/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add oakoss/agent-skills --skill performance-optimizer -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about performance-optimizer
How to install performance-optimizer in Claude Code?
Run npx skills add oakoss/agent-skills --skill performance-optimizer -a claude-code in your terminal. Alternatively, place the skill file at ~/.claude/skills/performance-optimizer/SKILL.md.
What does performance-optimizer do?
It guides the agent through six optimization phases across database queries, backend APIs, frontend bundles, and cache layers.
Which profiling tools does the skill expect?
The workflow relies on Chrome DevTools, React Profiler, and database EXPLAIN ANALYZE before making any optimization changes.
Source text
SKILL.md · MIT
--- name: performance-optimizer description: Optimize application performance and scalability. Use when investigating slow applications, scaling bottlenecks, or improving response times. Use for profiling, caching, database optimization, frontend performance, and backend tuning. license: MIT metadata: author: oakoss version: '1.1' --- # Performance Optimizer ## Overview Provides a systematic approach to application performance optimization across the full stack. Use when diagnosing slow page loads, high API latency, database bottlenecks, or scaling issues. Not a substitute for application-specific profiling -- always measure before optimizing. ## Quick Reference ### Performance Budgets | Metric | Target | Category | | ------------------------------- | ------- | -------------- | | Largest Contentful Paint (LCP) | < 2.5s | Core Web Vital | | Interaction to Next Paint (INP) | < 200ms | Core Web Vital | | Cumulative Layout Shift (CLS) | < 0.1 | Core Web Vital | | First Contentful Paint (FCP) | < 1.8s | Frontend | | Time to Interactive (TTI) | < 3.8s | Frontend | | Total Blocking Time (TBT) | < 200ms | Frontend | | API Response Time (P95) | < 500ms | Backend | | Database Query Time (P95) | < 100ms | Database | | Server Response Time (TTFB) | < 600ms | Backend | ### Optimization Phases | Phase | Focus | Key Action | | ------------- | ----------------------------- | ---------------------------------------------------------------- | | 1. Profiling | Identify real bottlenecks | Chrome DevTools, React Profiler, EXPLAIN ANALYZE | | 2. Database | Eliminate slow queries | Strategic indexes, fix N+1, connection pooling | | 3. Caching | Reduce redundant work | Redis, HTTP headers, CDN for static assets | | 4. Frontend | Reduce bundle and render time | Bundle analysis, code splitting, resource hints, lazy loading | | 5. Backend | Speed up API responses | Serverless optimization, streaming, conditional requests, queues | | 6. Monitoring | Sustain performance | APM tools, alerting thresholds, dashboards | ### Caching Layers | Layer | Scope | Duration | | ------------- | ---------------------- | ------------------------------------------------- | | Browser Cache | HTTP headers | Static assets: 1 year (immutable); HTML: no-cache | | CDN | Cloudflare, CloudFront | Same as browser, purge on deploy | | Application | Redis, Memcached | Varies (e.g., 1 hour for user data) | | Database | Query cache | Automatic | ## Common Mistakes | Mistake | Correct Pattern | | ------------------------------------------------------------ | -------------------------------------------------------------------------------------------------- | | Optimizing before profiling | Measure first with Chrome DevTools, EXPLAIN ANALYZE, or APM tools to find real bottlenecks | | Adding indexes on every column | Use strategic indexes on columns in WHERE, ORDER BY, and JOIN clauses; monitor with slow query log | | SELECT \* on large tables | Select only needed columns to reduce I/O and memory | | N+1 queries in loops | Eager loading or DataLoader batching | | Functions in WHERE clause | Store normalized values, use generated columns to preserve index usage | | Caching without an invalidation strategy | Define TTL and invalidate-on-write policies; stale cache is worse than no cache | | Loading entire libraries for a single utility | Use direct imports and tree-shaking | | Running heavy computations synchronously in request handlers | Offload to background job queues (BullMQ) and return immediately | ## Delegation When working on performance optimization, delegate to: - `frontend-builder` -- React-specific performance patterns - `application-security` -- Rate limiting and DDoS protection - `ci-cd-architecture` -- Build pipeline optimization ## References - [Profiling and Measurement](references/profiling.md) -- Chrome DevTools, React Profiler, Node.js/Python profiling, database EXPLAIN - [Database Optimization](references/database.md) -- Strategic indexes, N+1 fixes, query optimization, connection pooling - [Caching Strategies](references/caching.md) -- Redis patterns, HTTP cache headers, CDN configuration - [Frontend Performance](references/frontend.md) -- Bundle analysis, code splitting, resource hints, third-party scripts, mobile performance, React patterns - [Backend Performance](references/backend.md) -- Serverless optimization, streaming responses, conditional requests, background queues, rate limiting - [Monitoring and Alerting](references/monitoring.md) -- APM tools, custom monitoring, dashboards, alert thresholds
© oakoss · MIT · oakoss/agent-skills
Similar skills
All skills for Backend and APIs →performance-optimizer by other authors comes first.