magento-index-analyst — Claude Code skill: Magento 2 indexing
magento-index-analyst is a Claude Code skill for Magento 2 indexing: reindexing, Elasticsearch setup, and database indexes. It addresses slow catalog browsing or search.
MIT 179 installs ★ 33 updated 2026-01-24
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a claude-codeWhat magento-index-analyst does
The skill goes through indexing inside Magento 2: which core indexers exist, how to rebuild them, where to read their status. It carries the CLI calls bin/magento indexer:reindex, bin/magento indexer:status and bin/magento indexer:reset, an Elasticsearch snippet for app/etc/env.php, and notes on custom indexers built on AbstractIndexer.
Expect four stages. An audit of the current setup and the bottleneck comes first, then a reindexing plan, then configuration, then testing under load. Database work has its own section: composite and covering indexes, query plans read through EXPLAIN, the slow query log, N+1 cleanup.
It advises, it does not patch your code. The sample config names elasticsearch7 as the engine, so a different version means different keys in env.php — budget time for that edit.
What it helps with
- Track down the indexer that stalls catalog reindexing
- Wire Elasticsearch into
app/etc/env.php - Check indexer status before a deploy
- Remove N+1 queries from product page loads
- Design a composite index for a hot query
Example prompts for the agent
- Catalog reindexing drags on — look at the Magento indexers and tell me what to change
- Configure Elasticsearch as the search engine in
app/etc/env.php - Write a custom stock indexer on top of
AbstractIndexer
How to install magento-index-analyst
1Skills CLI (Vercel)
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a claude-code2Manually: put the files in place
~/.claude/skills/magento-index-analyst/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/magento-index-analyst/
1Skills CLI (Vercel)
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a codex2Manually: put the files in place
.agents/skills/magento-index-analyst/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a cursor2Manually: put the files in place
.cursor/skills/magento-index-analyst/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install maxnorm/magento2-agent-skills skills/magento-index-analyst2Manually: put the files in place
.github/skills/magento-index-analyst/SKILL.md1Skills CLI (Vercel)
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a gemini-cli2Platform CLI
gemini skills install https://github.com/maxnorm/magento2-agent-skills --path skills/magento-index-analystManually: put the files in place
.devin/skills/magento-index-analyst/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about magento-index-analyst
How do I install magento-index-analyst in Claude Code?
Run npx skills add maxnorm/magento2-agent-skills --skill magento-index-analyst -a claude-code. The skill file lands at ~/.claude/skills/magento-index-analyst/SKILL.md.
What does magento-index-analyst do?
It covers Magento 2 indexing: indexer types, reindexing strategy, Elasticsearch setup and database indexes. It points at what to change when search or catalog pages slow down.
Which Elasticsearch version does the sample config use?
The snippet sets elasticsearch7 as the engine, with localhost and port 9200. Another version needs its own keys in app/etc/env.php.
Source text
SKILL.md · MIT
---
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.
---
# Magento 2 Index Analyst
Expert specialist in designing and implementing high-performance indexing strategies that dramatically improve search performance, catalog browsing, and overall application responsiveness.
## When to Use
- Optimizing search performance
- Configuring Elasticsearch
- Designing database indexes
- Improving reindexing strategies
- Troubleshooting indexing issues
- Planning indexing architecture
## Magento Indexing Architecture
- **Indexer Types**: Master all Magento indexers and their optimization strategies
- **Index Management**: Expert in index lifecycle management and maintenance
- **Reindexing Strategies**: Optimize reindexing processes and scheduling
- **Index Storage**: Optimize index storage and data structures
- **Performance Monitoring**: Monitor and analyze index performance metrics
## Index Types
### Magento Core Indexers
- **Catalog Product**: Optimize product catalog indexing for fast browsing
- **Catalog Category**: Optimize category hierarchy and navigation indexing
- **Catalog Search**: Optimize search indexing for fast and relevant results
- **Stock Indexer**: Optimize inventory indexing for real-time stock status
- **Price Indexer**: Optimize pricing indexing for dynamic pricing
- **Customer Grid**: Optimize customer data indexing for admin grids
### Custom Indexers
- Create custom indexers for specific business needs
- Implement indexer classes extending `AbstractIndexer`
- Design efficient index data structures
- Optimize index update processes
## Elasticsearch Configuration
### Setup
```php
// app/etc/env.php
'system' => [
'default' => [
'catalog' => [
'search' => [
'engine' => 'elasticsearch7',
'elasticsearch7_server_hostname' => 'localhost',
'elasticsearch7_server_port' => '9200',
'elasticsearch7_index_prefix' => 'magento2',
]
]
]
]
```
### Index Management
```bash
# Reindex all
bin/magento indexer:reindex
# Reindex specific indexer
bin/magento indexer:reindex catalogsearch_fulltext
# Index status
bin/magento indexer:status
# Reset indexer
bin/magento indexer:reset catalogsearch_fulltext
```
## Database Indexing
### Index Strategy
- **Primary Keys**: Design efficient primary key structures
- **Foreign Keys**: Implement proper foreign key relationships
- **Composite Indexes**: Create composite indexes for common queries
- **Covering Indexes**: Design indexes that cover query requirements
- **Index Maintenance**: Regular index maintenance and optimization
### Query Optimization
- **EXPLAIN Analysis**: Analyze query execution plans
- **Slow Query Log**: Monitor and optimize slow queries
- **Index Usage**: Ensure indexes are being used effectively
- **Query Rewriting**: Optimize queries for better index usage
- **N+1 Problem**: Eliminate N+1 query problems
## Index Optimization Process
### 1. Index Assessment & Analysis
- **Current State Analysis**: Assess existing indexing configuration and performance
- **Performance Baseline**: Establish baseline metrics for indexing performance
- **Bottleneck Identification**: Identify indexing bottlenecks and performance issues
- **Usage Pattern Analysis**: Analyze search and browsing usage patterns
- **Capacity Planning**: Plan indexing infrastructure capacity and resources
### 2. Index Strategy Design
- **Indexing Architecture**: Design optimal indexing architecture and topology
- **Reindexing Strategy**: Design efficient reindexing processes and schedules
- **Storage Strategy**: Optimize index storage and data organization
- **Performance Goals**: Define indexing performance targets and SLAs
- **Scalability Planning**: Plan for indexing scalability and growth
### 3. Implementation & Configuration
- **Elasticsearch Setup**: Configure and optimize Elasticsearch clusters
- **Indexer Configuration**: Optimize Magento indexer settings and behavior
- **Database Indexing**: Implement optimal database index strategies
- **Monitoring Setup**: Implement comprehensive indexing monitoring
- **Automation Setup**: Automate indexing processes and maintenance
### 4. Testing & Optimization
- **Performance Testing**: Validate indexing performance improvements
- **Load Testing**: Test indexing behavior under high load conditions
- **Search Quality Testing**: Validate search relevance and accuracy
- **Monitoring Validation**: Verify monitoring and alerting effectiveness
- **Continuous Optimization**: Establish ongoing indexing optimization
## Best Practices
### Reindexing Strategy
- **Scheduled Reindexing**: Schedule reindexing during low-traffic periods
- **Incremental Reindexing**: Use incremental reindexing when possible
- **Parallel Reindexing**: Run independent indexers in parallel
- **Reindexing Monitoring**: Monitor reindexing performance and failures
- **Rollback Planning**: Plan for reindexing failures and rollbacks
### Elasticsearch Optimization
- **Cluster Configuration**: Optimize Elasticsearch cluster settings
- **Shard Strategy**: Design optimal shard allocation
- **Replica Configuration**: Configure appropriate replica counts
- **Query Optimization**: Optimize search queries and aggregations
- **Index Mapping**: Design efficient search index mappings
### Database Index Optimization
- **Index Design**: Design indexes based on query patterns
- **Index Maintenance**: Regular index maintenance and optimization
- **Query Analysis**: Analyze and optimize slow queries
- **Index Monitoring**: Monitor index usage and effectiveness
- **Performance Tuning**: Tune database for optimal index performance
## Monitoring
- **Index Status**: Monitor indexer status and health
- **Reindexing Performance**: Track reindexing duration and resource usage
- **Search Performance**: Monitor search query performance
- **Index Size**: Monitor index storage size and growth
- **Error Monitoring**: Monitor indexing errors and failures
## References
- [Adobe Commerce Indexing](https://developer.adobe.com/commerce/php/development/components/indexing/)
- [Elasticsearch](https://developer.adobe.com/commerce/php/development/components/indexing/elasticsearch/)
- [Custom Indexers](https://developer.adobe.com/commerce/php/development/components/indexing/custom-indexer/)
Focus on creating high-performance indexing strategies that improve search and browsing performance.
© maxnorm · MIT · maxnorm/magento2-agent-skills