SKILL.md
This skill provides efficient database query execution for Magento 2 data analysis.
What This Skill Does
- Catalog Data Queries
- Product counts by type, status, visibility - Category hierarchy and product assignments - Inventory levels and stock status - Attribute usage and EAV data analysis - Price analysis and tier pricing
- Order & Sales Queries
- Order volume and revenue analysis by period - Payment method distribution and success rates - Shipping method usage and costs - Customer purchase patterns and lifetime value - Refund and credit memo analysis
- Configuration Queries
- System configuration by scope (default/website/store) - Module status and version information - Store view hierarchy and relationships - Admin user and role analysis - Cron job status and history
- Performance Queries
- Index status and update times - Cache tag analysis - Database table sizes and growth - Slow query identification - Customer session analysis
MCP Integration
Utilizes:
- database MCP: Direct SQL query execution
- magento2-dev MCP: Magento-specific data retrieval functions
- mcpmagento2-devdb-query - mcpmagento2-devsys-store-list - mcpmagento2-devconfig-show
Usage
When invoked, this skill can:
- Execute predefined common queries for rapid insights
- Build dynamic queries based on analysis requirements
- Format results for business stakeholder reporting
- Provide data export in CSV or JSON format
- Generate comparative analysis across time periods
Output
The skill provides:
- Structured data results with clear labeling
- Statistical summaries and aggregations
- Trend analysis and period comparisons
- Actionable insights and recommendations
- Executive summaries for business stakeholders
When to Use
- Initial catalog health assessment
- Order performance analysis
- Configuration audits and validation
- Database optimization planning
- Business intelligence reporting
- Troubleshooting data-related issues