Database documentation tools

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

Dataedo

Dataedo enables you to catalog, document and understand your data with Data Dictionary, Business Glossary and ERDs. It enables to document your relational databases and share documentation in interactive HTML.

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

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

Leadum DBScribe

DBScribe is a SQL documentation tool that automatically creates comprehensive technical documentation of every detail of your database schema. DBScribe SQL documentation tool helps prevent from long routing documenting work and synchronization with database changes, enabling to perform precise database documentation.

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

Yohz DB Doc

DB Doc is the documentation tool for PostgreSQL databases. It customizes the layouts to your needs and automates the documentation generation process os that you could even generate your database schema documents every hour, ensuring you'll always have the most up-to-date details.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: Database comments/extended properties
Export: CHM,HTML,PDF
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

TechWriter for Databases

TechWriter for Databases is a documentation tool for databases that leverages the information locked inside your database to automatically produce database reference documentation for Access, MySQL, Oracle, SAS, SQL Server, PostgreSQL and DB2 databases.

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

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

SQL Documentor

Commercial: Commercial
Free edition: -
Allows editing: No
Metadata stored in: N/A
Export: HTML,MS Excel,PDF
ER Diagram: -
Dependencies: -

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

Vertabelo

Vertabelo gives the user the power of visual design of database online and create and export documentation for your current model with just a few clicks.

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

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

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