database-query-analysis

This skill provides efficient database query execution for Magento 2 data analysis.

What This Skill Does

1. 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

2. 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