SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Database documentation tools for Oracle
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).
Visual Expert for Oracle
Visual Expert for Oracle is a must-have solution for the maintenance of your Oracle code. It enables you generate documentation from the source code and creates reference manuals in HTML. You can also automatically generate the documents on a regular basis (scheduled tasks).
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | External repository |
| Export: | HTML |
| ER Diagram: |
|
| Dependencies: |
|
Document! X
Document! X provides automatic documentation of SQL Server, Access, Oracle and other OLE DB databases. The generated database documentation is an accurate and comprehensive documentation set covering Schemas, Tables, Columns, Indexes, Relationships, Views, Stored Procedures, Triggers, etc.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | XML |
| ER Diagram: |
|
| Dependencies: |
|
dModelAid
dModelAid is the perfect modeling tool for documenting a complex database design in a simple, interactive diagram. Your database project gets documented along the way, simplifying the learning process for new employees, team members and/or substitutes.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF |
| ER Diagram: |
|
| Dependencies: |
|
Vertabelo
Vertabelo is a database modeler that gives you the power of visual design of databases online and create and export documentation for your current model with just a few clicks.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,MS Word,PDF |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,MS Word,PDF |
| ER Diagram: |
|
| Dependencies: |
|
DbWrench
DbWrench helps in creating and modifying databases quicker and easier. It streamlines many common database tasks and generates HTML documentation of database designs.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF,RTF |
| ER Diagram: |
|
| Dependencies: |
|
DBDesigner 4
DBDesigner 4 is a visual database design system that integrates database design, modeling, creation, maintenance and documentation into a single, seamless environment.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF,XML |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF |
| ER Diagram: |
|
| Dependencies: |
|
Oracle Maestro
Oracle Maestro is the premier Oracle admin tool that supports all the Oracle versions from 8i to 12c. It helps in database development and management and 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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML,PDF |
| ER Diagram: |
|
| Dependencies: |
|
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.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Free |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | External repository |
| Export: | HTML,PDF,RTF |
| ER Diagram: |
|
| Dependencies: |
|
ClearDB Documenter
ClearDB Documenter generates comprehensive database documentation. It 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, source code.
| Data Lineage: | - |
|---|---|
| Runs on: (for desktop): | - |
| Commercial: | Commercial |
| Free edition: |
|
| Allows editing: |
|
| Metadata stored in: | Database comments/extended properties |
| Export: | HTML |
| ER Diagram: |
|
| Dependencies: |
|
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).