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

dbForge Documenter for Oracle

dbForge Documenter for Oracle is a handy visual tool for documenting Oracle databases. The tool includes a wide range of options to set up, customize and fine-tune the generated documentation and allows automating Oracle database documenting with the command-line interface.

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

dbdesc

dbdesc is a powerful tool to help you document your databases. It can produce detailed documents describing your databases. Now dbdesc includes a built-in report engine and report viewer to easily browse database documentation.

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

Elasoft SqlSpec

SqlSpec is a database documentation tool that generates documentation about all the objects (tables, views, stored procedures, triggers, indexes, constraints, functions, etc) in your database. 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

SentryOne Document

SentryOne Document offers complete documentation for SQL Server databases and BI tools, including SSIS, SSRS, SSAS, Oracle, Hive, Tableau, Informatica, and Excel. In addition, the documentation can be customized for different audiences, so users only see the most relevant information for their role.

Commercial: Commercial
Free edition: No
Allows editing: Yes
Metadata stored in: External repository
Export: CHM,HTML,MS Word,RTF
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, and 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: No

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

DTM Schema Reporter

DTM Schema Reporter is a documenting tool for database schema. With DTM Schema Reporter, you can analyze and audit database structure, create schema documentation, 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

EZ Data Dictionary

EZ Data Dictionary is a user-friendly data dictionary tool for business and technical end users. Documenting database through EZ Data Dictionary provides better results as compared with Excel. It allows users to review database elements and definitions in a friendly environment and provides better communication between systems professionals and end-users.

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

Oracle SQL Developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. Besides database development, it is a handy-tool for database documentation.

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

PLDoc

PLDoc is an open-source utility for generating HTML documentation of code written in Oracle PL/SQL. Working similarly to JavaDoc, it parses PL/SQL packages, object types, functions, procedures, and triggers, finding comments of definitions and building HTML format technical documentation for your project.

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

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