Toad Data Modeler - Freeware

Free Database Modeling Tool

Toad Data Modeler freeware version is a database modeling and design tool that can be used for development of smaller database structures, up to 25 objects. See below a list of key features and benefits.

Visual creation of database structures

  • Entity Relationship Diagrams.
  • Database objects defined visually.
  • Automatic migration of foreign key attributes in physical model.
  • Automatic mapping of existing attributes.
  • Automatic creation of indexes to foreign keys.
  • See VIDEO

Database Modeling

Model Verification

  • Find errors in your model.
  • Navigate to problematic objects.
  • Use Quick Fixes to fix problems at once.

Model Verification

SQL Code Generation

  • Generate complex database platform specific DDL scripts.
  • Define detailed settings for SQL code generation.
  • Open generated script in associated application.
  • See VIDEO

SQL code generation

Reverse Engineering

  • Create connections to your databases.
  • Create a new model based on existing database structure.
  • Import from SQL files is supported for many database platforms.
  • See VIDEO

Reverse engineering


  • Generate reports in HTML, RTF or PDF format.
  • Use XSL Transformation to create custom reports
  • Export diagram to image file for printing purposes
  • Export metadata to excel.
  • See VIDEO
  • New: Responsive layouts in HTML reports.


Quick Search

  • Press CRTL+F to open the Quick Search form.
  • Use standard search as well as advanced techniques, including:
    • Word recognition
    • Camel case
    • Dot notation
    • Wildcards

Quick Search


  • For majority of supported platforms, synchronization features are available.
  • Compare models or model with database and generate alter scripts (change scripts).
  • Update model from database.
  • See VIDEO
  • New: Possibility to save settings & items selection.


Model Conversion

  • Convert logical model to selected physical model, e.g. Oracle or SQL Server model.
  • Convert physical model to another target platform. Create model for Oracle 12c and convert it to PostgreSQL 9.2 etc.
  • New: Possibility to run conversion again with already saved settings.

Model Conversion

Macros and Scripting

  • Use in-built macros or create your custom macros with additional functionality.
  • Modify objects in batch mode.
  • Create simple forms for input definitions.
  • Use scripting for fast JavaScript code execution.

Macros and scripting

Excel Export/Import

  • Export metadata to Microsoft Excel.
  • Do changes in Excel.
  • Import the modifications to model file.

Microsoft Excel Import and Export

Advanced Features

  • Naming Conventions - define restrictions and make sure your model doesn't contain any naming convention violations.
  • Default Values - allows you to specify how new objects will be named.
  • Gallery - for storing frequently used parts of models.
  • Support for SVN
  • Refactoring Utility
  • Schema/Owner Assignment Utility
  • Templates for stored procedures and functions
  • ToDo List and more.
  • New: Model Actions for quick execution of synchronization tasks.

Naming Conventions