Hackolade Studio is an intuitive yet powerful application to perform the visually data modeling and schema design of many SQL and NoSQL databases, APIS, and storage formats. Hackolade Studio combines the graphical representation of collections in an Entity Relationship Diagram, with the graphical representation of the JSON Schema definition of each collection in a hierarchical schema view. Together, these graphical representations provide the schema model for data-at-rest and data-in-motion, plus the documentation of that model. The application is specifically designed around the powerful nature of JSON nested sub-objects and denormalization. The software facilitates the work of, and the dialog between analysts, architects, designers, developers, testers, DBAs, and operators of systems that are based on such technologies. It also can generate schema scripts and documentation in a variety of machine-readable formats (DDLs, JSON Schema, Avro, Parquet, Protobuf, ...) as well as database instances, or human-readable formats such as HTML, Markdown, and PDF reports. Instead of having to find data structures tacitly described in the application code, the creation of a database model helps to evaluate design options beforehand, think through the implications of different alternatives, and recognize potential hurdles before committing sizable amounts of development effort. A database model helps plan ahead, in order to minimize later rework. In the end, the modeling process accelerates development, increases quality of the application, and reduces execution risks.
What's new in 8.13.6
Tech refresh: ElectronJS v44.9.3 (Chromium v152.0.7977.167, NodeJS v24.22.0, V8 v15.2.124.43), and related modules
External references: adjusted the Reference external definition dialog so that selecting an entity and selecting its attributes are mutually exclusive
Polyglot: added option to include technical names when converting a model to Polyglot -- see more details at https://hackolade.com/help/HandlingwhenconvertingtoaPolyglo.html
MEGA: added reverse-engineering of MEGA HOPEX logical models from .xmg exchange files into Polyglot models, from the GUI and the Command-Line Interface -- more features in upcoming releases
PowerDesigner: added preservation of relationship cardinalities when reverse-engineering a CDM or LDM where the parent entity is a shortcut
PowerDesigner: added reverse-engineering of free symbols (rectangles, ellipses, titles, text and notes) from CDM and LDM files
PowerDesigner: added detection of files saved in binary format, with a clear warning before reverse-engineering
PowerDesigner: added reverse-engineering of comments on primary and unique keys for Snowflake
Snowflake: added support for comments on primary and unique keys