Back to ProjectsView on GitHub
SQL Agent vs RAG Chatbot
September 2024 - October 2024
I used Azure OpenAI API for embedding and chatbot integration, LangChain SQL Agent for SQL handling, and SQLite as the relational database. I also incorporated ChromaDB as the vector database for RAG-related tasks and built the web interface using Streamlit to make everything accessible and user-friendly. While RAG has its strengths with unstructured and hybrid data, SQL Agent clearly outshined when it came to structured, tabular datasets.
Tech Stack
PythonStreamlitChromaDBLangChain