{"id":"6f9ee65d-62d9-4968-b3c2-257960a4ee38","shortId":"jC5sFQ","kind":"skill","title":"magento-index-analyst","tagline":"Optimizes Magento 2 indexing for search performance and database efficiency. Use when optimizing search performance, configuring Elasticsearch, designing database indexes, or improving reindexing strategies. Masters indexer optimization, Elasticsearch configuration, and database ","description":"# Magento 2 Index Analyst\n\nExpert specialist in designing and implementing high-performance indexing strategies that dramatically improve search performance, catalog browsing, and overall application responsiveness.\n\n## When to Use\n\n- Optimizing search performance\n- Configuring Elasticsearch\n- Designing database indexes\n- Improving reindexing strategies\n- Troubleshooting indexing issues\n- Planning indexing architecture\n\n## Magento Indexing Architecture\n\n- **Indexer Types**: Master all Magento indexers and their optimization strategies\n- **Index Management**: Expert in index lifecycle management and maintenance\n- **Reindexing Strategies**: Optimize reindexing processes and scheduling\n- **Index Storage**: Optimize index storage and data structures\n- **Performance Monitoring**: Monitor and analyze index performance metrics\n\n## Index Types\n\n### Magento Core Indexers\n- **Catalog Product**: Optimize product catalog indexing for fast browsing\n- **Catalog Category**: Optimize category hierarchy and navigation indexing\n- **Catalog Search**: Optimize search indexing for fast and relevant results\n- **Stock Indexer**: Optimize inventory indexing for real-time stock status\n- **Price Indexer**: Optimize pricing indexing for dynamic pricing\n- **Customer Grid**: Optimize customer data indexing for admin grids\n\n### Custom Indexers\n- Create custom indexers for specific business needs\n- Implement indexer classes extending `AbstractIndexer`\n- Design efficient index data structures\n- Optimize index update processes\n\n## Elasticsearch Configuration\n\n### Setup\n```php\n// app/etc/env.php\n'system' => [\n    'default' => [\n        'catalog' => [\n            'search' => [\n                'engine' => 'elasticsearch7',\n                'elasticsearch7_server_hostname' => 'localhost',\n                'elasticsearch7_server_port' => '9200',\n                'elasticsearch7_index_prefix' => 'magento2',\n            ]\n        ]\n    ]\n]\n```\n\n### Index Management\n```bash\n# Reindex all\nbin/magento indexer:reindex\n\n# Reindex specific indexer\nbin/magento indexer:reindex catalogsearch_fulltext\n\n# Index status\nbin/magento indexer:status\n\n# Reset indexer\nbin/magento indexer:reset catalogsearch_fulltext\n```\n\n## Database Indexing\n\n### Index Strategy\n- **Primary Keys**: Design efficient primary key structures\n- **Foreign Keys**: Implement proper foreign key relationships\n- **Composite Indexes**: Create composite indexes for common queries\n- **Covering Indexes**: Design indexes that cover query requirements\n- **Index Maintenance**: Regular index maintenance and optimization\n\n### Query Optimization\n- **EXPLAIN Analysis**: Analyze query execution plans\n- **Slow Query Log**: Monitor and optimize slow queries\n- **Index Usage**: Ensure indexes are being used effectively\n- **Query Rewriting**: Optimize queries for better index usage\n- **N+1 Problem**: Eliminate N+1 query problems\n\n## Index Optimization Process\n\n### 1. Index Assessment & Analysis\n- **Current State Analysis**: Assess existing indexing configuration and performance\n- **Performance Baseline**: Establish baseline metrics for indexing performance\n- **Bottleneck Identification**: Identify indexing bottlenecks and performance issues\n- **Usage Pattern Analysis**: Analyze search and browsing usage patterns\n- **Capacity Planning**: Plan indexing infrastructure capacity and resources\n\n### 2. Index Strategy Design\n- **Indexing Architecture**: Design optimal indexing architecture and topology\n- **Reindexing Strategy**: Design efficient reindexing processes and schedules\n- **Storage Strategy**: Optimize index storage and data organization\n- **Performance Goals**: Define indexing performance targets and SLAs\n- **Scalability Planning**: Plan for indexing scalability and growth\n\n### 3. Implementation & Configuration\n- **Elasticsearch Setup**: Configure and optimize Elasticsearch clusters\n- **Indexer Configuration**: Optimize Magento indexer settings and behavior\n- **Database Indexing**: Implement optimal database index strategies\n- **Monitoring Setup**: Implement comprehensive indexing monitoring\n- **Automation Setup**: Automate indexing processes and maintenance\n\n### 4. Testing & Optimization\n- **Performance Testing**: Validate indexing performance improvements\n- **Load Testing**: Test indexing behavior under high load conditions\n- **Search Quality Testing**: Validate search relevance and accuracy\n- **Monitoring Validation**: Verify monitoring and alerting effectiveness\n- **Continuous Optimization**: Establish ongoing indexing optimization\n\n## Best Practices\n\n### Reindexing Strategy\n- **Scheduled Reindexing**: Schedule reindexing during low-traffic periods\n- **Incremental Reindexing**: Use incremental reindexing when possible\n- **Parallel Reindexing**: Run independent indexers in parallel\n- **Reindexing Monitoring**: Monitor reindexing performance and failures\n- **Rollback Planning**: Plan for reindexing failures and rollbacks\n\n### Elasticsearch Optimization\n- **Cluster Configuration**: Optimize Elasticsearch cluster settings\n- **Shard Strategy**: Design optimal shard allocation\n- **Replica Configuration**: Configure appropriate replica counts\n- **Query Optimization**: Optimize search queries and aggregations\n- **Index Mapping**: Design efficient search index mappings\n\n### Database Index Optimization\n- **Index Design**: Design indexes based on query patterns\n- **Index Maintenance**: Regular index maintenance and optimization\n- **Query Analysis**: Analyze and optimize slow queries\n- **Index Monitoring**: Monitor index usage and effectiveness\n- **Performance Tuning**: Tune database for optimal index performance\n\n## Monitoring\n\n- **Index Status**: Monitor indexer status and health\n- **Reindexing Performance**: Track reindexing duration and resource usage\n- **Search Performance**: Monitor search query performance\n- **Index Size**: Monitor index storage size and growth\n- **Error Monitoring**: Monitor indexing errors and failures\n\n## References\n\n- [Adobe Commerce Indexing](https://developer.adobe.com/commerce/php/development/components/indexing/)\n- [Elasticsearch](https://developer.adobe.com/commerce/php/development/components/indexing/elasticsearch/)\n- [Custom Indexers](https://developer.adobe.com/commerce/php/development/components/indexing/custom-indexer/)\n\nFocus on creating high-performance indexing strategies that improve search and browsing performance.","tags":["magento","index","analyst","magento2","agent","skills","maxnorm","agent-skills"],"capabilities":["skill","source-maxnorm","skill-magento-index-analyst","topic-agent-skills","topic-magento2"],"categories":["magento2-agent-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/maxnorm/magento2-agent-skills/magento-index-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 (6,367 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:49.360Z","embedding":null,"createdAt":"2026-05-07T20:44:27.722Z","updatedAt":"2026-05-18T19:08:49.360Z","lastSeenAt":"2026-05-18T19:08:49.360Z","tsv":"'+1':335,339 '/commerce/php/development/components/indexing/)':671 '/commerce/php/development/components/indexing/custom-indexer/)':680 '/commerce/php/development/components/indexing/elasticsearch/)':675 '1':345 '2':7,37,391 '3':435 '4':473 '9200':228 'abstractindex':200 'accuraci':498 'admin':185 'adob':666 'aggreg':580 'alert':504 'alloc':567 'analysi':305,348,351,376,607 'analyst':4,39 'analyz':123,306,377,608 'app/etc/env.php':214 'applic':60 'appropri':571 'architectur':81,84,396,400 'assess':347,352 'autom':466,468 'base':595 'baselin':359,361 'bash':235 'behavior':452,486 'best':512 'better':331 'bin/magento':238,244,251,256 'bottleneck':366,370 'brows':57,140,380,693 'busi':194 'capac':383,388 'catalog':56,132,136,141,149,217 'catalogsearch':247,259 'categori':142,144 'class':198 'cluster':444,556,560 'commerc':667 'common':285 'composit':279,282 'comprehens':463 'condit':490 'configur':20,33,68,211,355,437,440,446,557,569,570 'continu':506 'core':130 'count':573 'cover':287,292 'creat':189,281,683 'current':349 'custom':178,181,187,190,676 'data':117,182,204,417 'databas':13,23,35,71,261,453,457,588,623 'default':216 'defin':421 'design':22,43,70,201,267,289,394,397,405,564,583,592,593 'developer.adobe.com':670,674,679 'developer.adobe.com/commerce/php/development/components/indexing/)':669 'developer.adobe.com/commerce/php/development/components/indexing/custom-indexer/)':678 'developer.adobe.com/commerce/php/development/components/indexing/elasticsearch/)':673 'dramat':52 'durat':640 'dynam':176 'effect':325,505,619 'effici':14,202,268,406,584 'elasticsearch':21,32,69,210,438,443,554,559,672 'elasticsearch7':220,221,225,229 'elimin':337 'engin':219 'ensur':320 'error':658,662 'establish':360,508 'execut':308 'exist':353 'expert':40,97 'explain':304 'extend':199 'failur':545,551,664 'fast':139,155 'focus':681 'foreign':272,276 'fulltext':248,260 'goal':420 'grid':179,186 'growth':434,657 'health':635 'hierarchi':145 'high':47,488,685 'high-perform':46,684 'hostnam':223 'identif':367 'identifi':368 'implement':45,196,274,436,455,462 'improv':26,53,73,481,690 'increment':525,528 'independ':535 'index':3,8,24,30,38,49,72,77,80,83,85,90,95,99,111,114,124,127,131,137,148,153,160,163,171,174,183,188,191,197,203,207,230,233,239,243,245,249,252,255,257,262,263,280,283,288,290,295,298,318,321,332,342,346,354,364,369,386,392,395,399,414,422,431,445,449,454,458,464,469,479,485,510,536,581,586,589,591,594,599,602,613,616,626,629,632,650,653,661,668,677,687 'infrastructur':387 'inventori':162 'issu':78,373 'key':266,270,273,277 'lifecycl':100 'load':482,489 'localhost':224 'log':312 'low':522 'low-traff':521 'magento':2,6,36,82,89,129,448 'magento-index-analyst':1 'magento2':232 'mainten':103,296,299,472,600,603 'manag':96,101,234 'map':582,587 'master':29,87 'metric':126,362 'monitor':120,121,313,460,465,499,502,540,541,614,615,628,631,646,652,659,660 'n':334,338 'navig':147 'need':195 'ongo':509 'optim':5,17,31,65,93,106,113,134,143,151,161,172,180,206,301,303,315,328,343,398,413,442,447,456,475,507,511,555,558,565,575,576,590,605,610,625 'organ':418 'overal':59 'parallel':532,538 'pattern':375,382,598 'perform':11,19,48,55,67,119,125,357,358,365,372,419,423,476,480,543,620,627,637,645,649,686,694 'period':524 'php':213 'plan':79,309,384,385,428,429,547,548 'port':227 'possibl':531 'practic':513 'prefix':231 'price':170,173,177 'primari':265,269 'problem':336,341 'process':108,209,344,408,470 'product':133,135 'proper':275 'qualiti':492 'queri':286,293,302,307,311,317,326,329,340,574,578,597,606,612,648 'real':166 'real-tim':165 'refer':665 'regular':297,601 'reindex':27,74,104,107,236,240,241,246,403,407,514,517,519,526,529,533,539,542,550,636,639 'relationship':278 'relev':157,496 'replica':568,572 'requir':294 'reset':254,258 'resourc':390,642 'respons':61 'result':158 'rewrit':327 'rollback':546,553 'run':534 'scalabl':427,432 'schedul':110,410,516,518 'search':10,18,54,66,150,152,218,378,491,495,577,585,644,647,691 'server':222,226 'set':450,561 'setup':212,439,461,467 'shard':562,566 'size':651,655 'skill' 'skill-magento-index-analyst' 'slas':426 'slow':310,316,611 'source-maxnorm' 'specialist':41 'specif':193,242 'state':350 'status':169,250,253,630,633 'stock':159,168 'storag':112,115,411,415,654 'strategi':28,50,75,94,105,264,393,404,412,459,515,563,688 'structur':118,205,271 'system':215 'target':424 'test':474,477,483,484,493 'time':167 'topic-agent-skills' 'topic-magento2' 'topolog':402 'track':638 'traffic':523 'troubleshoot':76 'tune':621,622 'type':86,128 'updat':208 'usag':319,333,374,381,617,643 'use':15,64,324,527 'valid':478,494,500 'verifi':501","prices":[{"id":"c9ba1d11-0857-4b1e-b4fd-a2c77ac22741","listingId":"6f9ee65d-62d9-4968-b3c2-257960a4ee38","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:44:27.722Z"}],"sources":[{"listingId":"6f9ee65d-62d9-4968-b3c2-257960a4ee38","source":"github","sourceId":"maxnorm/magento2-agent-skills/magento-index-analyst","sourceUrl":"https://github.com/maxnorm/magento2-agent-skills/tree/main/skills/magento-index-analyst","isPrimary":false,"firstSeenAt":"2026-05-18T13:14:28.736Z","lastSeenAt":"2026-05-18T19:08:49.360Z"},{"listingId":"6f9ee65d-62d9-4968-b3c2-257960a4ee38","source":"skills_sh","sourceId":"maxnorm/magento2-agent-skills/magento-index-analyst","sourceUrl":"https://skills.sh/maxnorm/magento2-agent-skills/magento-index-analyst","isPrimary":true,"firstSeenAt":"2026-05-07T20:44:27.722Z","lastSeenAt":"2026-05-07T22:42:48.401Z"}],"details":{"listingId":"6f9ee65d-62d9-4968-b3c2-257960a4ee38","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"maxnorm","slug":"magento-index-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":"4724f1fb50828c1871c0d97ee79acbf80d47e38e","skill_md_path":"skills/magento-index-analyst/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/maxnorm/magento2-agent-skills/tree/main/skills/magento-index-analyst"},"layout":"multi","source":"github","category":"magento2-agent-skills","frontmatter":{"name":"magento-index-analyst","description":"Optimizes Magento 2 indexing for search performance and database efficiency. Use when optimizing search performance, configuring Elasticsearch, designing database indexes, or improving reindexing strategies. Masters indexer optimization, Elasticsearch configuration, and database indexing."},"skills_sh_url":"https://skills.sh/maxnorm/magento2-agent-skills/magento-index-analyst"},"updatedAt":"2026-05-18T19:08:49.360Z"}}