30 Data Modeling Tools

This is the list of all database modeling and design tools for popular relational databases (Oracle, SQL Server, MySQL or PostgreSQL) we found on the web. If you found something else or see any inaccuracies, let us know and we'll fix it.

Share

erwin Data Modeler

erwin.com/products/data-modeler

erwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment.

Supports: SQL Server, Oracle, MySQL, DB2, Informix, ODBC, Progress, SAS, SAP ASE, SAP IQ, Teradata

Type: Commercial

Toad Data Modeler

www.casestudio.com

Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, Sybase ASE, SAP SQL Anywhere, SAP IQ, SQLite

Notable features: Model synchronization, generation of HTML, RTF and PDF reports, generation of alter (change) scripts

Type: Commercial

DeZign for Databases

www.datanamic.com/dezign/index.html

Database design and modeling tool

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Access, SQLite3. SAP ASE, Firebird, Interbase, NexusDB, SAP SQL Anywhere

Notable features: Forward engineering (generates complete DDL scripts), subdiagrams (subviews), compare and merge models utility, model (model-to-database and database-to-model)

Type: Commercial

Database Workbench

www.upscene.com/database_workbench/

Database Workbench offers a single development environment for developing with multiple database engines.

Supports: SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, SAP SQL Anywhere, InterBase, Firebird, NexusDB

Type: Commercial

ER/Studio

www.idera.com/er-studio-enterprise-data-modeling-and-architecture-tools

Data Modeling for Multi-Platform Environments

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Sybase, MongoDB, Hadoop + Hive, Firebird, Hadoop, Hive, Access, SAP ASE, SAP IQ, Teradata

Type: Commercial

DbSchema

www.dbschema.com/

DbSchema is diagram designer and query tool.

Supports: SQL Server, Oracle, MySQL, Amazon Redshift, Cache, Cassandra, DaffodilDB, DB2, Derby, JavaDB, Exasol, Firebird, Filemaker, FoxPro, FrontBase, HBase, H2, Hive, HyperSQL, Informix, Ingres, JDataStore, MariaDb, MongoDb, Access

Type: Commercial

DbWrench

www.dbwrench.com/

Database design and synchronization tool

Supports: SQL Server, Oracle, MySQL, PostgreSQL

Type: Commercial

ERDPlus

erdplus.com/

A database modeling tool for creating Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements.

Supports: SQL Server, Oracle, MySQL, PostgresSQL, Teradata, IBM DB2, Access

Notable features: Web application

Type: Free

DB Designer Fork

sourceforge.net/projects/dbdesigner-fork/

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design,front-end (you can run queries) and SQL exporting

Supports: SQL Server, Oracle, MySQL, Firebird, SQLite, PostgreSQL

Type: Free

Jeddict

jeddict.github.io/

Jeddict is an open source graphical tool that enhances productivity and simplifies development tasks of creating complex entity relationship models.

Supports: SQL Server, Oracle, MySQL, Sybase, PostgreSQL, Access, H2, Apache Derby

Notable features: Plugin to Netbeans

Type: Free

DatabaseSpy Graphical Database Design Tool

www.altova.com/databasespy/database-design.html

The Altova DatabaseSpy® 2017 graphical database Design Editor lets you view and edit the structures of all your databases through one graphical user interface.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Sybase, Firebird, IBM DB2, Informix, Access, Azure SQL Database, OpenEdge, SQLite

Type: Commercial

Database Deployment Manager

ddmproject.weebly.com/

Database Deployment Manager (DDM) tool is a multi-platform tool that allows database administrators and users to create database structures (tables, queries, etc...) using object oriented methodology which can be used to populate multiple databases.

Supports: MySQL, Sqlite, CUBRID

Type: Free

DTM Data Modeler

www.sqledit.com/dm/

DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering.

Supports: SQL Server, Oracle, IBM DB2, SQLite, Access, MySQL, Sybase, Interbase, Firebird

Type: Commercial

DbDesigner.net

dbdesigner.net/

DbDesigner is a web application which allows you to design your database schema without writing SQL.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SQLite

Notable features: Online designer

Type: Commercial

GenMyModel

mymodel.com

GenMyModel is modeling platform in the cloud for software architects and developers.

Notable features: Online designer

Type: Commercial

Database Designer for MySQL

www.microolap.com/products/database/mysql-designer/

Powerful MySQL-oriented database structure modeling, generation and modification.

Supports: SQL Server, Oracle, MySQL, Access, SAP, ASE, Informix, DB2, DBF

Type: Commercial

Xcase

se.com/

Xcase is a complete database design tool engineered to help you accomplish all your database-related tasks – from database design to modeling to daily modifications – with greater speed, higher quality, and better adherence to best practices.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Sybase, DB2, Firebird, Interbase, Informix, FoxPro, VFP, MaxDB, SAP SQL Anywhere

Notable features: Converting database

Type: Commercial

AnySQL Maestro

www.sqlmaestro.com/products/anysql/

AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development.

Supports: SQL Server, Oracle, MySQL, Access

Type: Commercial

Aqua Data Studio Entity Relationship Modeler

www.aquafold.com/aquadatastudio/er_modeler.html

The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design complex database models for all major RDBMS vendors and versions.

Supports: SQL Server, Oracle, MySQL, Amazon Redshift, Apache Cassandra, Apache Derby, Apache Hive, Apache Spark, DB2, Excel, JDBC, ODBC, Google BigQuery, Greenplum, Informix, MongoDB, Netezza, ParAccel, PostgreSQL, SAP HANA

Type: Commercial

MagicDraw

agic.com/products/magicdraw

MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Standard SQL, PointBase, Sybase, Pervasive, Cloudscape, Access

Type: Commercial

Software Ideas Modeler

www.softwareideas.net/

Agile CASE tool for software design & analysis

Type: Commercial

ConceptDraw PRO

www.conceptdraw.com/

The main tool of domain modeling at the stage of conceptual design is the Entity-relationship model, also called ER-model.

Supports: SQL Server, Oracle, MySQL, InterBase, Access, Firebird

Type: Commercial

Visible Analyst

www.visible.com/Products/Analyst/vadbengineer.htm

The Visible Analyst DB Engineer edition is focused on the Data Modeling and Database Engineering functionality of the popular Visible Analyst product.

Supports: SQL Server, Oracle, MySQL, Access, ANSI SQL-92, Centura SQLBase, DB2, DBASE IV SQL, Datacom SQL, Informix SQL, Ingres SQL, Netware SQL, Paradox, Progress, Rdb SQL, Server System, Teradata,, Unify SQL, Watcom, SAP SQL Anywhere, XDB SQL

Type: Commercial

Anchor Modeling

www.anchormodeling.com/

Anchor Modeling is an Open Source database modeling technique built on the premise that the environment surrounding a data warehouse is in constant change.

Supports: SQL Server, Oracle, PostgreSQL, Vertica

Notable features: online

Type: Free

RISE

www.risetobloome.com/Page_1_S.aspx?ITEM=1853

RISE is a software suite for model driven information system development.

Supports: SQL Server, MySQL, PostgreSQL

Type: Commercial

ERDesigner NG

mogwai.sourceforge.net/erdesignerng.html

The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, H2, HyperSQL

Type: Free

Oracle JDeveloper

www.oracle.com/technetwork/developer-tools/jdev/overview/index.html

Oracle JDeveloper is a free integrated development environment that simplifies the development of Java-based applications addressing every step of the application lifecycle.

Supports: Oracle

Type: Free

pgModeler

www.pgmodeler.com.br/

pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements.

Supports: PostrgreSQL

Type: Free

Valentina Studio

www.valentina-db.com/

Valentina Studio is your universal database management tool.

Supports: SQL Server, MySQL, MariaDB, PostgreSQL, SQLite, Valentina DB

Type: Commercial

Last research made on 16 September 2016

Share