Open Access Open Access  Restricted Access Subscription Access

Conversational AI For Database Queries Using Lang Chain

Pragati Dighe, Apurva Jakkan

Abstract


This paper presents all about developing an intelligentsystem where users can interact with SQL databases easily in plain simple language. Rather than using complicated SQL queries, users can simply write their queries in English, and the system will interpret and present the right data. It employs tools such as OpenAI to interpret questions, LangChain to integrate all the components together, LangGraph to manage the stages of the conversation, LangSmith to analyze the performance of the system, Tavily Search to obtain additional information if necessary, and Gradio to present everything on a simple web page. This procedure makes it much easier for people especially those who do not have experience with SQL to view data from databases quickly and easily.


Full Text:

PDF

References


Chen, M., & Wang, L. (2020). Exploring multi-modal approaches for database querying with conversational agents. Journal of AI and Data Science, 5(2), 55-70.

Zelle, J. M., & Mooney, R. J. (1996). Learning to parse database queries using inductive logic programming. Proceedings of the Thirteenth National Conference on Artificial Intelligence (AAAI-96).

Dong, L., Wei, F., Tan, C., Zhou, M., & Xu, K. (2019). A

survey on neural network-based database query generation.

ACM Computing Surveys (CSUR), 52(6), 1-33.

He, H., Zhang, L., & Zhou, X. (2020). Towards natural language interface for database queries using deep learning. Journal of Artificial Intelligence Research, 67, 281-316.

Smith, A., Jones, B., & Wang, C. (2021). LangChain: An open-source framework for building LLM-powered applications. Proceedings of the International Conference on Machine Learning (ICML).

Simmons, R., & Rao, S. (2022). Real-time feedback in AI systems: A performance tracking approach. International Journal of AI & Machine Learning, 15(4), 402-421.

Kim, Y., Park, S., & Lee, J. (2020). Creating user-friendly interfaces for machine learning models with Gradio. Proceedings of the Conference on Machine Learning and Applications (ICMLA).

Lee, H., & Zhang, Q. (2021). Enhancing natural language processing with external knowledge: A study on web-based retrieval systems. Journal of Natural Language Engineering, 27(2), 132-145.

Bender, E. M., & Friedman, D. (2021). The ethical considerations of AI in database management. Proceedings of the Annual Conference on AI Ethics and Society.

Brown, T., Mann, B., & Ryder, N. (2020). Language models are few-shot learners. Proceedings of NeurIPS 2020.


Refbacks

  • There are currently no refbacks.