MySQL Workbench is a great tool for management of MySQL and MariaDB databases, but Community Edition is missing one important feature - ability to generate HTML documentation from database schema. But don't worry, there are a free plugins that fill that gap.

This is article is an overview of free plugins to MySQL Workbench Community Edition.

Introduction

All plugins work on MySQL Workbench models and you first need to reverse engineer your database schema into model before you can generate data dictionary.

1. WB Datadict

WB Datadict is a plugin for MySQL Workbench Community Edition that allows you to generate an HTML data dictionary from the model.

Sample output:

Live sample

Overview:

1. Exports entire documentation to single page HTML
2. Includes table and column descriptions

2. HTML Shema Report

HTML Shema Report plugin generates an HTML data dictionary for selected database schema.

Sample output:

Live sample

Overview:

1. Exports entire documentation to single page HTML
2. Includes table and column descriptions

3. DBDoc

DBDoc plugin generates an HTML data dictionary for selected model.

Sample output:

Live sample

Overview:

1. Exports documentation to text or HTML
2. Exports HTML to a single file
3. Includes table and column descriptions

4. Model Document Generation

The Model Documentation Generator plugin generates Markdown documentation from a database model.

Sample output:

Markdown/text:

Converted to HTML:

Overview:

1. Unlike the rest, this is not a HTML generator but a Markdown generator, a simple markup language that can be converted to HTML (another tool required)
2. Exports entire documentation to single page HTML
3. Includes table and column descriptions
4. Includes indexes

Bonus: Dataedo

Here's an alternative: Dataedo – a standalone database documentation tool. Free version exports to PDF and if you are willing to spend some bucks to a really nice HTML (far better than those above).

Sample HTML output:

See live sample

Sample PDF output:

Download PDF

Overview of free version:

1. Metadata (descriptions) are stored in a file
2. Export to PDF document
3. Rich text table description
4. Option to paste images

Overview of Pro version:

1. Interactive HTML export
2. ER diagrams
3. Multiple databases in one repository
4. Documenting foreign keys (including cross database) without constraints
5. Search through documentation
6. Custom fields

Download Dataedo