How does this skill handle performance bottlenecks?

It follows a rigorous 6-step process: defining measurable goals, establishing baselines, identifying bottlenecks via profiling tools, implementing targeted fixes, verifying improvements, and documenting the impact.

What layers of caching does this skill cover?

It provides guidance on CDN headers, Redis cache-aside patterns, in-memory caches (like Caffeine or LRU), and advanced strategies for cache invalidation and stampede prevention.

Why is profiling data mandatory for this skill?

To prevent premature optimization and ensure that engineering efforts are focused on hot paths and actual bottlenecks rather than low-impact code segments.

Can it help with database performance specifically?

Yes, it includes specialized references for PostgreSQL and MySQL query plans, index selection, slow query diagnosis, and connection pooling tools like PgBouncer or HikariCP.

Does it support frontend performance tuning?

Absolutely. It offers patterns for optimizing Core Web Vitals (LCP, INP, CLS), implementing efficient code splitting, and managing network protocols and asset compression.

Performance Optimization Specialist

Name: Performance Optimization Specialist
Author: rnavarych

byrnavarych

•

Analíticas y Monitorización

Optimizes system performance through data-driven profiling, multi-layer caching strategies, and database query tuning.

The alpha-core performance-optimization skill transforms Claude into a specialized performance engineer capable of diagnosing and resolving bottlenecks across the entire stack. It enforces a strict methodology of measuring before optimizing, guiding users through goal setting, baseline establishment, and verified implementation of fixes for CPU, memory, I/O, and network issues. Whether you are dealing with slow database queries, frontend Core Web Vitals, or backend scaling challenges, this skill provides the systematic frameworks and reference architectures needed to achieve production-grade performance results.

Características Principales

019 GitHub stars

02Full-stack profiling for CPU, memory, and I/O bottlenecks

03Database query optimization using EXPLAIN ANALYZE and advanced indexing

04Multi-tier caching implementation including CDN, Redis, and application layers

05Frontend tuning for Core Web Vitals, code splitting, and asset delivery

06Infrastructure scaling guidance covering load balancing and connection pooling

Casos de Uso

01Reducing API p99 latency and increasing throughput for high-traffic services

02Identifying and resolving memory leaks or high CPU usage in backend microservices

03Optimizing database execution plans and connection management for scale

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer performance-optimization

For use in Claude.ai and ChatGPT

Características Principales

019 GitHub stars

02Full-stack profiling for CPU, memory, and I/O bottlenecks

03Database query optimization using EXPLAIN ANALYZE and advanced indexing

04Multi-tier caching implementation including CDN, Redis, and application layers

05Frontend tuning for Core Web Vitals, code splitting, and asset delivery

06Infrastructure scaling guidance covering load balancing and connection pooling

Casos de Uso

01Reducing API p99 latency and increasing throughput for high-traffic services

02Identifying and resolving memory leaks or high CPU usage in backend microservices

03Optimizing database execution plans and connection management for scale