amnakhaalid1/text-to-sql-chatbot repository overview

⁠Smart Agentic Text-to-SQL & Analytics Engine

A production-grade, highly modular NLP-to-SQL interface powered by LLM routing decision-making. It intelligently translates plain English analytical questions into structured queries, executes them against an cloud-hosted Aiven database, and dynamically handles reporting outputs.

⁠🚀 How it Works (Intelligent Core Engine)

1. LLM Query Generation: Translates natural language questions dynamically into precise database queries.
2. Execution Layer: Securely runs queries against a live, optimized Aiven cloud DB cluster.
3. Smart Routing & Evaluation: The LLM checks if the user's intent requires data visualization (e.g., "plot", "graph", "show trend").
   • If YES: The pipeline auto-generates a structured image/graph visualization.
   • If NO: It structuralizes and returns a clean, lightweight data payload format.

⁠🛠️ Architecture & Engineering Quality

• 100% Modular Approach: Clean directory layout separating API routing, query orchestrators, DB drivers, and visualization services.
• FastAPI Framework: Optimized production endpoints engineered for low-latency asynchronous processing.
• Fully Containerized: Self-contained runtime environments ensuring seamless cross-system delivery.

⁠🐳 Quick Start & Local Execution

To download and spin up this analytics microservice locally:

# Pull the latest containerized image
docker pull amnakhaalid1/text-to-sql-chatbot:latest

# Run the container service with configuration variables
docker run -p 8000:8000 --env-file .env amnakhaalid1/text-to-sql-chatbot:latest