How can it reduce AI development costs?

By implementing multi-level semantic caching for LLM responses, it can reduce API token costs by up to 95% while drastically lowering response latency.

Can it help improve Lighthouse scores?

Yes, it includes specific strategies for optimizing Core Web Vitals like LCP, INP, and CLS through image optimization, lazy loading, and code splitting.

How does this skill help with slow database queries?

It provides protocols for using EXPLAIN ANALYZE, identifying N+1 problems, and selecting optimal index types like B-tree or HNSW for vector searches.

What technologies are covered by this skill?

The skill features production-ready patterns for FastAPI, React 19, PostgreSQL, Redis, and modern build tools like Vite and Next.js.

Does it support backend profiling?

Absolutely. It includes guides for using tools like cProfile, py-spy, and memory_profiler to detect CPU bottlenecks and memory leaks in Python-based services.

Performance Optimization

Name: Performance Optimization
Author: yonatangross

byyonatangross

•

Analytics & Monitoring

Optimizes application speed and resource usage across the full stack through profiling, database tuning, and frontend analysis.

The Performance Optimization skill provides a comprehensive framework for diagnosing and resolving bottlenecks in modern web applications. It empowers Claude to analyze Core Web Vitals, identify inefficient database queries using EXPLAIN ANALYZE, implement multi-level caching strategies, and reduce frontend bundle sizes. Whether you are dealing with high latency, memory leaks, or scaling challenges, this skill offers production-ready patterns for FastAPI, React 19, and PostgreSQL to ensure peak system performance and reduced operational costs.

Key Features

01Database query optimization and index selection strategies

02Advanced caching patterns including Redis and semantic LLM caching

0369 GitHub stars

04Full-stack profiling for Python backends and React frontends

05Bundle analysis and code-splitting implementation to reduce load times

06Core Web Vitals auditing and remediation for improved UX

Use Cases

01Identifying and fixing slow database queries and N+1 issues in SQLAlchemy or PostgreSQL

02Cutting LLM operational costs through multi-level semantic caching strategies

03Reducing frontend initial load times by optimizing bundles and implementing virtualization

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yonatangross/orchestkit performance-optimization

For use in Claude.ai and ChatGPT

Download Skill