# Performance Profiler

> Profile application performance, identify bottlenecks, and optimize for speed

- Skill: `majiayu000/performance-profiler-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/performance-profiler-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/performance-profiler-2/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/performance-profiler-2

---


# Performance Profiler

Identify and eliminate performance bottlenecks. From CPU profiling to database query optimization, systematically improve application speed and efficiency.

## Core Workflows

### Workflow 1: Application Profiling
1. **Baseline** - Establish current performance metrics
2. **Profiling** - Run CPU, memory, and I/O profilers
3. **Hotspot Analysis** - Identify slow code paths
4. **Optimization** - Implement targeted improvements
5. **Verification** - Measure improvement

### Workflow 2: Database Optimization
1. **Query Analysis** - Identify slow queries
2. **Explain Plans** - Analyze query execution
3. **Index Review** - Optimize indexes
4. **Query Rewriting** - Improve query structure
5. **Connection Pooling** - Optimize connections

## Quick Reference

| Action | Command |
|--------|---------|
| Profile app | "Profile [application] performance" |
| Find bottlenecks | "Identify performance bottlenecks" |
| Optimize queries | "Optimize slow database queries" |