Model Xtractor

What Model Xtractor is

Model Xtractor is a Windows desktop tool for inspecting relational database models. It works with traditional or enhanced ER models, generated models, and diagrams created from scratch. Its one-time reverse engineering operation extracts information about database tables, views, columns, and relationships. The maker lists support for SQLite, Firebird, Microsoft SQL Server CE, Access, MySQL, MariaDB, PostgreSQL, SQL Server, Oracle, IBM Db2, SAP ASE, SAP SQL Anywhere, Snowflake, Redshift, Azure, and Amazon Aurora.

Users can select detailed generated views such as Detailed, Structural, and Relationships, or simplified Simple, Topological, and Graph views. They can add virtual joins, chains, aliases, and many-to-many connectors without changing the connected database. Diagrams can be saved as an image or PDF. The maker says Xtractor applications cannot modify remote database data or metadata, while model extensions are stored in a local user database. Saved database passwords are encrypted there and masked in the connection string property; by default, user data is kept in Xtractor.db in the user's AppData\\Local\\Xtractor folder. Model Xtractor is free. Forward engineering is not supported.

Who it suits

Model Xtractor suits people who need to inspect relational models across supported databases without needing to be database-modeling experts. It is a fit for Windows users who want to examine existing structures and customize diagrams without changing the connected database.

Limits

Model Xtractor is free, but it does not support forward engineering. The maker describes products other than Data Xtractor as provided as-is and without support.

Getting started

1. Visit https://data-xtractor.com/model-xtractor/.
2. Download the Windows desktop application.
3. Connect to a supported database for a one-time reverse engineering operation.
4. Choose a generated model view or create a diagram from scratch.
5. Save a diagram as an image or PDF.

Verdict

Choose Model Xtractor if you need a free Windows tool to inspect existing relational database structures and shape their diagrams. Look elsewhere if your workflow requires forward engineering or a platform other than Windows desktop.