How to reverse engineer an ERD from a SQL script in Lucid

You have to have a working database for LucidChart to import the "code" and generate diagram from the query provided by LucidChart. I don't have a working database - I just have SQL code for generating one. Is there no way to import this code into LucidChart to generate the ERD?

Hi Herman

Thanks for your post. Unfortunately what you're describing is not currently possible. In order to create an ERD in Lucidchart you need to run one of the provided queries in a supported DBMS to generate individual diagram shapes from your database schema.

We’re very interested in your feedback and committed to continually improving our products. If you’re willing to share, we’d love to hear more details about your use case or what you’d like to see in this experience posted in the Product Feedback section of the community - from here, other users can upvote it and add details of their own.

For more information on how Lucid manages feedback via this community, take a look at this post.

Tell me supported DBMS to generate individual diagram shapes from my database schema to import in Lucidchart.

Hi Afaq! Thanks for commenting. We support MySQL, Oracle PostgreSQL, and SQL Server. Hope this helps!