5

In Lucidchart there is a great beta feature called 'Automated ERD Import' where you can import all tables, columns, constraints etc from a database. This is super useful as you can quickly build ERDs within minutes without manually creating any entities.

At my workplace we are now using Draw.io so I am wondering if there is an equivalent or similar feature that can help me in avoiding manually creating entities.

I've had a look through the Draw.io online user manual but haven't been able to find anything useful. Is this possible?

0

2 Answers 2

12

draw.io has a generic SQL import under the Arrange->Insert->SQL menu:

Insert SQL menu option in draw.io

Copy and paste your SQL commands in to the dialog and press insert:

enter image description here

2
  • Is there a way to edit the design? (To have the Datatype in a seperate column from the name)
    – A.bakker
    Nov 2, 2022 at 9:01
  • Sadly doesn't import/infer foreign key relationships. Jan 13, 2023 at 13:31
4

Since August 2015 you can import your Lucidchart in Draw.io. According to this explanation you have to do the following:

  1. Save your ERD as a Gliffy JSON format
  2. Import it in Draw.io throug: File -> Import from ...

Maybe when the ERD is imported it also automatically makes the columns, constraints and eventually tables.

1
  • @Thomas The Tank Engine, is any native support for relationships planned? Thanks!
    – ddsultan
    Jun 15, 2022 at 19:32

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.