Database documentation tools

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

Elasoft SqlSpec

SqlSpec is a database documentation tool that will generate easy-to-read database documentation for almost all platforms. It has both GUI and command line interface. It enables you to generate entity-relation diagrams.

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

Spectral Core Documenter

Spectral Core Documenter is the easiest way to generate detailed documentation of your database. All tables, procedures, functions, triggers, user-defined types are listed with every detail.

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

DTM Schema Reporter

DTM Schema Reporter is a documenting tool for database schema. This utility helps technical writers, developers, and database administrators create a database schema report within seconds. With DTM Schema Reporter the user can analyze and audit database structure, create schema documentation, train your employees, create a hard copy of the structure snapshots, etc.

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

xSQL Documenter

xSQL Documenter provides comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format. It can run as a console application, useful for automating the process of generating documentation for your databases on a schedule, or for integrating xSQL Documenter into your development process.

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

SchemaSpy

Free and open source tool that generates interactive entity relationship diagrams to HTML from database schema. Requires Java 5 or higher.

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

DBDocumentor

DBDocumentor produces database documentation for the SQL objects in your database project. It generates a fully cross-referenced view of the SQL database, including where data is sourced from and what objects are modifying data in what other objects. These capabilities make DBDocumentor ideal for those wishing to learn the structure of a given database, or simply to document the database for future reference.

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

SchemaCrawler

SchemaCrawler is a free database schema discovery and comprehension tool. Using the tool, you can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation and is designed to be diff-ed against other database schemas.

Commercial: Free
Free edition: Yes
Allows editing: No
Metadata stored in: External repository
Export: CSV,HTML,JSON,Plain text
ER Diagram: Yes
Dependencies: Yes

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

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

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