• Tushar Narinder Pal
• Chetna Uikey
• Joy Kujur
• Aabha Singh
• Dr. Prakash Kene

Entity–Relationship Diagrams (ERDs) remain indispensable for conceptual database design, yet traditional modelling workflows rely heavily on manual diagram creation and error-prone SQL scripting. Existing commercial tools are expensive, cloud-dependent, or offer limited automation—creating barriers for students, educators, and small development teams. This paper presents Database Schema Visualizer (DSV), a novel, fully client-side ERD modelling framework that integrates interactive drag-and-drop design, real-time relationship inference, automated junction table creation, and deterministic SQL generation. The system employs ReactFlow for node-edge rendering and the Dagre algorithm for hierarchical auto-layout optimization, ensuring scalable visualization for complex schemas. Major contributions include a unified modelling and SQL synthesis pipeline, a privacy-preserving architecture requiring no backend, and a rule-driven compiler that ensures zero SQL errors across all test cases. A mixed-methods evaluation involving 30 participants demonstrates significantly reduced modelling time (40% improvement), enhanced accuracy, and strong usability ratings. Statistical analysis using ANOVA confirms the significance of observed efficiency gains (p < 0.05). The paper incorporates deep technical explanations, pseudocode for all core algorithms, expanded literature grounding, and detailed reproducibility guidelines including open-source licensing. Ethical considerations, limitations, and threats to validity are also discussed. These enhancements position DSV as a robust and accessible alternative to proprietary ERD tools, particularly for academic and small-scale development contexts.

ER Modelling, SQL Generation, Client-Side Visualization, Schema Synthesis, ReactFlow, Dagre Layout Algorithm.

"Database Schema Visualizer: A Fully Client-Side, Automated ERD Modelling and SQL Generation Framework", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.12, Issue 11, page no.e481-e486, November-2025, Available :http://www.jetir.org/papers/JETIR2511461.pdf

"Database Schema Visualizer: A Fully Client-Side, Automated ERD Modelling and SQL Generation Framework", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.12, Issue 11, page no. ppe481-e486, November-2025, Available at : http://www.jetir.org/papers/JETIR2511461.pdf