A visual database design and modeling tool written in Delphi with support for SQL Server, Firebird, Oracle, PostgreSQL, MySQL, SQLite.
TMS Data Modeler is a desktop tool for designing, versioning, and maintaining database schemas through entity-relationship diagrams. It targets developers and database designers who want to model a schema visually, generate DDL scripts for multiple database systems, compare versions, and reverse-engineer existing databases.
It is also intended for TMS Aurelius developers who prefer a database-first workflow: model the schema in Data Modeler and generate the corresponding Aurelius entity-mapped classes from it.
- Entity-relationship (ER) diagram editor with a multi-diagram interface
- Design tables, fields, domains, indexes, triggers, relationships, constraints, views, procedures, generators, and other database objects
- Logical (application-level) domains
- Reverse engineering of existing databases
- DDL (SQL) script generation to create databases
- Alter-script generation to update databases between versions
- Version archiving and management; comparison between versions or projects
- Cross-database conversion
- Project validation to trace model errors
- Aurelius database-first integration: generate entity-mapped classes from a model
- Modern ribbon interface with tab-organized objects and full keyboard accessibility
A full feature description is available on the product page.
SQL Server, Firebird, Oracle, PostgreSQL, MySQL, SQLite.
The corresponding database client libraries must be installed on the machine running Data Modeler; Data Modeler does not bundle them.
Official installers are published on the Releases page of this repository.
System requirements
- Windows 10 or later (recommended)
- Standard Windows desktop hardware (no special memory or disk requirements beyond the OS baseline)
- Database client libraries for the database systems you intend to connect to
There is no separate trial build. Per the license, non-commercial use (personal learning, education, evaluation, open-source projects) does not require a paid license; commercial use does.
Full user documentation is available at doc.tmssoftware.com/biz/datamodeler.
Data Modeler is built with Delphi 13. Earlier Delphi versions are not tested and may or may not work.
The required third-party libraries are listed in tms.snapshot.yaml:
From the repository root, run:
tms restore tms.snapshot.yaml -skip-register
Smart Setup will automatically resolve all dependencies and build the project, generating the dm.exe binary.
Install all third-party dependencies listed above manually, open dm/dm.dproj in Delphi 13, and build.
TMS Data Modeler is source-available, not open source. A paid commercial license is required for business and professional use. See LICENSE.txt for full terms.
Licenses can be purchased from the product page.
All support is handled through the TMS Support Center. The Data Modeler category is at:
support.tmssoftware.com/c/business/tms-data-modeler/35
Pull requests and contributions are accepted. By submitting a contribution you agree to the terms in section 5 of LICENSE.txt, which grants TMS Software the rights needed to incorporate your contribution into the Software.
Release notes are published at doc.tmssoftware.com/biz/datamodeler/guide/release-notes.html.
Copyright © tmssoftware.com bv — tmssoftware.com