<story><title>Show HN: Visualize Your Rails App to ER Diagram Automatically</title><url>https://www.holistics.io/blog/visualize-rails-database-to-erd-diagram/</url></story><parent_chain></parent_chain><comment><author>jaggederest</author><text>There&amp;#x27;s also &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;voormedia&amp;#x2F;rails-erd&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;voormedia&amp;#x2F;rails-erd&lt;/a&gt; and my favorite &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;amatsuda&amp;#x2F;erd&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;amatsuda&amp;#x2F;erd&lt;/a&gt; which is fully interactive (can write migrations based on changes from the UI)</text></comment>
<story><title>Show HN: Visualize Your Rails App to ER Diagram Automatically</title><url>https://www.holistics.io/blog/visualize-rails-database-to-erd-diagram/</url></story><parent_chain></parent_chain><comment><author>SOLAR_FIELDS</author><text>I recently discovered schemaspy and while it took a bit of working knowledge of java (need to execute a jar file from the command line) to get it working, it’s absolutely fantastic and one of the most sophisticated tools for dealing with ERDs at the DB level. Plus it’s open source! The only things I see that are possible improvements with this product are the fact that you don’t need to bootstrap a local database to generate this and it’s probably faster and easier to generate. I had a reasonably complex schema (200 ish tables with relationships) and schemaspy took about 3 minutes to generate the output. Once you do generate it though, it’s just a bunch of html and SVG in a folder so you don’t have to regenerate it until your scheme is updated.</text></comment>