{"id":"e74ffe1a-e56a-479e-89f6-67ec1413fe55","shortId":"hX46nQ","kind":"skill","title":"magento-performance-analyst","tagline":"Conducts comprehensive Magento 2 performance analysis and optimization. Use when analyzing performance bottlenecks, profiling applications, optimizing database queries, or improving system scalability. Masters profiling tools, database optimization, and enterprise-scale performan","description":"# Magento 2 Performance Analyst\n\nExpert specialist in conducting comprehensive performance analysis and implementing systematic optimizations that deliver measurable improvements in application speed, scalability, and user experience.\n\n## When to Use\n\n- Analyzing performance bottlenecks\n- Profiling applications\n- Optimizing database queries\n- Improving system scalability\n- Conducting load testing\n- Optimizing frontend performance\n\n## Performance Analysis\n\n### Profiling Tools\n- **Blackfire**: Performance profiling and optimization\n- **XHProf**: PHP profiling tool\n- **New Relic**: APM monitoring\n- **Browser DevTools**: Frontend performance analysis\n- **Database Profiling**: Query profiling and analysis\n\n### Bottleneck Identification\n- **Code Profiling**: Identify slow functions and performance hotspots\n- **Database Analysis**: Analyze slow queries and database performance\n- **Network Analysis**: Identify network latency and bandwidth issues\n- **Resource Contention**: Identify resource conflicts and bottlenecks\n- **Third-party Integration**: Analyze external service performance impact\n\n## Performance Optimization Areas\n\n### Frontend Performance\n- **Core Web Vitals**: Optimize LCP, FID, CLS, and other web vitals\n- **JavaScript Optimization**: Minimize and optimize JavaScript execution\n- **CSS Optimization**: Optimize stylesheet delivery and rendering\n- **Image Optimization**: Modern image formats and responsive loading\n- **Asset Optimization**: Minimize and compress assets\n\n### Database Optimization\n- **Query Optimization**: Optimize database queries and eliminate N+1 problems\n- **Index Strategy**: Design efficient database indexing\n- **Connection Pooling**: Optimize database connection management\n- **Query Caching**: Implement query result caching\n- **Database Tuning**: Tune database configuration for performance\n\n### Application Optimization\n- **Code Optimization**: Optimize PHP code execution\n- **Memory Management**: Optimize memory usage and detect leaks\n- **Caching Strategy**: Implement comprehensive caching strategies\n- **Resource Management**: Optimize CPU, I/O, and network resources\n- **Lazy Loading**: Implement lazy loading for expensive operations\n\n## Performance Analysis Process\n\n### 1. Performance Assessment\n- **Baseline Establishment**: Establish current performance baselines and metrics\n- **User Experience Analysis**: Analyze real user performance and experience\n- **System Resource Analysis**: Assess CPU, memory, disk, and network usage\n- **Application Profiling**: Deep application profiling and code analysis\n- **Infrastructure Assessment**: Evaluate infrastructure performance and capacity\n\n### 2. Bottleneck Identification\n- **Code Profiling**: Identify slow functions and performance hotspots\n- **Database Analysis**: Analyze slow queries and database performance\n- **Network Analysis**: Identify network latency and bandwidth issues\n- **Resource Contention**: Identify resource conflicts and bottlenecks\n- **Third-party Integration**: Analyze external service performance impact\n\n### 3. Optimization Planning\n- **Priority Matrix**: Prioritize optimizations based on impact and effort\n- **Resource Planning**: Plan resource requirements for optimizations\n- **Risk Assessment**: Assess risks associated with performance changes\n- **Testing Strategy**: Plan comprehensive testing for optimization changes\n- **Rollback Planning**: Prepare rollback strategies for optimization failures\n\n### 4. Implementation & Validation\n- **Optimization Implementation**: Implement systematic performance improvements\n- **Performance Testing**: Validate optimization effectiveness through testing\n- **Monitoring Setup**: Implement monitoring for sustained performance\n- **Documentation**: Document optimization changes and performance gains\n- **Continuous Monitoring**: Establish ongoing performance monitoring\n\n## Performance Metrics\n\n### Key Metrics\n- **Page Load Time**: Total page load time\n- **Time to First Byte (TTFB)**: Server response time\n- **Largest Contentful Paint (LCP)**: Loading performance\n- **First Input Delay (FID)**: Interactivity\n- **Cumulative Layout Shift (CLS)**: Visual stability\n\n### Database Metrics\n- **Query Execution Time**: Database query performance\n- **Slow Query Count**: Number of slow queries\n- **Connection Pool Usage**: Database connection efficiency\n- **Index Usage**: Index effectiveness\n- **Cache Hit Rate**: Cache performance\n\n## Best Practices\n\n### Optimization Strategy\n- **Measure First**: Always measure before optimizing\n- **Prioritize High Impact**: Focus on optimizations with highest impact\n- **Incremental Approach**: Make incremental improvements\n- **Test Thoroughly**: Test all optimizations thoroughly\n- **Monitor Continuously**: Monitor performance continuously\n\n### Scalability Planning\n- **Horizontal Scaling**: Design for horizontal scaling\n- **Vertical Scaling**: Optimize for vertical scaling when needed\n- **Load Balancing**: Implement proper load balancing\n- **Resource Planning**: Plan for resource growth\n- **Performance Budgets**: Set and maintain performance budgets\n\n## Tools & Commands\n\n### Profiling Commands\n```bash\n# Enable developer mode for profiling\nbin/magento deploy:mode:set developer\n\n# Check performance\nbin/magento setup:performance:generate-fixtures\n\n# Database status\nbin/magento setup:db:status\n```\n\n### Monitoring\n- Set up APM tools (New Relic, Datadog, etc.)\n- Monitor server resources (CPU, memory, disk)\n- Track application metrics\n- Set up alerts for performance degradation\n\n## References\n\n- [Adobe Commerce Performance Best Practices](https://developer.adobe.com/commerce/php/best-practices/performance/)\n- [Performance Testing](https://developer.adobe.com/commerce/php/development/testing/performance/)\n\nFocus on systematic performance analysis and optimization that delivers measurable improvements.","tags":["magento","performance","analyst","magento2","agent","skills","maxnorm","agent-skills"],"capabilities":["skill","source-maxnorm","skill-magento-performance-analyst","topic-agent-skills","topic-magento2"],"categories":["magento2-agent-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/maxnorm/magento2-agent-skills/magento-performance-analyst","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add maxnorm/magento2-agent-skills","source_repo":"https://github.com/maxnorm/magento2-agent-skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 9 github stars · SKILL.md body (5,832 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:08:50.141Z","embedding":null,"createdAt":"2026-05-07T20:42:51.058Z","updatedAt":"2026-05-18T19:08:50.141Z","lastSeenAt":"2026-05-18T19:08:50.141Z","tsv":"'+1':207 '/commerce/php/best-practices/performance/)':639 '/commerce/php/development/testing/performance/)':644 '1':275 '2':8,38,320 '3':363 '4':406 'adob':632 'alert':627 'alway':514 'analysi':10,47,84,104,110,122,130,273,288,297,312,332,340,649 'analyst':4,40 'analyz':15,66,123,148,289,333,358 'apm':98,610 'applic':19,57,70,234,305,308,623 'approach':528 'area':155 'assess':277,298,314,383,384 'asset':191,196 'associ':386 'balanc':560,564 'bandwidth':135,345 'base':370 'baselin':278,283 'bash':582 'best':508,635 'bin/magento':588,595,603 'blackfir':87 'bottleneck':17,68,111,143,321,353 'browser':100 'budget':572,577 'byte':456 'cach':222,226,250,254,503,506 'capac':319 'chang':389,397,432 'check':593 'cls':164,475 'code':113,236,240,311,323 'command':579,581 'commerc':633 'comprehens':6,45,253,393 'compress':195 'conduct':5,44,77 'configur':231 'conflict':141,351 'connect':215,219,493,497 'content':138,348,462 'continu':436,539,542 'core':158 'count':488 'cpu':259,299,619 'css':176 'cumul':472 'current':281 'databas':21,30,72,105,121,127,197,202,213,218,227,230,331,337,478,483,496,601 'datadog':614 'db':605 'deep':307 'degrad':630 'delay':469 'deliv':53,653 'deliveri':180 'deploy':589 'design':211,547 'detect':248 'develop':584,592 'developer.adobe.com':638,643 'developer.adobe.com/commerce/php/best-practices/performance/)':637 'developer.adobe.com/commerce/php/development/testing/performance/)':642 'devtool':101 'disk':301,621 'document':429,430 'effect':419,502 'effici':212,498 'effort':374 'elimin':205 'enabl':583 'enterpris':34 'enterprise-scal':33 'establish':279,280,438 'etc':615 'evalu':315 'execut':175,241,481 'expens':270 'experi':62,287,294 'expert':41 'extern':149,359 'failur':405 'fid':163,470 'first':455,467,513 'fixtur':600 'focus':521,645 'format':187 'frontend':81,102,156 'function':117,327 'gain':435 'generat':599 'generate-fixtur':598 'growth':570 'high':519 'highest':525 'hit':504 'horizont':545,549 'hotspot':120,330 'i/o':260 'identif':112,322 'identifi':115,131,139,325,341,349 'imag':183,186 'impact':152,362,372,520,526 'implement':49,223,252,266,407,410,411,424,561 'improv':24,55,74,414,531,655 'increment':527,530 'index':209,214,499,501 'infrastructur':313,316 'input':468 'integr':147,357 'interact':471 'issu':136,346 'javascript':169,174 'key':444 'largest':461 'latenc':133,343 'layout':473 'lazi':264,267 'lcp':162,464 'leak':249 'load':78,190,265,268,447,451,465,559,563 'magento':2,7,37 'magento-performance-analyst':1 'maintain':575 'make':529 'manag':220,243,257 'master':27 'matrix':367 'measur':54,512,515,654 'memori':242,245,300,620 'metric':285,443,445,479,624 'minim':171,193 'mode':585,590 'modern':185 'monitor':99,422,425,437,441,538,540,607,616 'n':206 'need':558 'network':129,132,262,303,339,342 'new':96,612 'number':489 'ongo':439 'oper':271 'optim':12,20,31,51,71,80,91,154,161,170,173,177,178,184,192,198,200,201,217,235,237,238,244,258,364,369,381,396,404,409,418,431,510,517,523,536,553,651 'page':446,450 'paint':463 'parti':146,356 'perform':3,9,16,39,46,67,82,83,88,103,119,128,151,153,157,233,272,276,282,292,317,329,338,361,388,413,415,428,434,440,442,466,485,507,541,571,576,594,597,629,634,640,648 'performan':36 'php':93,239 'plan':365,376,377,392,399,544,566,567 'pool':216,494 'practic':509,636 'prepar':400 'priorit':368,518 'prioriti':366 'problem':208 'process':274 'profil':18,28,69,85,89,94,106,108,114,306,309,324,580,587 'proper':562 'queri':22,73,107,125,199,203,221,224,335,480,484,487,492 'rate':505 'real':290 'refer':631 'relic':97,613 'render':182 'requir':379 'resourc':137,140,256,263,296,347,350,375,378,565,569,618 'respons':189,459 'result':225 'risk':382,385 'rollback':398,401 'scalabl':26,59,76,543 'scale':35,546,550,552,556 'server':458,617 'servic':150,360 'set':573,591,608,625 'setup':423,596,604 'shift':474 'skill' 'skill-magento-performance-analyst' 'slow':116,124,326,334,486,491 'source-maxnorm' 'specialist':42 'speed':58 'stabil':477 'status':602,606 'strategi':210,251,255,391,402,511 'stylesheet':179 'sustain':427 'system':25,75,295 'systemat':50,412,647 'test':79,390,394,416,421,532,534,641 'third':145,355 'third-parti':144,354 'thorough':533,537 'time':448,452,453,460,482 'tool':29,86,95,578,611 'topic-agent-skills' 'topic-magento2' 'total':449 'track':622 'ttfb':457 'tune':228,229 'usag':246,304,495,500 'use':13,65 'user':61,286,291 'valid':408,417 'vertic':551,555 'visual':476 'vital':160,168 'web':159,167 'xhprof':92","prices":[{"id":"56af5cd1-abd7-44f5-9d90-5fb1f15cf553","listingId":"e74ffe1a-e56a-479e-89f6-67ec1413fe55","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"maxnorm","category":"magento2-agent-skills","install_from":"skills.sh"},"createdAt":"2026-05-07T20:42:51.058Z"}],"sources":[{"listingId":"e74ffe1a-e56a-479e-89f6-67ec1413fe55","source":"github","sourceId":"maxnorm/magento2-agent-skills/magento-performance-analyst","sourceUrl":"https://github.com/maxnorm/magento2-agent-skills/tree/main/skills/magento-performance-analyst","isPrimary":false,"firstSeenAt":"2026-05-18T13:14:29.589Z","lastSeenAt":"2026-05-18T19:08:50.141Z"},{"listingId":"e74ffe1a-e56a-479e-89f6-67ec1413fe55","source":"skills_sh","sourceId":"maxnorm/magento2-agent-skills/magento-performance-analyst","sourceUrl":"https://skills.sh/maxnorm/magento2-agent-skills/magento-performance-analyst","isPrimary":true,"firstSeenAt":"2026-05-07T20:42:51.058Z","lastSeenAt":"2026-05-07T22:41:49.903Z"}],"details":{"listingId":"e74ffe1a-e56a-479e-89f6-67ec1413fe55","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"maxnorm","slug":"magento-performance-analyst","github":{"repo":"maxnorm/magento2-agent-skills","stars":9,"topics":["agent-skills","magento2"],"license":"mit","html_url":"https://github.com/maxnorm/magento2-agent-skills","pushed_at":"2026-01-24T16:45:35Z","description":"A collection of specialized agent skills for Magento 2 development, designed to provide domain expertise across all aspects of Magento/Adobe Commerce development workflows. ","skill_md_sha":"9eed67fdc98b05d2d972606606a4923069aa02fb","skill_md_path":"skills/magento-performance-analyst/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/maxnorm/magento2-agent-skills/tree/main/skills/magento-performance-analyst"},"layout":"multi","source":"github","category":"magento2-agent-skills","frontmatter":{"name":"magento-performance-analyst","description":"Conducts comprehensive Magento 2 performance analysis and optimization. Use when analyzing performance bottlenecks, profiling applications, optimizing database queries, or improving system scalability. Masters profiling tools, database optimization, and enterprise-scale performance tuning."},"skills_sh_url":"https://skills.sh/maxnorm/magento2-agent-skills/magento-performance-analyst"},"updatedAt":"2026-05-18T19:08:50.141Z"}}