Database documentation generators for Oracle

List of tools that automatically generate documentation for your database. For more advanced capabilities see Database Documentation Tools

Dataedo

Dataedo enables you to create data documentation of your existing databases. It reads your schema and lets you easily describe each data element (tables and columns) and other database objects (like triggers, stored procedures, etc.) visually as ER diagrams.

Commercial: Commercial
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Excel,PDF
Free edition: No
Runs on: (for desktop): Windows

SchemaSpy

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates an interactive entity-relationship diagram in a browser-displayable format.

Commercial: Free
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Free edition: Yes
Runs on: (for desktop): Linux,Mac OS,Windows

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
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CSV,HTML,JSON,Plain text
Free edition: Yes
Runs on: (for desktop): Linux,Mac OS,Windows

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
Dependencies: No
Desktop/Cloud: Desktop
ER Diagram: No
Export: CSV,HTML
Free edition: No
Runs on: (for desktop): Windows

OraDoclet

OraDoclet generates detailed database documentation that resembles the JavaDoc style. It is a custom doclet that functions either with the JavaDoc tool or as a standalone Java application. The documentation generated has a form of static HTML files and describes all objects in the given Oracle database schema.

Commercial: Free
Dependencies: No
Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML
Free edition: Yes
Runs on: (for desktop): Windows

dbForge Documenter for Oracle

dbForge Documenter for Oracle is a handy visual tool for documenting Oracle databases. It automatically generates documentation of an entire Oracle database. 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
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML,Markdown,PDF
Free edition: No
Runs on: (for desktop): Windows

ClearDB Documenter

ClearDB Documenter generates comprehensive database documentation. The tool analyses and reports on a complete set of 59 schema (tables, views, procedures, functions, packages, types, triggers, etc) and non-schema (contexts, directories, profiles, users, roles, etc) object types with all their properties, DDL, privileges, synonyms, references, dependencies, and source code.

Commercial: Commercial
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Free edition: No
Runs on: (for desktop): Windows

KeepTool

KeepTool DB Doc enables you to generate appealing documentation of your database in HTML format with only a few clicks. All you have to do is connect KeepTool with your database, select the database elements (view definitions, triggers, dependencies, stored procedure, etc) you want in the documentation, and click the create documentation button.

Commercial: Commercial
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML
Free edition: No
Runs on: (for desktop): Windows

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
Dependencies: No
Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML
Free edition: Yes
Runs on: (for desktop): Windows

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. It also allows developers to easily deploy databases by offering a sophisticated visual data modeling environment.

Commercial: Commercial
Dependencies: Yes
Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Free edition: -
Runs on: (for desktop): Windows