View on GitHub

staruml-reverse-db

Extension for StarUML support to generate ER Data Model from database schema

ERD Generation Extension for StarUML 2

This extension for StarUML support to generate ER Data Model from database schema.

Supported databases

ER Data Model Generation

MS SQL

  1. Click the menu (Tools > Database > MS SQL Server > Configure Server...)
  2. Configure Database Connection Preferences
  3. Choose one of the following to generate ER Data Model
    • Click the menu (Tools > Database > MS SQL Server > Generate ER Data Model...) or
    • Press the shortcut key(Alt + Shift + M)
  4. Model will be created in the Project (If there is no open project, it will be created)

PostgreSQL

  1. Click the menu (Tools > Database > PostgreSQL Server > Configure Server...)
  2. Configure Database Connection Preferences
  3. Choose one of the following to generate ER Data Model
    • Click the menu (Tools > Database > PostgreSQL Server > Generate ER Data Model...) or
    • Press the shortcut key(Alt + Shift + L)
  4. Model will be created in the Project (If there is no open project, it will be created)

MySQL

  1. Click the menu (Tools > Database > MySQL Server > Configure Server...)
  2. Configure Database Connection Preferences
  3. Choose one of the following to generate ER Data Model
    • Click the menu (Tools > Database > MySQL Server > Generate ER Data Model...) or
    • Press the shortcut key(Alt + Shift + P)
  4. Model will be created in the Project (If there is no open project, it will be created)

Belows are the rules to convert from database schema to ER Data Model elements.

Table

Column

Relationship

RelationshipEnd