Generic relational database modeling inspection tool. For traditional or enhanced ER models, generated models or diagrams created from scratch, cloned and further customized, rich or simplified.

Download Free Model Xtractor


Model Xtractor Features Summary

FeatureDescription
Entity-Relationship Modelscustomize new or extracted ER database models, in traditional Foot Crow's or IDEF1X notation
Enhanced Data Modelsexplore and customize ER models enhanced with new features and notations (see below)
Rich Data Modelscollapsed and minimized shapes, expandable relationship items, many-to-many relationships and plenty of other original features you'll find nowhere else
Simplified Data Modelssimple topologies or graphs, for large numbers of database tables
Expandable Relationship Itemsrelationships are distributed as items on each of the participating shapes; drag them out to simply display as connectors
Custom Joinsvirtual relationships between tables, without actually changing the database
Custom Chainsbypass two or more chained relationships with one single virtual join
Custom Aliasesprovide your own alternative aliases for any table and column name, without changing the database at all
Many-to-Many Relationshipshide intersection tables and show virtual many-to-many connectors between the other shapes

Traditional Entity-Relationship Models

model-traditional-10

One-time reverse engineer, to extract information about database tables, views, columns and relationships. Generic support for dozens of relational database platforms, including Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird. Automatic or manual layout.


Enhanced Data Models

model-enhanced-10

Hide, collapse or minify table/view shapes. Bypass intersection tables and show conceptual many-to-many connectors between shapes. Capture one-to-zero/one relationships. Replace physical data types with short conceptual types (numeric, string, datetime).


Rich Data Models

relationships-model

Customize a large number of rich generated models, such as the Detailed, Structural, or Relationships model here. Save diagram as image or PDF. Highlight shape titles and item names. Combine the reduced but powerful set of diagram options, to generate all sorts of effects.


Simplified Data Models

model-graph-11

Customize a large number of simplified generated models, such as the Simple, Topological, or Graph model here. Shapes have been collapsed and rendered transparent. Connectors are straight lines and show no other details. These diagram types outline the degree of connectivity between tables, through relationships.


Expandable Relationship Items

expanded-relationships

Expand relationships into connectors with simple drag and drop of generated relationship items. Collapse connectors back by simply removing them from the diagram. Move the mouse over connectors, shapes and items, to highlight all related elements.


Custom Joins

model-custom-join-10

Easily enhance your model with custom joins, without actually changing the connected database at all! Drag one table column over another to start creating a custom join. Enhance it by dragging another table column over another. Visualize and customize your linked columns.


Custom Chains

model-chain-relationship-10

Built-in chains are automatically created for any many-to-many relationship, bypassing the intersection table. Easily create custom chain relationships, without actually changing the connected database at all! Create the chain from two or more selected connectors. A new derived chain relationship appears here between Customers and Suppliers, to give you all suppliers who delivered the orders for each customer. Relationship Properties shows how individual join conditions of selected connectors propagated to define the new chain.


Custom Aliases

model-aliases-14

Provide your own table and column aliases, and relationship names. Alter your diagram views without actually changing the connected database at all! Instant propagation to all your objects, model diagrams and queries.

ImportantData Xtractor includes all the functionality of Model Xtractor, but you can also type, design and run SQL queries, and push their results into regular or inline charts.

As a combination of Visual, Query and Model Xtractor, in Data Xtractor you may also browse data, and add data visualization graphs.

Download Data Xtractor