Case study

High-Load Support Assistant

A grounded support assistant answering catalogue, delivery and returns questions at sale-day traffic — with sub-ten-second worst-case responses and no invented policy.

Client type
Online fashion retailer with seasonal traffic peaks (sample scenario)
Industry
E-commerce
Duration
5 months

Sample contentSample engagement. Illustrative scenario used while the site is in build — not a named client project.

e commerce2026

High-Load Support Assistant

  • Python
  • FastAPI
  • PostgreSQL
  • LLM integrations

Support volume tripled during sale periods, and most of it was repetitive: where is my order, does this size run small, what is the returns window. Generic chatbot products either answered from nothing or invented policies the retailer then had to honour.

A retrieval-grounded assistant built over the retailer's own catalogue, policy pages and order status API, with autoscaling sized against historical peak traffic and a strict rule that unanswerable questions escalate to a human.

The support team stopped spending sale weeks on repetitive questions and could focus on the complaints and exceptions that actually needed judgement.

  1. 01Content pipeline normalising catalogue and policy pages into a consistent structure
  2. 02Embeddings stored alongside the operational data rather than in a separate service
  3. 03Answer grounding enforced — no source, no answer
  4. 04Load testing against three seasons of historical peak traffic before launch
  5. 05Escalation path to a human agent with full conversation context attached

One stateful system, not two

Storing embeddings in the existing PostgreSQL cluster rather than adding a dedicated vector database removed an entire class of operational work — backups, failover and consistency were already solved.

Start a conversation

Similar problem on your side?Let's talk.

Tell us what you are trying to build, fix or decide. If we are not the right team for it, we will say so and point you somewhere better.

Typical first step: a 30-minute call, then a short written assessment.