tmssoftware/datamodeler

TMS Data Modeler is a Windows desktop tool for designing the structure of databases through visual diagrams. You draw the tables and the relationships between them, and the tool can then generate SQL scripts that build that database on your server of choice. The README lists support for SQL Server, Firebird, Oracle, PostgreSQL, MySQL, and SQLite. The tool is written in Delphi and the source code in this repository is written in Pascal. The main use cases are creating a new schema as an entity relationship diagram, generating DDL scripts to build the database on a target system, generating alter scripts that move an existing database between model versions, reverse engineering an existing database into a diagram, comparing project versions, validating a model for errors, and converting between database systems. The diagram editor supports tables, fields, domains, indexes, triggers, relationships, constraints, views, procedures, generators, and logical application level domains. There is also a feature called database first integration for TMS Aurelius, which generates entity mapped Delphi classes from the same model. The project is delivered as Windows installers from the Releases page of the repository. It runs on Windows 10 or later. The README notes that the database client libraries for whichever systems you want to connect to are not bundled, so you install them separately. There is no separate trial build, and the license terms allow free use for personal learning, education, evaluation, and open source projects, but commercial use requires a paid license. If you want to build the source yourself you need Delphi 13, since earlier Delphi versions are untested. The third party libraries are listed in a snapshot file at the repo root and include JAM Software Virtual TreeView, TMS Aurelius, TMS Scripter, TMS Diagram Studio, and the TMS VCL UI Pack. The recommended path is to run tms restore tms snapshot yaml with the skip register flag from the repository root, which uses TMS Smart Setup to pull every dependency and produce the final dm exe. A manual path is also documented: install each dependency yourself, open dm slash dm dproj in Delphi 13, and build. The license is described as source available rather than open source. Pull requests are accepted, but contributors agree that TMS Software gets the rights it needs to ship the contribution. Support runs through the TMS Support Center, and release notes live on the TMS documentation site.