Download brModelo – Database Design and ER Diagram Tool

brModelo is a free, open-source database modeling tool designed for creating Entity-Relationship (ER) diagrams and relational database schemas. It is widely used in academic settings and by developers who need to visually design database structures before implementing them in SQL, making the conceptual-to-logical-to-physical modeling process accessible and straightforward.

The tool supports the three main modeling levels: conceptual (ER diagrams with entities, attributes, and relationships), logical (relational schema with tables and foreign keys), and physical (SQL script generation for specific databases). brModelo can automatically transform a conceptual ER diagram into a logical relational model, bridging the gap between design and implementation.

Written in Java, brModelo runs on Windows, macOS, and Linux without additional dependencies. It is particularly popular in Brazilian universities (brModelo stands for “Brazilian Model”) and is used internationally for teaching database design concepts. Models can be exported as images or saved in its native format for sharing and collaboration.

Key Features

• Conceptual ER diagrams – Create entity-relationship diagrams with entities, attributes (simple, composite, derived, multivalued), and relationships.
• Logical relational schema – Design relational tables with primary keys, foreign keys, and constraints.
• Automatic transformation – Convert conceptual ER models to logical relational schemas automatically.
• SQL script generation – Generate SQL CREATE TABLE scripts from logical models for MySQL, PostgreSQL, and other databases.
• Image export – Export diagrams as PNG or SVG images for documentation and reports.
• Cross-platform – Runs on Windows, macOS, and Linux via Java runtime — no installation required in portable mode.
• Educational tool – Simple interface designed for students learning database design principles.

How to Install

1. Ensure Java 8 or higher is installed on your system.
2. Download the brModelo JAR or installer from the link below.
3. Run the JAR file with java -jar brModelo.jar or double-click if Java is associated with .jar files.
4. Select the diagram type (Conceptual, Logical, or Physical) to start a new model.
5. Drag entity and relationship elements from the palette onto the canvas and connect them to build your database schema.