Database documentation tools

List of tools that allow the documentation (e.g. with descriptions) of schema of your databases.

Database documentation is a set of descriptions of the data, that facilitate management, maintenance, and retrieval of resources. Documentation can take many forms, however, it usually acts as a data catalog that holds detailed information about the table schema, all relationships, data types, etc. Description of datasets as well as single data objects also is referred to as metadata (data about the data).

DeZign for Databases

DeZign for Databases is an intuitive data modeling tool that can help you model, create and maintain databases along with generating the documentation of the models.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,MS Word,PDF
ER Diagram: Yes
Dependencies: Yes

DbWrench

DbWrench helps in creating and modifying databases quicker and easier. It streamlines many common database tasks and generates HTML documentation of database designs.

Commercial: Commercial
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML
ER Diagram: Yes
Dependencies: Yes

DbSchema

DbSchema facilitates to design, document and manage SQL and NoSQL databases. It is an intuitive designer for complex databases and provides documentation in HTML and PDF formats with interactive diagram vector image.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

SQLGate

SQLGate is an integrated database management and development solution that simplifies the construction and operation of databases. It allows you to generate database documentation containing details of all objects created in the database.

Commercial: Commercial
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

ERBuilder Data Modeler

ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases.

Commercial: Commercial
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML
ER Diagram: Yes
Dependencies: Yes

Toad Data Modeler

Toad Data Modeler enables developers, DBAs, and designers to create, edit, maintain, and document quality database designs and structures across various database platforms.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF,RTF
ER Diagram: Yes
Dependencies: Yes

DBDesigner 4

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation, maintenance and documentation into a single, seamless environment.

Commercial: Commercial
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF,XML
ER Diagram: Yes
Dependencies: Yes

Database Deployment Manager

Database Deployment Manager (DDM) tool is a multi-platform tool that allows database administrators and users to create database structures (tables, queries, etc.) using an object-oriented methodology that can be used to populate multiple databases. It further offers documentation of complete database structures.

Commercial: Free
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

Database Designer for MySQL

Database Designer for MySQL is a Powerful MySQL-oriented solution for database structure modeling, generation, and modification. It generates powerful reports that describe all the database objects within your diagram.

Commercial: Commercial
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

AnySQL Maestro

AnySQL Maestro is the premier multi-purpose admin tool for database development and management which include editing, grouping, sorting and filtering abilities. It provides Generate Database Report Wizard through which you can create HTML or PDF report for the database structure of the selected object in the whole or partially.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

SQL Maestro for MySQL

SQL Maestro for MySQL is a complete and powerful database management, admin and development tool for MySQL and MariaDB. It provides Generate Database Report Wizard through which you can create HTML or PDF report for the database structure of the selected object in the whole or partially.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF
ER Diagram: Yes
Dependencies: Yes

ERDesigner NG

Mogwai ERDesigner is a free and open source entity relationship modeling/design tool and also generates schema documentation in different formats. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation and documentation.

Commercial: Free
Free edition: Yes
Allows editing: Yes
Metadata stored in: External repository
Export: HTML,PDF,RTF
ER Diagram: Yes
Dependencies: Yes

pgDesigner

pgDesigner is an open source data model designer for PostgreSQL. It comprises of different handy features to support database development, management, and reverse engineering in a graphical way. Besides that, it supports model documentation in HTML, PDF, and TXT formats. The generated documents contain, in a textual and descriptive content of the project, the objects contained therein each with its respective properties and configurations.

Commercial: Free
Free edition: Yes
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML,PDF,Plain text
ER Diagram: Yes
Dependencies: Yes

SQLyog

SQLyog is the most powerful manager, admin and GUI tool for MySQL, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools in a single intuitive interface. It provides you with powerful means to manage and do HTML schema documentation of your MySQL databases.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: HTML
ER Diagram: Yes
Dependencies: Yes

MagicDraw

MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. It includes the entity-relationship diagram, SQL database modeling/diagramming and DDL script generation/reverse features. Its automatic report generation engine rapidly-produce comprehensive, professional requirements, software design documentation, and other types of reports in HTML, PDF, and RTF formats.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: External repository
Export: HTML,PDF,RTF
ER Diagram: Yes
Dependencies: Yes

Database documentation tools support data management by creating helpful descriptions, meaningful aliases, and annotating data assets with additional elements. The tools capture all the relevant information about the metadata and make it available to the users in a convenient way (tabular or graphical). The features of documentation tools can vary widely. The tools allow users to:
• Facilitate datasets with meaningful descriptions/aliases,
• Create relational diagrams,
• Advance search of resources,
• Track schema changes,
• Document repositories from various sources, through compatibility with many database engines,
• Automatic documentation export to user-friendly formats and easy-to-share formats (HTML, PDF, Excell )

Developers (especially those working on the backend) are constantly faced with questions from non-IT teams or customers about what a given object means. This is because creating and maintaining documentation is not a top priority. However, using documentation tools has many benefits such as:
• Help Data stewards quickly discover database schema,
• Data becomes understandable for non-IT members,
• Documentation as a single source of truth about the data is available to everyone
• Easier implementation for new people working on the repository,

We have selected database documenters that, we believe, are truly noteworthy. We have included both, open-source tools and advanced, professional software (offering trial versions).