How does this skill identify performance issues?

The skill utilizes profiling tools such as Node.js --prof, Python's cProfile, and Google Lighthouse to gather metrics on slow functions, database queries, and network requests.

Which database types are supported for optimization?

While it provides specific patterns for PostgreSQL (EXPLAIN ANALYZE), the methodology for identifying query bottlenecks can be applied to most SQL and NoSQL database systems.

Can I use this for web performance audits?

Yes, the skill includes built-in workflows for running Lighthouse audits to identify frontend bottlenecks, Core Web Vitals issues, and payload size concerns.

Does this skill automatically change my code?

This skill focuses on analysis and guidance using read-only tools like Grep and Read. It provides recommendations and a checklist for you to implement and validate optimizations safely.

How do I ensure the optimizations actually worked?

The skill includes a 'Validate Improvements' workflow step that guides you through re-measuring performance metrics after changes to ensure a measurable gain in efficiency.

Performance Optimization

Name: Performance Optimization
Author: nicholasgriffintn

bynicholasgriffintn

分析与监控

Analyzes and optimizes software performance across frontend, backend, and database layers to eliminate bottlenecks and increase efficiency.

关于

The Performance Optimisation skill empowers Claude to conduct thorough audits of application codebases, identifying inefficient algorithms, slow database queries, and network latency issues. It provides a structured workflow for measuring baseline performance using industry-standard profiling tools like Node.js profilers, cProfile, and Lighthouse, then guides the implementation of caching strategies, query optimizations, and payload reductions. This skill is essential for developers looking to scale applications, improve user experience, and reduce infrastructure costs through systematic code refinement and data-driven analysis.

主要功能

Structured validation workflow to measure and document improvements
Database query analysis and SQL EXPLAIN optimization
Cross-stack performance auditing for frontend, backend, and databases
0 GitHub stars
Automated bottleneck identification using native profiling commands
Network latency and payload size reduction strategies

使用场景

Refactoring resource-intensive backend algorithms for better scalability
Optimizing slow-loading web applications and high-latency API endpoints
Auditing database performance to resolve complex query bottlenecks

关于

主要功能

Structured validation workflow to measure and document improvements
Database query analysis and SQL EXPLAIN optimization
Cross-stack performance auditing for frontend, backend, and databases
0 GitHub stars
Automated bottleneck identification using native profiling commands
Network latency and payload size reduction strategies

使用场景

Refactoring resource-intensive backend algorithms for better scalability
Optimizing slow-loading web applications and high-latency API endpoints
Auditing database performance to resolve complex query bottlenecks