NATURAL LANGUAGE TO
SQL : AN INTELLIGENT
PROJECT WORK CONVERSATIONAL
INTERFACE FOR DATABASE
QUERYING
PROJECT SUBMITTED IN PARTIAL FULFILLMENT OF
THE REQUIREMENTS FOR THE AWARD OF THE
DEGREE OF BACHELOR OF ENGINEERING IN
COMPUTER SCIENCE AND ENGINEERING
OF THE ANNA UNIVERSITY
2025
Submitted by
THOUFEEQ A 71772117146
VAITHEESHWARAN S 71772117147
VISWESWARAN G S 71772117150
BOOPATHI HARI R 71772117L03
Under the Guidance of
Dr.J.C.Miraclin Joyce Pamila.,
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
GOVERNMENT COLLEGE OF TECHNOLOGY
(An Autonomous Institution affiliated to Anna University)
COIMBATORE - 641 013
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
GOVERNMENT COLLEGE OF TECHNOLOGY
(An Autonomous Institution affiliated to Anna University)
COIMBATORE - 641 013
PROJECT WORK
APRIL 2025
This is to certify that this project work entitled
NATURAL LANGUAGE TO SQL : AN
INTELLIGENT CONVERSATIONAL
INTERFACE FOR DATABASE QUERYING
is the bonafide record of project work done by
THOUFEEQ A [ 71772117146 ]
VAITHEESHWARAN S [ 71772117147 ]
VISWESWARAN G S [ 71772117150 ]
BOOPATHI HARI R [ 71772117L03 ]
of B.E. (COMPUTER SCIENCE AND ENGINEERING) during the year 2024 - 2025
Dr.J.C.Miraclin Joyce Pamila., Dr.J.C.Miraclin Joyce Pamila.,
Project guide Head of the Department
Submitted for the Project Viva-Voce Examination held on _______________
at Government College of Technology, Coimbatore - 13.
Internal Examiner External Examiner
ACKNOWLEDGEMENT
Great achievements are not possible without standing on the shoulders of
giants. Without the active involvement of the following experts this project would
not have been a reality.
We express our sincere gratitude to Dr.K.Manonmani M.E, Ph.D., Principal,
Government College of Technology, Coimbatore for providing us all facilities that
we needed for the completion of this project.
Our thankfulness and gratitude to our respectable project guide
Dr.J.C.Miraclin Joyce Pamila M.E., Ph.D., Professor and Head of the
Department of Computer Science and Engineering who has been an immense
help through the various phases of the project. With her potent ideas and excellent
guidance, we were able to comprehend the essential aspects involved.
We extend our sincere thanks to our respected panel members, Dr.A.Meena
Kowshalya M.E., Ph.D., Associate Professor, and Dr.T.Raja Senbagam, M.E.,
Ph.D., Assistant Professor, for all their valuable suggestions to the completion of
the project.
We would like to thank our faculty advisor Prof.L.Sumathi M.E., Assistant
Professor for her continuous support and encouragement throughout this project.
We would like to dedicate the work to our parents for their constant
encouragement throughout the project. We also thank all our friends for their
cooperation and suggestions towards the successful completion of this project.
III
SYNOPSIS
This project suggests a cutting-edge Text-to-SQL system that will try to
convert natural language queries into SQL queries and respond back with
paraphrased, understandable responses to the user. The ultimate goal is to make
relational databases accessible to non-technical users by enabling interaction in
common language.
The system utilizes Large Language Models (LLMs) to create SQL queries
from user queries. To make it more accurate, it employs dynamic few-shot learning
methods. Relevant examples are selected depending on their similarity to the user
query, thereby enhancing relevance.
One of the most important features of the system is dynamic table selection,
wherein the system scans input keywords and queries the relevant tables in the
database schema. This improves the accuracy of SQL results by avoiding
unnecessary or irrelevant references from tables.
The SQL query is constructed via GPT and then runs on a networked
MySQL database. The result of the query is then passed through GPT once more
to create a paraphrased, natural language response, thus becoming more
user-friendly. To handle multi-turn conversations and follow-up queries, the system
uses LangChain's Conversation Buffer Memory. Using this feature, the chatbot can
keep context awareness between questions, thus making the conversations more
natural and coherent.
The frontend is built on Next.js, which provides an interactive user interface
to input user questions and get answers in real time. The backend is based on
Django, which takes care of request routing, database operations, and model
integration with external services such as GPT.
This project illustrates the effective utilization of chat-based AI, prompt
engineering, and memory-aware models in the creation of smart database
systems. It represents a major advancement in making advanced data operations
available through easy language.
IV
