Visual data modelling in the browser (open source) (github.com)

SQLModel, an open-source tool designed for visual database modeling, has officially launched, allowing users to create conceptual and physical database models with an intuitive, canvas-based interface. This tool supports dual-layer modeling, enabling designers to first create a conceptual overview with entities and relationships before refining them into physical tables complete with columns, data types, and foreign keys. A notable feature is its AI-driven generation capability, which allows users to simply describe their systems in plain English to generate comprehensive data models, accommodating both transactional (OLTP) and analytical (star schema) patterns without requiring server storage or user accounts, thereby ensuring data privacy. The significance of SQLModel lies in its focus on collaboration and ease of use for development teams, making it easier to document, architect, and share database designs. Built with modern technologies like React 18 and TypeScript, it offers a user-friendly experience with features such as dark/light mode, keyboard shortcuts, and the ability to export SQL DDL scripts for popular database systems like PostgreSQL and MySQL. By providing a local and privacy-first solution, SQLModel empowers data architects and developers to generate, enhance, and share their models while maintaining full control over their data without the overhead of traditional database design tools.