23

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. OpenCart Database Schema

If anyone could tell me what software created the above diagram, that would be great.

5 Answers 5

11

The screenshot you show comes from WWW SQL Designer:

  • free and open source (New BSD License)
  • online demo
  • retrieve (import) schema from existing database.
  • cross-platform (web application)

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.

1
  • I honestly have not understood how to import schema from existing database. It seems it requires an XML file and not an SQL file. Mar 24, 2023 at 11:22
9

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

enter image description here

0
8

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: Example diagram

Sualeh Fatehi, SchemaCrawler

1
7

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: enter image description here

1
  • 1
    +1 This is the easiest one to get working, also for SQLite. Additionally, their EULA allows the free program to be used commercially (dbvis.com/eula)
    – Aralox
    Jul 29, 2016 at 5:03
1

You can use DBeaver Community Edition.

It can create diagrams that look like this:

dbeaver

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.