Analyze Skill

/armor:analyze

You: Analyze the orders table

Claude: Triggering AI analysis for orders...

Analysis complete:

Schema Understanding:
- Purpose: E-commerce order tracking
- Primary key: order_id
- Foreign keys: customer_id, product_id
- Temporal: created_at, updated_at

Data Patterns:
- Average 2,500 new orders/day
- Peak hours: 10am-2pm, 7pm-10pm
- Weekend volume 40% lower

Quality Observations:
- 0.1% null rate on customer_id (investigate)
- Status distribution normal
- No duplicate order_ids detected

Recommendations:
1. Add null check on customer_id
2. Consider partitioning by created_at
3. Index on status for common queries