Database documentation tools

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

SchemaToDoc

SchemaToDoc documents SQL Server and Oracle databases. It exports SQL Server and Oracle metadata to easy-to-read Word or HTML files. The program documents: Primary Keys, Field Information (type, size, defaults, nullable, identity), Indexes, Check Constraints, Comments, Foreign Keys, Triggers, Views, Functions, and Stored Procedures.

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

DBMaster

DBMaster is a effective database management tool that helps to automate every day SQL Server administration tasks, highlight database issues, generate custom reports and share information between all team members.

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

SQL Documentation Tool

SQL Documentation tool is a documentation tool that provides automatic documentation of entire SQL Server databases. It documents the main entities in a database, including tables, views, functions, stored procedures, triggers, table indexes, dependency information, DTS packages, full text indexes. The transact SQL code associated with views, stored procedures and triggers is also included with the documentation.

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

Data Dictionary Creator

Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.

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

DBDocumenter

DBDocumenter is an interactive free and open source tool designed to generate SQL Server (2000, 2005, 2008) documentation.

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

SQL Documentor

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

XIA Configuration Server

XIA Configuration Server is an automated network documentation tool that helps you keep track of your IT infrastructure. It supports servers and workstations, AD, Exchange, Clusters, IIS, SQL, DNS and more.

Commercial: Commercial
Free edition: No
Allows editing: No
Metadata stored in: -
Export: PDF,XML
ER Diagram: No
Dependencies: No

SQL Data Dictionary

SQL Data Dictionary can generate a professional quality document of the tables, views, procedures, and functions in your SQL Server database down to the column level details. It includes indexes, foreign and primary keys, and usage by stored procedures and functions. It also includes an easy to use description editor to quickly allow you to add additional documentation directly into the database.

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

DB>doc for Microsoft SQL Server

DB>doc for Microsoft SQL Server is a free and open-source tool for generating documentation for Microsoft SQL Server (2008 and 2008 R2) database. The tool will map database structure, read information about tables, views, constraints etc., combine them with available descriptions and generate documentation in various formats:

Commercial: Commercial
Free edition: Yes
Allows editing: No
Metadata stored in: -
Export: HTML,WikiPlex,XML
ER Diagram: No
Dependencies: No

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

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