Simple Database Modeler (SDM) is a Java application that allows to create database models using ER diagrams.
It was mainly written for PostgreSQL database however it has a support even for some other RDBMS.
- Visual editing of ER diagrams
- Basic features (tables, relations, indexes, user objects, basic import) for PostgreSQL, MySQL, OracleDB, MSSQL, Firebird
- Advanced features for PostgreSQL: users, roles, grants, all DB objects, full import, schema. These can be used in all supported databases but like manual user objects only (and without import support)
- No count limits for any objects
- Workspace max. size is 2000x2000 (this is simply hardcoded and it's enough for all projects that can be done in SDM)
- Generating SQL script from model
- Support for the model import from existing database (model reengineering)
- Import can be used for conversion of existing model from one database type to another one
- Save / Load model in own open XML format
- Fully functional Undo/Redo (inside each submodel for visual ERD objects)
- Export model to picture (.png or .jpg)
- Allows to make use of submodels
- Automatic visual relations placing
- Visual multiselect movement support
- Runs on Java runtime 6 or higher (primarily on Windows, tested on Linux, might run even on Mac?)
- It's completely free to use!
- SDM has been originally developed just for my own usage and fun..
- Current status of development is "Zombie development" - there is no development most of the time (it's a dead project) but from time to time I do some work on it and nobody knows if it was the last time..
- Not fully and properly tested and can contain bugs
- Only basic functionality for other than PostgreSQL databases - this application was written for Postgres only and other databases were just a small bonus
- Even for PostgreSQL is not all of advanced functionality implemented visually (yet)
- If you want to use import you need to have proper JDBC driver for given database (they can be part of the database installator or can be downloaded separatelly)
- SQL query window is really for emergency use only (so don't laugh)
- No guide (but I believe it's quite intuitive and simple to understand)
- Quite a big todo list (that will be very likely never implemented)
- No application icon created so far
- Last testing was done on PostgreSQL 9.5 so I cannot guarantee proper functionality of generated scripts on current versions of other databases
- Actually, I can guarantee nothing..
- Double-click on the relation to see Relation properties dialog