drawDB

drawDB is an open-source database entity relationship diagram (ERD) editor that operates directly in the web browser, allowing users to design database schemas and visualize complex data structures without requiring an account or registration.

The software is used to build visual representations of database tables and their relationships, which can then be converted into executable code. It is deployed as a web application and can be run locally via npm or hosted on a server using Docker. For users who require collaboration, the software includes an optional server setup and environment variable configuration to enable the sharing of files between different users.

Key features

• Visual ERD editor for building database diagrams
• SQL script export and import functionality
• Automated SQL generation from visual diagrams
• Migration script generation
• Browser-based editor with no signup requirement
• Custom editor configuration options
• Docker support for self-hosted deployment
• Support for multiple database dialects

Built with React and Tailwind CSS, drawDB focuses on the technical visualization of data relationships. It provides compatibility with a wide range of database systems, including PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, and Oracle. The application utilizes IndexedDB for local storage, which ensures that diagrams are saved and remain accessible within the browser environment even without a backend connection. This architecture allows for a fast, client-side experience where the primary logic of the diagramming tool resides in the browser.

It serves as a technical utility for database administrators, backend engineers, and software developers who need to map out schemas, document existing data structures, and generate initialization scripts for new projects.