Data dictionary tools

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

Data Dictionary is a set of important information about data used within an organization (metadata). This information includes names, definitions, and attributes about data, owners, and creators of assets. Data Dictionary tools provide insights into meaning and purposes of data elements. They add useful aliases about the scope and characteristics of data elements, as well as the rules for their usage and application.

Dataedo

Dataedo enables you to catalog, document and understand your data with Data Dictionary, Business Glossary and ERDs. It enables to document your relational databases and share documentation in interactive HTML.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Excel,PDF
Metadata stored in: Documentation repository/file
Commercial: Commercial
Free edition: No
Notable features: ER diagrams, metadata repository, schema change tracking, organizing with modules, documenting missing FKs, custom fields, description suggestions, documentation progress tracking, rich text with images
Runs on: (for desktop): Mac OS,Windows
Database Web Table Diagram
Dataedo Web Table Columns
Database Web Business Glossary

Elasoft SqlSpec

SqlSpec is a database documentation tool that generates documentation about all the objects (tables, views, stored procedures, triggers, indexes, constraints, functions, etc) in your database. It has both GUI and command-line interface. It enables you to generate entity-relation diagrams.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Documents also Analysis Services, Reporting Services, Integration Server
Runs on: (for desktop): Windows

DTM Schema Reporter

DTM Schema Reporter is a documenting tool for database schema. With DTM Schema Reporter, you can analyze and audit database structure, create schema documentation, create a hard copy of the structure snapshots, etc.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML,MS Excel,MS Word,PDF,Plain text,RTF,XML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Entity relationship diagrams
Runs on: (for desktop): Windows

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.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CHM,HTML
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Dependency diagrams, Data model diagrams, Custom extended properties
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

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

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

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

ER/Studio

ER/Studio Data Architect helps to easily reverse- and forward-engineer, compare and merge, and visually document data assets across multiple platforms and data sources. The Data Dictionary is a feature of ER/Studio that allows the sharing of many objects including domains, defaults, rules, and attachments. Using the Data Dictionary you can enforce standards, promote reuse, and build a common framework across all models.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML
Metadata stored in: Documentation repository/file
Commercial: Commercial
Free edition: No
Notable features: Data modeler, Entity relation diagram, Model sharing
Runs on: (for desktop): Windows

Xcase

Xcase is a complete database design tool engineered to help you accomplish all your database-related tasks – from database design to modeling to daily modifications – with greater speed and higher quality. It provides access and edit feature for all meta-data attributes (including your own) using customizable browsers and attribute inspectors and provides a fully customizable data dictionary which allows you to include user-defined attributes.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: CSV
Metadata stored in: Program metadata
Commercial: Commercial
Free edition: Yes
Notable features: Fast and accurate database modeling tool
Runs on: (for desktop): Windows

MagicDraw

MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. It includes the entity-relationship diagram, SQL database modeling/diagramming and DDL script generation/reverse features. Its automatic report generation engine rapidly-produce comprehensive, professional requirements, software design documentation, elements of MagicDraw data dictionary, and other types of reports.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF,RTF
Metadata stored in: Program metadata
Commercial: Commercial
Free edition: No
Notable features: User-friendly visual interface, fast database modeling, Work collaboratively on the same model, Automatic report generation
Runs on: (for desktop): Linux,Mac OS,Windows

WinA&D

WinA&D is a comprehensive tool for system analysis, requirements management, structured analysis and design, object-oriented modeling with UML and data modeling of information systems. It supports code generation, integrated code browsing, linked text specifications or foreign documents and data dictionary.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,PDF
Metadata stored in: Program metadata
Commercial: Commercial
Free edition: Yes
Notable features: System models & simulation, code generation from models, models from code, custom project reports
Runs on: (for desktop): Mac OS,Windows

DatabaseSpy

Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool that even generates elegant charts directly from query results. The tool lets you can examine tables and relationships in an existing database, edit tables to better suit your needs, or even can add entire tables and specify all their column attributes and relationships to other tables from scratch.

Desktop/Cloud: Desktop
ER Diagram: Yes
Export: HTML,MS Word,PDF,RTF
Metadata stored in: Database metadata
Commercial: Commercial
Free edition: No
Notable features: Graphical database design, Complete DDL scripts for database schemas, Data visualization and charting, Advanced database reporting with charts, Database content editor
Runs on: (for desktop): Windows

Key functionality of Data Dictionary tools is to give users the ability to document data. Moreover, very important is the possibility to create a collection of multiple repositories, based on different system engines. For a better understanding of the data, some tools allow visualization of the data structure using ERD (Entity-Relationship Diagrams).

From the organization's point of view, a community module within a data dictionary tool proves to be useful. It facilitates the proper information flow, as well as provides sharing opinions on specific objects among the members of an organization.

Nowadays, data discovery and understanding becomes crucial for proper organization performance. There are many benefits to using Data Dictionaries, such as:
• helps avoid data inconsistencies problems,
• it allows introducing unified nomenclature used in the project,
• Make data searchable, and understandable,
• Create a single source of truth about the data from different repositories,

The prepared list includes simple, open-source data dictionaries as well as more advanced software.