The term Data Dictionary Creator refers to a few different software tools used to build and maintain metadata descriptions of datasets and databases. Because multiple projects share this name, the exact features depend entirely on which version you are referring to: 1. Research & Open Science (R Shiny App)
Developed in collaboration with the Society for Improvement of Psychological Science (SIPS), this Data Dictionary Creator is an open-science web application.
Purpose: It helps researchers quickly generate standard codebooks or metadata documentation for their scientific datasets.
How it works: Users upload data files (like CSV, Excel, SAS, or SPSS) into a graphical user interface.
Key Features: Allows you to specify variable names, descriptions, data types, missing value codes, minimum/maximum ranges, and custom categorical labels (such as mapping Likert scale numbers to text).
Outputs: Generates clean CSV files for variable attributes, an R script containing pre-labeled attributes, and a machine-readable JSON file built on schema.org standards for easy repository uploads. 2. SQL Server Database Documentation (Jon Galloway)
This is an older, classic open-source developer tool created by programmer Jon Galloway to rapidly document relational databases.
Purpose: It solves the problem of documentation getting lost or detached from the code by storing metadata directly inside SQL Server Extended Properties.
Key Features: It scans your Microsoft SQL Server, automatically pulls the schema, and gives you a UI to fill in column descriptions and custom tracking fields.
Outputs: When finished, it can export the dictionary directly into WordML, Excel, HTML, or XML documentation files. 3. OutSystems Component (Forge Tool)
Within the OutSystems low-code ecosystem, there is a published component called the Data Dictionary Creator (O11).
Purpose: It provides a macro-view of an active OutSystems environment.
Key Features: It automatically maps and extracts the structures of your published data entities, application screens, security roles, background timers, API configurations (REST/SOAP), and physical database tables.
Outputs: Allows engineers to export Excel and PDF data sheets to maintain system compliance.
Which of these tools aligns with what you are building or researching? Let me know your primary use case (e.g., scientific research, SQL database management, or low-code infrastructure) so I can guide you to the correct installation links and alternatives! Data Dictionary Creator – Overview (O11) – OutSystems