rfarrey/mogwaierdesignerng

Java 2D & 3D visual entity relationship design & modeling (ERD,SQL) for Oracle,MSSQL,Postgres and MySQL

Mogwai ERDesigner NG

The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation.

Build status

Releases are available at GitHub or

ERDesigner NG

• is based on Java and can be run on Windows,Unix and Mac systems
• is distributed as a zip/tar/installer file or can be launched by Microsoft Store
• has a powerful WYSIWYG editor for physical database design
• supports 2D and 3D database modeling, browsing and design
• generates true 3D anaglyphic views from your database structure
• handles tables, relations, views, domains, custom types, indexes and comments
• supports a central repository for all models ( Model Repository )
• supports subject areas
• supports MySQL, Oracle, Microsoft SQLServer, PostgreSQL, H2 and HypersonicSQL
• creates the SQL DDL statements for your database schema
• supports forward and reverse engineering
• has an integrated schema version control system
• can generate schema migration scripts for every change
• stores the database definition as XML files for further processing
• can export the database schema as GIF, BMP, JPEG or SVG files
• has an integrated reverse engineering module for existing schemas
• has a build in schema compare feature
• can generate schema documentation as PDF, HTML, RTF and other formats
• supports schema conversion between different dialects
• analyzes the database model for common problems
• generates OpenXava applications
• it is based on GPL license

User manual

An extensive user manual is available here.

Screenshots

Main Screen

Edit table

Model compare

SQL generation

2D editing mode

3D editing mode