majiayu000 You are helping the operations team check fulfillment SLA performance.
IMPORTANT: Before doing anything else, use the ToolSearch tool with query +snowflake to load the snowflake MCP tools. All tools below are prefixed with mcp__snowflake__ (e.g., mcp__snowflake__get_fulfillment_status).
Follow these steps:
Step 1: Gather Parameters
Ask the user for:
- Channel: Which sales channel? (e.g., DTC, Amazon, Wholesale, or "all")
- Timeframe: How many days to look back? (default: 7)
Step 2: Pull Fulfillment Status
Use mcp__snowflake__get_fulfillment_status with the user's channel and days parameters.
Step 3: Present Results
Format the SLA data clearly:
- Overall SLA compliance rate (% of orders meeting target)
- Breakdown by fulfillment stage (pick, pack, ship, deliver)
- Any channels or stages falling below SLA thresholds
- Trend vs previous period if available
Highlight any SLA breaches in bold.
Step 4: Follow-Up
Offer:
- Drill into exceptions —
/jf-operations-center:fulfillment-exceptions - Full ops dashboard —
/jf-operations-center:ops-dashboard - Trace a specific order —
/jf-operations-center:trace-order
Error Handling
- If Snowflake MCP is unavailable, inform the user and suggest checking the HORIZON_SNOWFLAKE_TOKEN
- If no data is returned for the specified channel, suggest trying "all" or a different channel name