Can this skill help with slow database queries?

Yes, it provides strategies for using EXPLAIN ANALYZE in SQL and debug logging in Mongoose to identify missing indexes and join strategy problems.

What is the primary methodology taught by this skill?

The core philosophy is 'Profile first, optimize second'—providing a structured step-by-step approach to characterize symptoms before applying code changes.

How does this skill help identify memory leaks?

The skill provides specific code snippets for monitoring heap usage over time and instructions for generating and analyzing heap snapshots via Chrome DevTools to find retained objects.

Which Node.js profiling tools are supported?

It includes implementation guides for Clinic.js, 0x, the built-in V8 profiler, and autocannon for load testing.

Performance Profiling & Optimization

Name: Performance Profiling & Optimization
Author: chavangorakh1999

bychavangorakh1999

0•

分析と監視

Diagnoses and resolves performance bottlenecks, memory leaks, and inefficient algorithms in Node.js applications.

This skill provides a systematic framework for identifying and fixing software performance issues. It guides users through characterizing symptoms, performing CPU and memory profiling using tools like Clinic.js and 0x, and conducting Big-O complexity analysis. By offering structured methodologies for reading flame graphs, detecting memory leaks, and optimizing database queries with EXPLAIN ANALYZE, it ensures that developers optimize based on empirical data rather than guesswork.

主な機能

01Algorithmic complexity (Big-O) analysis and practical O(n) replacement patterns

02Node.js CPU and memory profiling using Clinic.js, 0x, and V8 built-ins

03Detailed flame graph interpretation for identifying code hotspots

04Database query optimization including EXPLAIN ANALYZE and N+1 detection

050 GitHub stars

06HTTP endpoint benchmarking and latency percentile analysis with autocannon

ユースケース

01Diagnosing and fixing memory leaks in long-running Node.js background processes

02Identifying the root cause of high P99 latency or sudden spikes in API response times

03Refactoring O(n²) loops and inefficient data structures to support high-scale traffic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add chavangorakh1999/sde-skills performance-profiling

For use in Claude.ai and ChatGPT

主な機能

01Algorithmic complexity (Big-O) analysis and practical O(n) replacement patterns

02Node.js CPU and memory profiling using Clinic.js, 0x, and V8 built-ins

03Detailed flame graph interpretation for identifying code hotspots

04Database query optimization including EXPLAIN ANALYZE and N+1 detection

050 GitHub stars

06HTTP endpoint benchmarking and latency percentile analysis with autocannon

ユースケース

01Diagnosing and fixing memory leaks in long-running Node.js background processes

02Identifying the root cause of high P99 latency or sudden spikes in API response times

03Refactoring O(n²) loops and inefficient data structures to support high-scale traffic

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add chavangorakh1999/sde-skills performance-profiling

For use in Claude.ai and ChatGPT