Retail Store Database Assistant

BCDE

• Primary Goal : To develop an intelligent Retail Store Database Assistant to simplify data retrieval from a MySQL database, enabling users to ask natural language questions and receive relevant information.
• Developed Retail Store Database Assistant using Python, Streamlit, and LangChain library.
• Integrated Google's Palm and Hugging Face's Sentence Transformers for natural language understanding and text embeddings.
• Implemented Few-Shot Learning and Semantic Similarity for intelligent query generation in MySQL.
• Utilized Chroma from LangChain for efficient vectorization and deployed as a web application.