RAG Text-to-SQL: Asking My Database Questions in Plain English
What I Built I hate writing SQL for simple questions. This project lets me ask things like “how many customers are from Brazil?” in plain English — it generates the SQL, runs it, and gives me a readable answer. All local, using Ollama and ChromaDB. Easy to use — ask questions in everyday language Private — everything runs locally on your machine Fast feedback — generates and runs SQL in seconds Schema-aware — understands table names and relationships Interactive — ask follow-up questions in a chat-style flow Error handling — catches common issues like wrong table name casing System Architecture My RAG Text-to-SQL system consists of five core components: ...