GUI pro aplikaci analyzující schéma databáze a SQL dotazy

Abstract

The aim of this bachelor’s thesis is to develop a web application that simplifies working with a tool for comprehensive analysis of database schemas and related SQL queries, called DBShepherd. The proposed solution provides a user-friendly interface that enables efficient interaction with the tool without requiring direct use of its native interface. The system is divided into two main parts. The backend ensures user authentication and authorization, mediates communication with the analytical tool and external language models, and transforms the obtained responses into a unified format. The frontend represents a web-based user interface that enables clear interaction with the system’s functionalities and interpretation of analysis results. The proposed architecture is based on the microservices approach and separation of individual components, which allows for easy extensibility and maintainability of the system.