How I reduced medical no-shows from 21% to 8.1% with an AI Telegram bot

A Moscow medical clinic was losing money every day. 21% of appointments ended in no-shows — patients who booked but never came. Staff spent hours on manual reminder calls. The booking process was 100% phone-based. They hired me to fix it. Here's what I built and what happened in the first 5 weeks. The actual business problem No-shows in medical clinics aren't just annoying — they're expensive. An empty slot that could have been filled is pure revenue loss. At this clinic, 21% no-show rate translated to roughly $7,200/month in lost revenue. The root causes were straightforward: Patients forgot appointments (no automated reminders) Rebooking required a phone call during working hours Staff had no visibility into who was likely to no-show Architecture Bot: Python 3.12 + aiogram 3 (Telegram) Backend: FastAPI + PostgreSQL 15 + Redis AI: GigaChat API (Russian language, data stays in Russia — required for medical data under 152-FZ) Vector search: ChromaDB + rubert-tiny2 embeddings EHR integra