Quickly Design Databases with the Open‑Source DrawDB Tool

In the early stage of a project, a good database design tool can greatly improve efficiency. This article introduces DrawDB, an open‑source, visually appealing database design tool with modeling and SQL generation features.

DrawDB Overview

DrawDB is an open‑source database design tool that has gained over 20K+ stars on GitHub. It offers intuitive design, modeling, and an SQL generator to export designs as scripts.

Below is a screenshot of DrawDB in action.

Installing DrawDB

Using Docker is the most convenient way to install DrawDB.

First, pull the Docker image: docker pull xinsodev/drawdb Then run the container, exposing port 3000:

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

Access the editor at http://192.168.3.101:3000 and click Editor to open the design page.

Using DrawDB

The article demonstrates DrawDB with the permission module of a mall e‑commerce project.

Designing Tables

Use the Add Table button to create tables and Add Column to add fields.

Drag the small dots on fields to create relationships.

Set mapping relationships via the relationship panel.

Import/Export SQL

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

Import SQL files to generate a database design.

Theme Configuration

DrawDB supports dark and light themes. Use the Theme function to switch between them.

Template Configuration

Choose different color templates via the Templates function on the homepage.

Conclusion

Using the mall e‑commerce permission module as an example, the article walks through DrawDB’s main features. DrawDB is easy to install and use, making it a handy tool for anyone needing to design database tables.

Project Address

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