Database Schema Drawing tools

One thought on “5 Tools to visualize database schemas”
March 28, 2019 – 04:53 pm
Database Schema Drawing Software - borrie

4. SchemaCrawler

Like Schemaspy, SchemaCrawler generates database diagrams using Graphviz. You can easily filter out tables, views, columns, stored procedure and functions based on regular expressions, using the grep functionality.

Note that SchemaCrawler is not just a diagramming tool but also a database schema discovery and comprehension tool and has powerful scripting ability, using JavaScript, Groovy, Ruby or Python,

5. SchemaBall

Schemaball is an SQL database schema viewer. It however requires Perl and a few modules, such as GD and optionally Math::Bezier and SQL::Translator. Schemaball creates flexible visualizations of database schemas. Schemas may be read from an SQL schema dump, flat file or a live database.

Shemaball was originally designed for MySQL and works with MySQL out of the box. While InnoDB tables support foreign keys (as of Mysql 3.23.44), MyISAM tables do not (as of 4.0). Therefore, Schemaball can identify foreign keys using CONSTRAINT table options, by regular expressions applied to participating tables, or by reading constraints from a file.

schemaballBesides the above mentioned tools, a recent one I discovered is Lucid Charts. It is a web based diagramming tool offering various flowcharts, er diagrams and more in a cloud environment. Because Lucid Chart runs in your browser, it doesn’t matter which kind of computer you use. It works for Mac, PC, and Linux! You can also import Visio files (.vdx.vsd, or .vsdx).

Lucid charts also enables one to import database schema or create one in the browser. Because it is cloud based, you can edit the charts in real-time collaboration with others, add comments do documents and track document revisions.

Lucidchart’s database import and export feature makes it easy to move your work to and from MySQL, Oracle, PostgreSQL and SQL Server. After importing, just drag your custom tables onto the canvas document and voila, the relationships will appear automatically. When you’re finished you can generate SQL code for a seamless transition.

Related Posts