Model Xtractor

Model Xtractor is a tool for inspecting relational database modeling. It can be employed for traditional or enhanced ER models, generated diagrams from scratch or clones, and simplified or rich. You can reverse engineer to extract information about database tables, views, columns, and relationships.

The application is quick to install and requires little input from you during that process. The interface is elegant and organized appropriately. There are no hardware requirements to speak of, yet you will need credentials to connect to databases. This implies host name, port, authentication details (such as username and password), and connection / query timeout.

Model Xtractor offers support for major database platforms, such as Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird with automatic or manual layouts.

You can employ this software to one-way reverse engineer relational databases. Custom joins, chain relationships, and name aliases can be executed without changing anything on the actual server. You can detect and expand relationships into connectors by dragging and dropping.

The application can automatically generate detailed, structural, relationship, simple, graph or topological models. Diagram options are available but limited. You can also save the models as image or PDF.

All views can be enhanced to increase focus on certain areas. You can display icons, object, data and short types, contrast or monochrome the background, and add notes to relevant areas.

Model Xtractor is a visual data modeling inspection tool that provides support for most popular databases. Despite being limited to only viewing data, you can employ this software to juggle with chains, joins, relationships, and aliases. It is free to use in any environment and can become a starting point for learning database basics.