tmssoftware

tmssoftware / datamodeler

Public

A visual database design and modeling tool written Delphi with support for SQL Server, Firebird, Oracle, PostgreSQL, MySQL, SQLite, and more.

10
1
89% credibility
Found May 19, 2026 at 16 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Pascal
AI Summary

TMS Data Modeler is a professional desktop application for visually designing and modeling database structures. It allows users to create entity-relationship diagrams by drawing tables, fields, and connections on a canvas, then automatically generates the corresponding SQL code for various database systems including SQL Server, Oracle, PostgreSQL, MySQL, Firebird, and SQLite. The tool can also reverse-engineer existing databases by connecting to them and drawing out their current structure. Users can validate their designs for errors, compare different versions of their database, and generate code compatible with the TMS Aurelius ORM framework. The application features a modern ribbon interface and is designed for developers and database designers who prefer a visual approach to database development.

How It Works

1
💡 You discover a better way to design databases

You've been trying to plan your database structure using spreadsheets or writing SQL by hand, and it feels frustrating.

2
📥 You download and install the tool

You grab the installer from the official releases page and install it on your Windows computer, just like any other program.

3
🎨 You start a fresh design and draw your tables

You create a new project and use the visual editor to draw your tables, adding fields, setting their types, and organizing them on the canvas.

4
🔗 You connect your tables with relationships

You draw lines between tables to show how they relate to each other, and the tool automatically understands the connections.

5
You get exactly what you need
📄
Generate SQL scripts

Click a button and get complete SQL code ready to run on your database system of choice.

🔄
Import existing database

Connect to a database you already have and it draws out the structure for you automatically.

📦
Create code for your project

Generate ready-to-use code classes that work with your ORM framework.

6
✅ You validate and save your work

The tool checks your design for any issues and helps you fix them before they become problems.

🎉 Your database design is complete and ready

You have a professional, visual database blueprint that you can share, version, and use to build your applications.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 16 to 10 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is datamodeler?

TMS Data Modeler is a Windows desktop tool for visually designing database schemas through entity-relationship diagrams. Built in Delphi, it lets you model tables, relationships, indexes, triggers, and other database objects by drawing them out rather than writing SQL by hand. You can reverse-engineer existing databases, generate DDL scripts for multiple database systems, and maintain version history of your schemas. It also integrates with TMS Aurelius, an ORM framework, so you can generate entity classes directly from your visual model.

Why is it gaining traction?

The main draw is the visual-first workflow. Instead of toggling between a schema editor and a diagram view, everything happens in one place. The multi-diagram interface lets you organize large schemas into logical groups. Cross-database conversion is useful if you ever need to migrate between systems like PostgreSQL and SQL Server. The alter-script generation means you can track schema changes over time and apply them incrementally. For Aurelius users, the model-to-code generation removes a tedious manual step.

Who should use this?

Delphi developers working with TMS Aurelius will get the most value, since the tool is designed around that workflow. Database administrators who prefer visual modeling over raw SQL will find the interface familiar. Teams that need to document schema evolution will appreciate the version comparison and archiving features. However, if you are not on Windows or you do not use Delphi, this is not a practical choice.

Verdict

This is a niche tool with a specific audience. The credibility score of 0.8999999761581421% reflects the low star count and limited community visibility, but TMS Software is an established commercial vendor with proper documentation and support channels. The source-available license lets you examine the code before committing. If you fit the Aurelius or Delphi ecosystem, it is worth evaluating the free non-commercial tier. For everyone else, mainstream options like dbdiagram.io or DBeaver offer broader platform support and larger communities.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.