Categories ▾
Data Modeling
Data Catalog Tools
Data Dictionary
Business Glossary
Data compare
Data democratization tools
Data discovery tools
Data Governance
Data intelligence tools
Data lineage tools
Data literacy tools
Data observability tools
Data Profiling tools
Database design
Diagram / RE
DB Documentation Generators
DB Documentation
Extended properties editors
GDPR compliance
GUI tools
Metadata Management
PL/SQL documentation
Reference Data Management tools
Schema Compare
Sensitive data discovery
SQL Lineage Tools
SQL Parsing Tools / SQL Parsers
SSAS documentation
SSIS documentation
Version Control
All categories
Databases ▾
SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
All databases

Database diagram / Reverse Engineering tools for Apache Derby

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

Jeddict

https://jeddict.github.io/

Jeddict is an open source development platform that simplifies development tasks of creating complex entity relationship models. It provides forward & reverse engineering capabilities, import models from existing database, generate complex SQL/DDL, and much more. Make it available again by importing the existing database and create new ER diagram.

Commercial: Free
Free edition: Yes
Export: Image,SQL script
Go to vendor website

SQL Power Architect

http://www.bestofbi.com/page/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
Go to vendor website

Aqua Data Studio Entity Relationship Modeler

http://www.aquafold.com/aquadatastudio/er_modeler.html

The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design physical database models for all major RDBMS vendors and versions. An ER diagram can be extracted from an existing database and its schema objects displayed as a model by using Tools->ER Diagram Generator in the Server Browser.

Commercial: Commercial
Free edition: No
Export: HTML,Image,Printer
Go to vendor website

Visual Paradigm

https://www.visual-paradigm.com

Visual Paradigm supports reverse engineering ERD from existing database. By visualizing a database schema in ERD, you can re-edit it and patch changes back to the database, or you can produce a data specification that acts as a reference for programmers who need to access the database.

Commercial: Commercial
Free edition: No
Export: EMF,Image,SVG
Go to vendor website

DataGrip

https://www.jetbrains.com/datagrip/

DataGrip is database IDE that is tailored to suit specific needs of professional SQL developers.

Commercial: Commercial
Free edition: No
Export: Image
Go to vendor website

DbSchema

http://www.dbschema.com

DbSchema is diagram designer and query tool.

Commercial: Commercial
Free edition: No
Export: HTML,PDF
Go to vendor website

DbVisualizer

https://www.dbvis.com/

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
Go to vendor website

SQuirreL SQL

http://www.squirrelsql.org/

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
Go to vendor website

Categories

Data modeling tools Data catalog tools Data dictionary tools Business Glossary tools Data compare tools Data democratization tools Data discovery tools Data Governance tools
All categories

Databases

SQL Server Oracle MySQL PostgreSQL
All databases
Want to add your tool or have a question? Contact us at contact@dbmstools.com
About us