Design. Compare. Generate.

A modern database modeling tool for serious ORM workflows. Model first. Version-controlled.

Generate ORM model

Thanks to our generators system, OrmFactory can support an unlimited number of combinations of languages, styles, approaches, ORMs and databases. The key feature is that you can write your own generator tailored to your processes, workflows, and preferences.

See working examples: Entity Framework, Hibernate.

Model-first sync with any environment

The model-first approach allows you to work with the model independently of any specific environment. OrmFactory enables you to synchronize the model with each environment separately, giving you full control over the changes you want to apply.

Generate ORM migrations

Migration generators combine both features. This is a must have feature if you use migrations and work in different environments.

Generate migrations based on model changes. See exactly what changed - and generate ORM-specific migration code using your custom generator.

Migration generators are available for Yii2 and Laravel. You can create your own for any combination of ORM and database.

Git-friendly model storage

Our XML-based model storage format allows you to easily merge changes via version control systems and even manually edit the model when necessary. Each developer works with their own local DBMS, and after merging changes, all updates are easily transferred to testing and production environments.

Like any good editor, OrmFactory can undo any actions with the model. But we still recommend git.

ER diagrams for your project

OrmFactory is also a visual designer for your data schema. You can create a visual representation of your table relationships using both foreign keys and virtual foreign keys.

Can handle hundreds of tables without lags.

Diagrams can be exported into PNG format.

Minimalist UI, maximum focus

OrmFactory features a deliberately simple interface.
Don't be fooled - it's a powerful and sophisticated tool.
The interface fully supports high-resolution screens without any quality loss.
The gray color scheme is designed to reduce cognitive load, making your daily work easier and more comfortable.

Built-in data editor with smart query tools

You can view and edit data directly within OrmFactory. The query window includes autocomplete based on your model, making it easier to write complex queries. The foreign key tooltip feature allows you to quickly inspect referenced objects without adding joins to your queries.

Another data management features:

• A fast data grid capable of smoothly scrolling through millions of rows.
• Low memory consumption. Optimized to handle millions of rows with minimal RAM usage.
• A multiline editor with XML and JSON syntax highlighting.
• Prettify-on-the-fly feature for minified JSON.

Multi-Database support

Use multiple databases in a single model is ideal for microservices, legacy integrations, or gradual migration.

Supported databases:

• MySQL (including MariaDB and Percona).
• PostgreSQL.
• Oracle (experimental).
• Sql Server (experimental).