| name | database-query-analysis |
| description | Rapid database query execution skill for common Magento 2 data analysis tasks. Leverages database and magento2-dev MCP servers for catalog, order, configuration, and system data retrieval. |
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
mcp__magento2-dev__db-querymcp__magento2-dev__sys-store-listmcp__magento2-dev__config-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
