Database diagram / Reverse Engineering tools for Oracle

List of database ER diagram (ERD) / schema visualization / reverse engineering tools .

SQL Power Architect

SQL Power Architect data modeling tool has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases and auto-generate ETL metadata.

Commercial: Commercial
Free edition: Yes
Export: PDF

ERD Concepts

ERD Concepts is an ERD tool combining professional diagramming with a light and pleasant user-interface. With ERD Concepts you can connect to almost any available database on the market today using ODBC and ADO connections. Using the advanced reverse engineering software you can create a new ERD diagram from an existing database.

Commercial: Free
Free edition: Yes
Export: HTML,Printer

SQuirreL SQL

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands, etc.

Commercial: Free
Free edition: Yes
Export: CSV,Image,Printer

WWW SQL Designer

WWW SQL Designer allows you to draw and create database schemas (ER diagrams) directly in the browser, without the need for any external programs. It also has the ability to import existing database design.

Commercial: Free
Free edition: Yes
Export: SQL script

MagicDraw

MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. It includes entity-relationship diagram, SQL database modeling/diagramming and DDL script generation/reverse features.

Commercial: Commercial
Free edition: No
Export: CSV,HTML,MS Excel,PDF

IBM InfoSphere Data Architect

IBM® InfoSphere® Data Architect is a collaborative enterprise data modeling and design solution. It enables to create a physical data model using reverse engineering feature.

Commercial: Commercial
Free edition: No
Export: -

dbConstructor

dbConstructor is a database design tool that speeds up and eases the database creation and maintenance process by means of an extremely user-friendly interface. It also lets you do reverse engineering, change management, schema verification, and many more.

Commercial: Commercial
Free edition: Yes
Export: Image,SQL script

Modelio

Modelio SQL Designer Module provides strong support for database modeling, from logical UML class models to relational databases. It provides reverse engineering from SQL code to SQL table diagrams.

Commercial: Commercial
Free edition: Yes
Export: -

SQL Manager

SQL Manager in a simple and direct way provides reverse engineering operation by building a relationship diagram on the basis of the current database's structure. The objects are arranged automatically within the diagram model.

Commercial: Commercial
Free edition: Yes
Export: HTML,Image,MS Excel,PDF,RTF

DbVisualizer

DbVisualizer is a simple tool to generate ER diagram if you have existing database on system. It is aimed to simplify database development and management for database administrators and developers.

Commercial: Commercial
Free edition: Yes
Export: CSV,HTML,SQL script

WinA&D

WinA&D is a comprehensive tool for system analysis, requirements management, structured analysis and design, object-oriented modeling with UML, and data modeling of information systems.

Commercial: Commercial
Free edition: Yes
Export: PDF

NODATA

NODATA gives you the ability to design your physical and conceptual data models through entity-relationship notation. It allows you to represent your objects and to define relationships between them, so you can precisely define your objects structures and relationship for documentation or actual generation purposes.

Commercial: Commercial
Free edition: No
Export: CSV

RISE

RISE is a software suite for model driven information system development, packed with features and functions needed to build your information model and to turn it into a complete information management solution. You can generate your entire information solution including database, web services, and documentation.

Commercial: Commercial
Free edition: Yes
Export: -

Apricot DB

Allows to perform the Reverse Engineering of all supported databases

Commercial: Free
Free edition: Yes
Export: MS Excel,PDF,PNG

Linkifier

Linkifier is a Java-based tool for sniffing of primary and foreign key constraints, even if they are not explicitly defined in the database. The identified constraints can be visualized with ER-diagram or exported as SQL alter queries.

Commercial: Free
Free edition: Yes
Export: MS Excel,Plain text