Data dictionary tools

List of tools that enable design and building of data dictionaries.

SQL Data Dictionary

SQL Data Dictionary includes an easy to use description editor to quickly allow you to add additional documentation directly into the database. It provides column level detail on SQL Server primary keys, data types, and defaults along with descriptions that enables you to easily find missing indexes and incorrect column definitions.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML,PDF
Metadata stored in: SQL Server extended properties
Commercial: Commercial
Free edition: No
Notable features: Column level details, Description editor
Runs on: (for desktop): Windows

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.

Desktop/Cloud: Desktop
ER Diagram: No
Export: CHM,Help,XML
Metadata stored in: SQL Server extended properties
Commercial: Commercial
Free edition: No
Notable features: Documentation of SQL Server Reporting Services RDL files
Runs on: (for desktop): Windows

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.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML,PDF
Metadata stored in: Documentation repository
Commercial: Commercial
Free edition: -
Notable features: Compare two schemas
Runs on: (for desktop): Windows

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 and data dictionary.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Program repository
Commercial: Free
Free edition: Yes
Notable features: Entity relationship diagrams
Runs on: (for desktop): Linux,Mac OS,Windows

Semanta Encyclopaedia

Semanta Data Dictionary is a data governance platform that enables data and context to be brought together in a simple, modern and collaborative way. The key features include technical data documentation, integration with operational metadata and providing links between data definitions and its business context.

Desktop/Cloud: Desktop
ER Diagram: No
Export: Online HTML
Metadata stored in: Program metadata
Commercial: Commercial
Free edition: No
Notable features: Integration with modeling tools and ERP applications. Ability to comment data quality. ER and dependency diagrams. Online portal with collaboration features.
Runs on: (for desktop): Windows

turtle SQL

Turtle SQL is a free and open source tool designed to generate the SQL Server (2005, 2008, 2012) documentation.

Desktop/Cloud: Desktop
ER Diagram: No
Export: MS Excel,PDF,XML
Metadata stored in: Database metadata
Commercial: Free
Free edition: Yes
Notable features: SQL Server 2005/2008 and 2012 documentation
Runs on: (for desktop): Windows

Ataccama Data Catalog & Business Glossary

Ataccama Data Catalog & Business Glossary tool provides automatic mapping of terms to real data sources in the Data Catalog during profiling, ensuring the Data Catalog is always up-to-date and synced with the Business Glossary.

Desktop/Cloud: Desktop
ER Diagram: No
Export: -
Metadata stored in: Program respository
Commercial: Commercial
Free edition: Yes
Notable features: Automated Mapping of Business Terms, Up-to-date Business Glossary, Data Discovery on Multiple Sources
Runs on: (for desktop): Windows

Vertabelo

Vertabelo gives the user the power of visual design of database online. It allows the user to generate metadata of the database and write comments for the database objects.

Desktop/Cloud: Cloud
ER Diagram: Yes
Export: HTML,MS Word,PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Cloud database design, reverse engineering, document sharing
Runs on: (for desktop): -

Visual Paradigm

Visual Paradigm provides a tool to create and communicate visual database design with professional ERD tool. It allows the user to create customize template to generate a data dictionary for the class models and its attributes in your project.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Word,PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagram, Reverse engineering, SQL script
Runs on: (for desktop): Linux,Mac OS,Windows

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.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagram, Model customization, Easy migration
Runs on: (for desktop): Windows

MySQL Workbench

MySQL Workbench is a visual tool for database architects, developers and DBAs. MySQL Workbench provides data modeling, development, administration and documentation tools for MySQL. With the help of HTML Shema Report plugin, user can generate data dictionary from existing MySQL database.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Visual database design, SQL Editor, Data documentation and migration
Runs on: (for desktop): Linux,Mac OS,Windows

erwin Data Modeler

erwin Data Modeler (erwin DM) is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It helps to create & maintain sound relational database designs and data dictionary of those models.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: PDF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Data modeling, Entity relation diagram, Forward & Reverse Engineering
Runs on: (for desktop): Linux,Mac OS,Windows

DbWrench

DbWrench helps in creating and modifying databases quicker and easier. It streamlines many common database tasks such as editing database items directly in the diagram or in SQL script, etc.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: Yes
Notable features: Diagram database editing, Entity relation diagram, Column templates, HTML documentation
Runs on: (for desktop): Linux,Mac OS,Windows

Base One Data Dictionary

The BFC Database Library is built on a Data Dictionary, which provides a complete description of record layouts and indexes of the database, for validation and efficient data access. You can use the data dictionary for automated database creation, including building tables, indexes, and referential constraints, and granting access rights to individual users and groups.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML
Metadata stored in: Documentation repository/file
Commercial: Commercial
Free edition: No
Notable features: Detailed Database Description
Runs on: (for desktop): Windows

Data Dictionary Generator

Data Dictionary Generator can be used to generate data dictionary, compare database schema and spell check schema.

Desktop/Cloud: Desktop
ER Diagram: No
Export: HTML
Metadata stored in: -
Commercial: Free
Free edition: Yes
Notable features: Free data dictionary tool
Runs on: (for desktop): Windows