As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench.

I found schemaSpy, which is capable of generating diagrams from many database architectures, but it can't connect to Apex. (AFAIK)

Most of the other tools I found are doing the opposite of what I want - they let you design your scheme in a nice user interface and generate the according SQL statements afterwards.

As it was mentioned in the comments (and in other questions on stackexchange), it's possible to connect to Oracle Apex through ODBC, generating a diagram with some tools, i.e. Microsoft Visio.

Maybe I have to do it this way, but I was curious, if it's possible even without an existing database scheme; just SQL.

Is there a free (better: open source) tool which analyzes given CREATE TABLE-statements, including foreign keys, to an entity relationship diagram?

  • As in Oracle APEX? There are plenty of apps that will connect to an Oracle database and generate ERDs from schemas
    – Philᵀᴹ
    May 14, 2014 at 16:43
  • @Phil yes, Oracle Apex - if there is no tool like the one I'm looking for, I guess I have to do it this way.
    – stuXnet
    May 14, 2014 at 16:59
  • Maybe this previous question on stackexchange helps you: dba.stackexchange.com/questions/14172/… May 14, 2014 at 21:41
  • 1
    I can imagine. We've written our own. We extract datamodel into graphml and then use yEd to lay it out nicely. May 15, 2014 at 7:25
  • 1
    @swasheck I was looking for a free / open source tool. None of your suggestions match my criteria.
    – stuXnet
    Oct 3, 2014 at 15:54


Your Answer

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

Browse other questions tagged or ask your own question.