Master Database Design with DrawDB: Installation, Features, and Real-World Example

DrawDB Overview

DrawDB is an open‑source database design tool with over 20K stars on GitHub. It offers intuitive visual modeling, an SQL generator, and supports exporting designs as SQL scripts.

Installation

Using Docker is the most convenient way to install DrawDB.

Pull the Docker image:

<code>docker pull xinsodev/drawdb</code>

Run the container on port 3000:

<code>$ docker run --name some-drawdb -p 3000:80 -d xinsodev/drawdb</code>

Access the editor at http://192.168.3.101:3000 and click “Editor”.

Using DrawDB

The article demonstrates using DrawDB to design the permission module of the “mall” e‑commerce project, which is built with SpringBoot3 + Vue and follows a modern micro‑service architecture.

Project links: https://github.com/macrozheng/mall, https://github.com/macrozheng/mall-swarm

Designing Tables

Add tables with the “Add Table” button and fields with “Add Column”.

Create relationships by dragging the small dot from one field to another.

Set mapping relationships via the relationship tab.

Import/Export SQL

Export the design to SQL files (MySQL, PostgreSQL, SQLite, etc.).

Import an existing SQL file to generate a design.

Theme Configuration

DrawDB supports dark and light themes, switchable via the “Theme” option.

Template Configuration

Choose colorful templates from the “Templates” menu to customize the appearance of tables.

Conclusion

The tutorial shows that DrawDB is easy to install and use for database design, making it a useful tool for developers who need to model databases quickly.

Project Repository

https://github.com/drawdb-io/drawdb