Clinic platform · Health RAG

Flow Center

Booking, a self-assessment and a chat assistant for a clinic that treats period pain with traditional medicine. The AI stays strictly inside clinician-approved content.

• Built the clinic's site solo on Next.js 16, PostgreSQL and Drizzle, with booking and a staff workflow, a self-assessment, a chat assistant, auth and an admin area, deployed on Vercel and Neon.
• Made booking safe under concurrency with advisory locks and state transitions enforced in SQL. A test sends eight parallel bookings at two seats.
• Kept the AI inside approved content. Fixed rules score the assessment, warning signs stop it, and the model may only rephrase the clinic's template, falling back to that template on any failure.
• Built a RAG chat assistant with hybrid Vietnamese search: accent-folded keywords plus pgvector, fused with RRF. It reads data, but books only when the visitor presses the button.