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ᵀᴹ
    Commented 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
    Commented May 14, 2014 at 16:59
  • Maybe this previous question on stackexchange helps you: dba.stackexchange.com/questions/14172/… Commented 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. Commented 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
    Commented Oct 3, 2014 at 15:54


Your Answer

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

Browse other questions tagged or ask your own question.