Please recommend a tool to visualize database schema.
It should be able to generate schema of existing DB.
support - mySQL
platform - Linux/Windows
licence - free/open-source
Something like the image depicts. Colors are not that important.
If anyone could tell me what software created the above diagram, that would be great.
The screenshot you show comes from WWW SQL Designer:
Description from the website:
This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs (flash). You only need JavaScript enabled. The Designer works perfectly in Mozillas (Firefox, Seamonkey), Internet Explorers (6, 7, 8), Safari and Operas. Konqueror works, but the experience is limited.
Many database features are supported, such as keys, foreign key constraints, comments and indexes. You can either save your design (for further loading & modifications), print it or export as SQL script. It is possible to retrieve (import) schema from existing database.
Try MySQL Workbench - it is free: http://dev.mysql.com/downloads/workbench/
Screen shots of the visual design: http://www.mysql.com/products/workbench/design/
Platforms: Windows, Linux, Mac OS X
SchemaCrawler is a free, open source, and platform independent command-line tool that can generate database diagrams from an MySQL database. You can exclude tables and columns from the diagram using regular expressions. It is free and open-source.
Example diagram:
Sualeh Fatehi, SchemaCrawler
You can try DbVisualizer. Most of its features I have described in my answer to a related post, so you can take a look.
In general it is a free Java-based tool for database management, that supports a large number of databases. It does support database schema visualization.
Here is an image taken from their website:
You can use DBeaver Community Edition.
It can create diagrams that look like this:
There is also a nice auto-layout feature that minimizes cross-overs of relationship-lines. Also these lines get drawn such that they do not overlap with the table-rectangles.
(The picture above does not show this)
