Next–Generation Prompt-to-Sql:Automated Generation of Advanced Queries
International Scientific Journal of Engineering and Management · 15.04.2026 · 05 (04) · 1-5
DOI: 10.55041/isjem06384 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Scientific Journal of Engineering and Management, online erschienen am 15.04.2026. Verfasst von Kavyasri A und 4 weiteren Autor:innen.
Abstract (Originalsprache)
This paper presents a Next-Generation Prompt-to-SQL system designed to enable users to interact with relational databases using natural language queries. The proposed system integrates a transformer-based language model with schema-aware prompting to accurately translate user input into executable SQL statements. A secure, web-based architecture is developed, incorporating user authentication, a responsive frontend interface, and a FastAPI-based backend connected to a production-grade MySQL database. The system supports essential query operations, including data retrieval, filtering, joins, and nested queries, ensuring practical usability in real-world scenarios. Experimental evaluation demonstrates reliable query generation with low latency and high execution accuracy for basic and moderately complex queries. By reducing the dependency on SQL expertise, the proposed approach enhances accessibility for non-technical users and provides a scalable foundation for future advancements in intelligent database interaction systems. Keywords: Prompt-to-SQL, Text-to-SQL, Natural Language Processing, Large Language Models, MySQL, FastAPI, Query Automation
Zitieren
APA
A, K., A, A., A, J., N, H., & T, M. (2026). Next–Generation Prompt-to-Sql:Automated Generation of Advanced Queries. International Scientific Journal of Engineering and Management, 05(04), 1-5. https://doi.org/10.55041/isjem06384
Vancouver
A K, A A, A J, N H, T M. Next–Generation Prompt-to-Sql:Automated Generation of Advanced Queries. International Scientific Journal of Engineering and Management. 2026;05(04):1-5. doi:10.55041/isjem06384
BibTeX
@article{A2026,
author = {A, Kavyasri and A, Akhila and A, Jahnavi and N, Harini and T, Mukesh},
title = {Next–Generation Prompt-to-Sql:Automated Generation of Advanced Queries},
journal = {International Scientific Journal of Engineering and Management},
year = {2026},
volume = {05},
number = {04},
pages = {1--5},
doi = {10.55041/isjem06384}
}
EUVIMED