Introducing PDMan: An Open‑Source Database Modeling Tool for Java Development

Good tools boost development efficiency; while IDEA is a staple for Java, PowerDesigner is a paid, complex database design tool, we introduce PDMan (Physical Data Model Manager), an open‑source, lightweight database modeling tool.

PDMan, developed by Chinese contributors, is easy to use, runs on multiple operating systems, and out‑of‑the‑box supports automatic code generation for MySQL, Oracle and Java with comments, as well as model version management that records changes and can generate DDL statements.

Installation

The source code is available at https://gitee.com/robergroup/pdman and a Baidu Cloud download with extraction code ttqe is provided.

Feature Usage

After launching PDMan you see a simple interface with only Create New Project and Open Existing Project buttons.

Creating a new project involves clicking Create New Project , selecting a path, and pressing the Create button.

Within a project you add a module (equivalent to a database) and then create tables. Right‑click a table and choose 新增数据表 to add a new table.

For example, a user table is created; its basic information and fields are shown in the UI.

Field settings allow default attributes such as optimistic lock, creation and update timestamps, which can be customized in the settings panel.

Additional custom fields like primary key, username and password can be added.

The 代码信息 tab displays generated scripts for MYSQL , ORACLE and Java object classes.

Conclusion

PDMan greatly improves the efficiency of designing database tables, follows domestic development practices, and stores projects in a universal JSON format. If you find it useful, remember to click 在看 .