38 Data Dictionary tools

This is the list of all data dictionary Data dictionary is data about data - list of tables, columns and their relationships with a description of each element. This is a basic way to document a relational database. generation tools for popular relational databases (Oracle, SQL Server, MySQL or PostgreSQL) we found on the web. If you found something else or some inaccuracies, let us know and we'll fix it.

Dataedo

dataedo.com

Data dictionary and Entity Relationship Diagarm creator.

Supports: SQL Server, Oracle, MySQL

Notable features: Entity Relationship Diagarms, Spliting objects into modules, Documenting missing foreign and unique keys, Documentation progress tracking, Rich text and images, Search, Global repository for documentation of all databases, Teamwork ready

more...

Export: HTML, PDF, MS Excel

Metadata stored in: Documentation repository/file

Allows editing: yes

Free edition: yes, Pricing from: $179

Last release: Sep 2016 (5.0.3)

Last updated: 30 Sep 2016

Redgate SQL Doc

www.red-gate.com/products/sql-development/sql-doc/

Supports: SQL Server

Notable features: Management Studio integration

more...

Export: HTML, PDF, MS Word, CHM

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $369

Last updated: 18 Sep 2016

dbForge Documenter for SQL Server

www.devart.com/dbforge/sql/documenter/

Database documentation generator for SQL Server

Supports: SQL Server

Notable features: SSMS Integration

more...

Export: PDF, HTML

Allows editing: no

Free edition: no, Pricing from: $149

Last updated: 08 Oct 2016

Database Note Taker

databasenotetaker.com

Supports: SQL Server

Notable features: Notifies about empty descriptions, shows edit history

more...

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $29

Last updated: 08 Oct 2016

ApexSQL Doc

www.apexsql.com/sql_tools_doc.aspx

Tool enablng documenting SQL Server databases and SSIS packages.

Supports: SQL Server

Notable features: Integration with Management Studio (SSMS), Database UML diagrams, Graphical dependencies

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Limitations: Non intuitive and confusing UI

more...

Export: CHM, HTML, PDF, MS Word

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: yes, Pricing from: $299

Last release: Dec 2015

Last updated: 08 Oct 2016

dbdesc

dbdesc.com

Supports: SQL Server, Oracle, MySQL, Access, Firebird

Limitations: Just exports metadata. No ability to edit descriptions.

more...

Metadata stored in: No metadata editing

Allows editing: no

Pricing from: $99

Last release: Aug 2014 (4.1)

Last updated: 08 Oct 2016

Doc xPress

pragmaticworks.com/Products/Doc-xPress

Supports: SQL Server, Oracle

Notable features: Lineage Analysis and Impact Analysis, include images

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Apache Hive, Excel

more...

Export: MS Word, HTML, CHM, RTF

Free edition: no, Pricing from: $395

Last updated: 18 Sep 2016

Spectral Core Documenter

www.spectralcore.com/documenter

Supports: SQL Server

more...

Export: HTML, CHM

Metadata stored in: No metadata editing

Allows editing: no

Free edition: no, Pricing from: $149

Last release: Mar 2011 (1.5)

Last updated: 18 Sep 2016

Elasoft SqlSpec

elsasoft.com

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, Sybase ASE, Sybase SQL Anywhere, Informix IDS, VistaDB, SQLite, ENEA Polyhedra, Raima RDM Server

Notable features: Documents also Analysis Services, Reporting Services, Integration Server

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

Limitations: Just exports metadata. No ability to edit descriptions.

more...

Export: HTML, CHM

Metadata stored in: No metadata editing

Allows editing: no

Free edition: no, Pricing from: $149

Last updated: 18 Sep 2016

LiveDoco

www.livedoco.com

Supports: SQL Server

Notable features: "Live" data dictionary, custom fields

more...

Export: HTML, XML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $49

Last updated: 18 Sep 2016

Document! X

www.innovasys.net/product/dx/overview

Authoring environment which can be used to create documentation for .NET, Web Services, Databases, XSD Schemas, COM Components and Type Libraries, Java and Javascript.

Supports: SQL Server, Access, Oracle

Notable features: Documents more than just databases, Visual Studio integration, Ability to integrate with social platforms (Facebook, Disqus) to enable commenting

Documents also: .NET, Web Services, XSD Schemas, COM Components and Type Libraries, Java and Javascript

more...

Export: HTML, CHM, Help, Visual Studio Help

Allows editing: yes

Free edition: no, Pricing from: $585

Last updated: 18 Sep 2016

Leadum DBScribe

www.leadum.com/products.php?prod_type=DBScribe

Supports: SQL Server, Oracle, MySQL, PostreSQL, DB2

more...

Export: CHM, HTML, MS Word

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $39

Last release: Oct 2010

Last updated: 18 Sep 2016

Yohz DB Doc

www.yohz.com/dbdoc_details.htm

Supports: PostgreSQL

Notable features: Customizable layout

more...

Export: PDF, HTML, CHM

Metadata stored in: PostgreSQL comments

Allows editing: yes

Free edition: no, Pricing from: $35

Last updated: 18 Sep 2016

DTM Schema Reporter

www.sqledit.com/sr/index.html

Supports: SQL Server, Oracle, DB2, MySQL, PostgreSQL, SQLite, Sybase and Interbase/Firebird

Notable features: Entity Relationship Diagrams

more...

Export: RTF/MS Word, HTML, CHM, PDF, XML, MS Excel, Plain text

Metadata stored in: Database metadata

Free edition: no, Pricing from: $159

Last updated: 18 Sep 2016

SchemaToDoc

www.schematodoc.com

Supports: SQL Server, Oracle

more...

Export: MS Word, HTML

Metadata stored in: SQL Server extended properties, Oracle comments

Allows editing: yes

Free edition: no, Pricing from: $40

Last updated: 18 Sep 2016

xSQL Documenter

www.xsql.com/products/database_documenter/

Supports: SQL Server, Oracle, DB2, MySQL, SQLite, Sybase ASE, Sybase SQL Anywhere, Informix IDS, PostgreSQL, Teradata, Access, VistaDB, ENEA Polyhedra, Raima RDM Server

Notable features: Dependency diagrams, Data model diagrams, Custom extended properties

Documents also: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

more...

Export: HTML, CHM

Metadata stored in: Database metadata

Allows editing: yes

Free edition: no, Pricing from: $199

Last release: Jan 2014 (4.8)

Last updated: 18 Sep 2016

TechWriter for Databases

techwriter.me/techwriter-for-databases.aspx

Documentation tool for databases that automatically produces database reference documentation.

Supports: SQL Server, MySQL, Oracle, PostgreSQL, Access, SAS, DB2

Notable features: Ability to organize topics into a hierarchical table of contents

more...

Export: PDF, CHM, MS Word/RTF, HTML, XPS, XML

Allows editing: yes

Last updated: 04 Nov 2016

DBMaster

www.dbmaster.io

DBA tool with Data Dictionary functionality.

Supports: SQL Server, MySQL

more...

Export: No

Metadata stored in: Program repository

Allows editing: yes

Free edition: yes, Pricing from: $95

Last updated: 18 Sep 2016

SQL Help Builder

www.sqlhelpbuilder.com

Supports: SQL Server

more...

Export: CHM, Help

Metadata stored in: Help file

Allows editing: yes

Free edition: no, Pricing from: $295

Last release: Jan 2006 (2.0)

Last updated: 18 Sep 2016

SchemaSpy

schemaspy.sourceforge.net

Free and open source tool that generates interactive entity relationship diagrams to HTML from database schema. Requires Java 5 or higher.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Sybase Server, SQLite, Teradata, Derby (JavaDB), Firebird, HSQLDB Server, Informix, MaxDB

Notable features: Entity Relationship Diagrams

Limitations: No UI (command line)

more...

Export: HTML

Metadata stored in: No metadata editing

Allows editing: no

Free edition: yes

Last release: Aug 2010 (5.0.0)

Last updated: 18 Sep 2016

SQL Documentation Tool

www.winnershtriangle.com/sql-documentation-tool/

Supports: SQL Server

more...

Export: HTML, Help, RTF/MS Word, plain text

Metadata stored in: No metadata editing

Allows editing: no

Free edition: no, Pricing from: $50

Last updated: 18 Sep 2016

Data Dictionary Creator

datadictionary.codeplex.com

Simple free and open source tool that enables documentomg SQL Server databases - it enables editing Extended Properties. Crashed on startup.

Supports: SQL Server

more...

Export: Excel, MS Word, HTML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: yes

Last release: Jul 2010 (1.3.4)

Last updated: 18 Sep 2016

DBDocumenter

dbdocumenter.codeplex.com

Free and open source tool designed to generate SQL Server (2000, 2005, 2008) documentation.

Supports: SQL Server

more...

Export: HTML

Metadata stored in: No metadata editing

Allows editing: no

Free edition: yes

Last release: Sep 2009 (1.0)

Last updated: 18 Sep 2016

SQL Documentor

www.sqldocumentor.com

Supports: SQL Server, Oracle, MySQL, PostgreSQL

more...

Export: PDF, HTML, MS Excel

Metadata stored in: No metadata editing

Allows editing: no

Last updated: 18 Sep 2016

XIA Configuration Server

www.centrel-solutions.com/XIAConfiguration/

Network documentation tool. Supports servers and workstations, AD, Exchange, Clusters, IIS, SQL, DNS and more.

Supports: SQL Server

more...

Export: PDF, XML

Metadata stored in: No metadata editing

Allows editing: no

Free edition: no, Pricing from: $500

Last updated: 18 Sep 2016

SQL Data Dictionary

www.sqldatadictionary.com

Supports: SQL Server

more...

Export: PDF, HTML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $200

Last release: Nov 2015 (1.5.2)

Last updated: 18 Sep 2016

Oracle SQL Developer

www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html

Free database IDE from Oracle.

Supports: Oracle

Notable features: Entity Relationship Diagrams

more...

Free edition: yes

Last updated: 18 Sep 2016

PLDoc

pldoc.sourceforge.net/maven-site/

Free and open source utility for generating HTML documentation of code written in Oracle PL/SQL.

Supports: Oracle

more...

Export: HTML

Free edition: yes

Last updated: 18 Sep 2016

DB>doc for Microsoft SQL Server

sqldbdoc.codeplex.com

Simple free and open source tool for generating documentation for SQL Server (2008, 2008 R2).

Supports: SQL Server

more...

Export: HTML, WikiPlex, XML

Metadata stored in: No metadata editing

Allows editing: no

Free edition: yes

Last release: Jan 2011

Last updated: 18 Sep 2016

turtle SQL

turtle.codeplex.com

Free and open source tool designed to generate the SQL Server (2005, 2008, 2012) documentation.

Supports: SQL Server

more...

Export: Excel, PDF, XML

Free edition: yes

Last release: Aug 2009

Last updated: 27 Sep 2016

SQLDoc

sqldoc.codeplex.com

Free and open source tool designed to generate the SQL Server (2005, 2008) documentation.

Supports: SQL Server

more...

Export: CHM

Metadata stored in: SQL Server extended properties

Allows editing: no

Free edition: yes

Last release: Aug 2011

Last updated: 18 Sep 2016

DBDocumentor

www.pikauba.com/DBDoc/Details.htm

Supports: SQL Server, Firebird, Sybase, SQL Anywhere

Notable features: Documentation of SQL Server Reporting Services RDL files

more...

Export: CHM, Help, XML

Metadata stored in: SQL Server extended properties

Allows editing: yes

Free edition: no, Pricing from: $160

Last updated: 18 Sep 2016

WB Datadict

bitbucket.org/sirgazil/wb-datadict

Plugin for MySQL Workbench Community Edition 6.x that generates an HTML data dictionary from the database schema.

Supports: MySQL

more...

Export: HTML

Metadata stored in: No metadata editing

Allows editing: no

Free edition: yes

Last release: Oct 2015 (1.0.1)

Last updated: 18 Sep 2016

Document my database

documentmydatabase.com

Data dictionary creator in the cloud accessible by the browser.

Supports: SQL Server, MySQL, Access

Notable features: Cloud based. Online sharing

more...

Export: Online HTML, PDF

Metadata stored in: Cloud repository

Allows editing: yes

Free edition: no

Last updated: 18 Sep 2016

Semanta Encyclopaedia

www.semantacorp.com/data-dictionary/

Data governance platform with Data Dictionary feature

Supports: SQL Server, Oracle, Teradata

Notable features: Integration with modeling tools and ERP applications. Ability to comment data quality. ER and dependency diagrams. Online portal with collaboration features.

more...

Export: Online HTML

Free edition: no

Last updated: 18 Sep 2016

SQLDoc Sharp

www.codeproject.com/Articles/35790/SQLDoc-Sharp

Free and open source tool designed to generate the SQL Server (2005, 2008) documentation.

Supports: SQL Server

more...

Export: CHM

Allows editing: no

Free edition: yes

Last updated: 18 Sep 2016

Data Dictionary Generator

ddgen.wordpress.com

Notable features: Compare Database schema

Limitations: No UI (command line)

more...

Export: HTML

Allows editing: no

Last updated: 18 Sep 2016

CSVReader SQL Server Data Dictionary

www.csvreader.com/posts/data_dictionary.php

Simple SQL script that will generate a data dictionary table.

Supports: SQL Server

Limitations: No UI or export

more...

Metadata stored in: No metadata editing

Allows editing: no

Free edition: yes

Last updated: 18 Sep 2016

Last research made on 16 September 2016