19

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.

9

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.

8

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? – rahulroy9202 Sep 9 '14 at 12:35
  • 2
    The free version does, but the enterprise version has more features. – Jeff Clayton Sep 9 '14 at 12:59
  • Sorry. It was my mistake when posting the question. Thank you for pointing that out. – rahulroy9202 Sep 9 '14 at 13:00
  • 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. – Jeff Clayton Sep 9 '14 at 13:16
  • 1
    The free version definitely supports reverse engineering. I frequently use it for that. – Mawg Aug 21 '15 at 7:22
6

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

5

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 '16 at 5:03

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.