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


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.


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

  • 1
    I once read that the reverse engineering part requires a paid version. Could you please confirm? Sep 9, 2014 at 12:35
  • 3
    The free version does, but the enterprise version has more features. Sep 9, 2014 at 12:59
  • 1
    Sorry. It was my mistake when posting the question. Thank you for pointing that out. Sep 9, 2014 at 13:00
  • 1
    I notice you removed the request for 'free-or-pay' version from your posting. I don't blame you. I hope the free version does what you need. Sep 9, 2014 at 13:16
  • 1
    The free version definitely supports reverse engineering. I frequently use it for that. Aug 21, 2015 at 7:22

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


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 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

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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