Skip to main content

It would be nice to be able to import a SQL table directly into an ERD.   For example, if I had the following code 
 

CREATE TABLE customer (

     id integer NOT NULL,

     first_name VARCHAR (50),

     last_name VARCHAR (50),

     PRIMARY KEY(ID)

)

 

This should be able to pull in the SQL and create an ERD diagram from that.  This is a feature that draw.io has that would be great if Lucid could have a similar feature.  The issue with the current import feature is that it is limited to only 4 databases and we currently use Redshift.

Hi, thanks for this idea! We encourage anyone else who’s interested in this to upvote this post and share any additional details about your use case or what you’d like to see in this experience. For more information about how we manage feedback in this community, please take a look at this post:

 


Hi ​@gardion

Thank you for taking the time to leave your feedback on this and let us know just how important this is to your workflow. We have some great news here and some exciting updates!

Lucid has expanded ERD import and export to support Snowflake, Databricks, Redshift, Azure SQL Database, and Google BigQuery. We’re excited to now offer our most requested vendors in an effort to make this process more efficient! 

I also wanted to mention a few additional enhancements to ERDs: 

  • Automatically generate ERD diagrams: Now you can automatically create diagrams from your SQL database. Import your data and it will populate in the left-hand panel. From there, you can drag and drop your entire imported database onto the canvas. Your ERD diagram will automatically generate, creating an organized ERD with all tables and relationships. 
  • Collapsible ERDs: We’ve introduced the ability to collapse and expand tables to tidy up complex ERDs. You can navigate to the contextual panel or expand and collapse from the shape itself. 

For the full scoop on what’s new, check out this community post:


IdeaDelivered