
DbVisualizer is a very helpful tool for both administrators and developers, focused on database visualization and administration. The user is able to quickly connect, visualize details, explore the structure, execute SQL statements and perform many other operations on many database servers.
DbVisualizer uses JDBC drivers to establish connections to all major relational databases, including DB2 (Win/Linux), Informix IDS, JavaDB/Derby, MySQL, Oracle, PostgreSQL, SQL Server, Pervasive, SAP DB and more.
Moreover, thanks to the power and stability of Java environment and YFiles, an advanced visualization library, DbVisualizer can generate entity-relationship diagrams easily and very fast, choosing between different visualization modes (Hierarchic, Organic, Orthogonal, and Circular) and format options to show into the diagram (e.g. what content to show in each node: just the node name, node name with primary keys, or all the table fields) as well as graph controls like zoom, animation, bridge links, etc.
DbVisualizer requires Java VM 1.6 to use, and from the download page you can choose to download both the installer with Java VM included and the one without Java.
v9.2 [Jan 17, 2015]
Fixed bugs:
DB Support: MySQL: Occasional NullPointerException when generating DDL
DB Support: Oracle Exception when generating DDL for a View or when getting CLOB values
DB Support: Vertica: The Referenced Table and Referenced Columns are not set for a foreign key in Alter Table dialog.