We are encountering significant limitations with the AI functionality for generating ER diagrams, particularly when dealing with large database schemas. Initially, the AI accurately generates diagrams when provided with SQL DDL scripts containing up to approximately 40 tables. However, beyond this threshold, issues arise where the AI starts to omit tables and columns from the generated diagram.
Specifically, when attempting to create an ER diagram from a SQL DDL script containing 85 tables, the AI consistently fails to capture the complete schema. Even when attempting to provide the data in smaller batches (e.g., 10-15 tables at a time), the AI still exhibits inaccuracies after approximately 40 tables, missing crucial data points.
We have to do the manual work to create our ER diagram. After that, when we tried to add more table to existing heavy ER diagram , AI just did not work. so its manual effort forever.