Is there a free software that allows to edit database ER diagrams and export for different SQL database systems (e.g. MySQL, Oracle, SQLite, Microsoft SQL Server, etc.)?

  • 1
    @Fractaliste - the requirement to export ERDs to various systems is VERY precise (he even listed a minimum set). ERD also implies a GUI. And seriously... Android app for ERD?
    – DVK
    Commented Feb 14, 2014 at 19:40
  • 1
    Mh. I’ll ask our DBA about that, I think he had something like this.
    – mirabilos
    Commented Feb 17, 2014 at 12:34
  • 1
    @Fractaliste DVK said it all, I don't think you need more info... Do you only consider as quality posts those with huge amounts of text as oposed to simple straightforward questions?
    – Mikel
    Commented Feb 17, 2014 at 12:46

2 Answers 2


It won't export to everything you want, but I've had a lot of good experiences with Oracle SQL developer data modeller (Not to be confused with Oracle SQL developer). I currently don't have a copy running so no screenshots, but I found it significantly easier to use in designing a database ERD than visio, and forward engineering DDL from it. Once you've created the ERD for a database, you simply have to tell it to export the DDL (file -> export -> DDL) and it'll generate the commands for creating the database for you.

It runs on windows and linux, as long as java is installed. It will allow you to design an ERD and convert that to the necessary DDL for Oracle, DB2 or MSSQL. It dosen't support mysql or sqlite (Oracle has mysql workbench for mysql - but I have no direct experience with it)


SQL Power Architect logo

SQL Power Architect: Data Modeling & Data Profiling Tool will allow you create ER diagrams and then forward engineer that diagram into DDL for Oracle 9i/10g, PostgreSQL, Microsoft SQL Server 2000, Microsoft SQL Server 2005, MySQL, IBM DB2, or HSQLDB (but not SQLite).

It won't allow you to edit an ERD created in a different program, although you can import / reverse engineer a database schema and edit that imported diagram.

SQL Power Architect screenshot: opening screen
(source: sqlpower.ca)

SQL Power Architect screenshot: entity-relationship diagram
(source: sqlpower.ca)

SQL Power Architect screenshot: english comparison window
(source: sqlpower.ca)

SQL Power Architect screenshot: forward engineering SQL
(source: sqlpower.ca)

  • Development on this tool has stopped.
    – user14090
    Commented Jan 20, 2021 at 14:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.