Automating TypeScript API Generation from ER Diagrams: A visual paradigm Plugin Approach

Στακιάς, Γεώργιος; Stakias, Georgios

dc.contributor.author	Στακιάς, Γεώργιος	el
dc.contributor.author	Stakias, Georgios	en
dc.date.accessioned	2025-09-09T06:09:56Z
dc.date.available	2025-09-09T06:09:56Z
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/62385
dc.identifier.uri	http://dx.doi.org/10.26240/heal.ntua.30081
dc.rights	Default License
dc.subject	Code Generation	en
dc.subject	Visual Paradigm	en
dc.subject	Επέκταση	el
dc.subject	ER Διάγραμμα	el
dc.subject	TypeScript	en
dc.subject	TypeORM	en
dc.subject	Αυτοματοποίηση Παραγωγής Κώδικα	el
dc.subject	CRUD	en
dc.subject	Αγνωστικισμός DBMS	el
dc.subject	Plugin	en
dc.subject	ER Diagram	en
dc.subject	API	en
dc.subject	Schema Consistency	en
dc.subject	Automation	en
dc.subject	Database Agnosticism	en
dc.title	Automating TypeScript API Generation from ER Diagrams: A visual paradigm Plugin Approach	en
heal.type	bachelorThesis
heal.classification	Software Engineering	en
heal.language	el
heal.language	en
heal.access	free
heal.recordProvider	ntua	el
heal.publicationDate	2025-02-28
heal.abstract	In modern software development, where data structures form the foundation of digital solutions, translating conceptual database designs into functional code remains a critical challenge. Bridging the gap between visual representations and executable implementations is often a time-consuming and error-prone process, requiring significant expertise. As applications grow in complexity, the need for automated and reliable solutions to streamline this transition becomes increasingly apparent. Ensuring precision and consistency across database design and API implementation is crucial, yet manual processes often introduce inefficiencies and inconsistencies. This thesis presents a Visual Paradigm plugin designed to automate the transformation of ER diagrams into TypeScript APIs. By ensuring accuracy, consistency, and efficiency, this tool minimizes manual effort while enhancing development workflow. The plugin introduces several key innovations: • Automated ER Diagram Parsing – It intelligently interprets entity relationships, attributes, and constraints in Visual Paradigm ER diagrams, ensuring accurate database schema representation. • Type-Safe API Generation – Leveraging TypeScript’s strong type system, the generated API endpoints provide compile-time type checking, enhancing reliability and developer productivity. • Database-Agnostic Implementation – Through integration with TypeORM, the generated APIs support multiple DBMSs (MySQL, PostgreSQL, and Microsoft SQL Server) without requiring code modifications. • Comprehensive CRUD Operations – For each entity in the ER diagram, the tool generates REST API endpoints with full Create, Read, Update, and Delete functionality, respecting defined relationships and constraints. The solution is built upon modern technologies, including Visual Paradigm for diagram modeling, TypeScript for type-safe API development, Express.js for web application routing, and TypeORM for database abstraction. By automating API generation, the tool significantly reduces development time and potential coding errors while maintaining consistency between the ER diagram and the final implementation. Beyond code generation, it promotes better software engineering practices by ensuring alignment between design and implementation, minimizing manual coding errors, accelerating prototyping and iteration, supporting database portability and enforcing type safety throughout the application stack.	en
heal.advisorName	Vescoukis, Vassilios	en
heal.committeeMemberName	Vescoukis, Vassilios	en
heal.committeeMemberName	Papaspyrou, Nikolaos	en
heal.committeeMemberName	Sagonas, Konstantinos	en
heal.academicPublisher	Εθνικό Μετσόβιο Πολυτεχνείο. Σχολή Ηλεκτρολόγων Μηχανικών και Μηχανικών Υπολογιστών. Τομέας Τεχνολογίας Πληροφορικής και Υπολογιστών	el
heal.academicPublisherID	ntua
heal.numberOfPages	130 σ.	el
heal.fullTextAvailability	false