AI Inaccuracy in Generating ER Diagrams for Large Database Schemas
complete
Devansh Trivedi
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.
Yoel Tadmor
complete
Yoel Tadmor
Hi Devansh Trivedi,
We've recently added the ability to use stronger / premium models in our AI. We've found those models to be more effective with larger and more complex inputs and diagrams.