Stayora

Real-time analytics platform deployed for luxury hotels (CHF 45M+ revenue). Features a "Text-to-SQL" engine and RAG-based review analysis to democratize data access for non-technical staff.

System Architecture

• Orchestration Layer: Node.js/Express API gateway handles authentication, session management, and routes requests
• Structured Data Layer: Operational metrics stored in normalized MySQL schema for strict ACID compliance and financial reporting
• Unstructured Intelligence: Guest reviews processed by Python FastAPI service, vector-embedded, and stored in ChromaDB for semantic search

Text-to-SQL Query Engine

• Context Injection: Prompt dynamically injects SQL schema and user role context to ensure AI understands table relationships
• Safety Layer: Middleware parses generated SQL to enforce SELECT-only execution, preventing injection attacks or accidental data mutation
• Self-Correction: If query fails, error message is fed back into the LLM to auto-correct the syntax

Tech Stack

• Frontend: React 18, Vite, TailwindCSS, Recharts
• Backend: Node.js (API Gateway), Python FastAPI (Review Analysis Microservice)
• Database: MySQL (Structured Metrics), ChromaDB (Vector Embeddings)
• AI/ML: OpenAI GPT-4o (SQL Generation), text-embedding-ada-002
• Infrastructure: AWS EC2, Docker, Passport.js (OAuth 2.0)