Mejora del proceso de desarrollo de consultas mysql con IA generativa en una empresa de software

Abstract

CONDITION FOR PUBLICATION OF PROJECT. This project aims to improve the efficiency and autonomy of the development team in a software company by integrating Generative Artificial Intelligence and Business Process Modeling Notation (BPMN) into the creation of MySQL queries. The hypothesis is that the use of tools such as ChatGPT, combined with a structured redesign of the workflow, significantly reduces development time and common coding errors. The project is justified by the need to optimize repetitive tasks, decrease reliance on the DBA, and improve the quality of delivered scripts. The project was developed using a descriptive, non-experimental methodology. The current process (AS-IS) was mapped, multiple improvement alternatives were evaluated, and an optimized process model (TO-BE) was designed using tools like Bizagi Modeler, DBeaver, and ChatGPT. Simulations, user surveys, and controlled testing with ten developers were also conducted. The results showed an average reduction in development time to less than one day, a decrease in syntax errors, and improved perceptions of autonomy among the development team. The proposed solution proves to be viable and scalable for similar technical environments. Keywords: BPMN, Generative AI, SQL Query Development, Process Optimization