List customers. Optional search matches first_name, last_name, or email (case-insensitive substring). Returns rows with pagination metadata (data, total ignoring limit, limit, offset).

List products. category must be an existing product category (validated against the DB). inStock filters to stock_quantity > 0. minPrice/maxPrice filter by price. Sorted by id by default.

List orders. Filter by exact status (validated against the DB), customer_id, and/or a date range on order_date (from_date, to_date — ISO date or datetime strings). When include_items is true, attach an items array to each order. Sorted by id by default. Cancelled orders are shown here but excluded from analytic tools.

List order line items. Filter by order_id and/or product_id. Each row includes the product name via a LEFT JOIN to products. Sorted by id by default.

Top customers by total spend (sum of orders.total_amount), EXCLUDING cancelled orders. Optionally filter by a date range on order_date. Each row: { customer_id, name, orders, total_spent }. Default limit 10.

Top products by units sold (sum of order_items.quantity), EXCLUDING cancelled orders (JOINs orders to filter status and date). Each row: { product_id, name, category, units_sold }. Default limit 10.

Top product categories by revenue (sum of order_items.quantity * unit_price), EXCLUDING cancelled orders. Each row: { category, revenue }. Default limit 10.

Revenue (sum of orders.total_amount) EXCLUDING cancelled orders, grouped by period. group_by = "year" (default) or "month" (-> YYYY-MM). Returns rows sorted by period ascending; a period with no data simply yields no row. Each row: { period, revenue }.

Top customers by number of orders placed. NOTE: unlike the other analytic tools, this counts ALL orders (cancelled orders are NOT excluded). Optionally filter by date range on order_date. Each row: { customer_id, name, orders }. Default limit 10.