Day 8 — E-Commerce / Retail
Your Shopify dashboard, but you can talk to it.
An MCP server that connects a DTC beauty brand's product catalog, orders, customers, inventory levels, and sales data to Claude. Ask about your business in plain English.
Example Queries
Tools
| Tool | What It Does |
|---|---|
| product_catalog | Search products — pricing, margins, stock levels, and total sales performance |
| order_lookup | Find orders by number, status, customer, or date — with items, totals, and tracking |
| customer_insights | Customer profiles with tier, lifetime value, order count, and recency |
| inventory_alerts | Out-of-stock, low stock, overstocked items, and pending fulfillment count |
| sales_analytics | Revenue, AOV, top products, category breakdown, and order status distribution |
| fulfillment_queue | Orders awaiting shipment — express first, with overdue flags |
Why This Industry
DTC founders live inside dashboards. Shopify, Google Analytics, Klaviyo, ShipStation — the data exists, but getting a simple answer means clicking through four tabs and running a mental JOIN.
“What's our best-selling product this month?” shouldn't require exporting a CSV. “Which VIP customers haven't ordered in 60 days?” shouldn't require a Klaviyo segment.
This tool answers business questions, not just data questions.
Demo Data
24
Products
20
Customers
36
Orders
6
Categories
Modeled after a DTC beauty brand (Solara). Includes VIP influencer with PR packages, a barbershop owner who bulk orders, a quarterly corporate gifter, out-of-stock sunscreen, overstocked holiday sets, a cancelled order, a refunded order (allergic reaction), and a TikTok-referred first-time buyer.
Setup
cd day08-ecommerce
npm install && npm run seed && npm run buildThen add the config to Claude Desktop and restart.
If you're still exporting CSVs to answer basic business questions, let's fix that.