Projects

SchemaSpy

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc.) and can identify Ruby on Rails as well as other implied relationships.

Database Modeller

Simple tool for drawing entity-relational (database schema) diagrams using Crow's Foot or Visio's Relational notation.

SchemaCrawler

SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects. SchemaCrawler is also a database schema discovery and comprehension, and schema documentation tool. You can search for database schema objects using regular ... [More] expressions, and output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java. [Less]

Open System Architect

Open System Architect (OSA) is an application used for modelling a system. OSA currently supports data modelling (physical and logical) with UML in the works.

GNU Ferret

Free Entity Relationship and Reverse Engineering Tool

Mogwai ERDesignerNG

Mogwai ERDesignerNG is a Java based 2D & 3D Entity Relationship design & modeling (ERD) tool for Oracle, MSSQL, Postgres and MySQL. It includes database change and dictionary management, SQL generation, reverse and forward engineering plus reports and data browsing.

metarun

those script work with ER Studio

nberd

Plugin for ER Diagramming for NetBeans

erdesigner

This project allows you to draw ERD using Chen's Notations. You also can generate your drawn ERD to SQL Script. It's support MSSQL (T-SQL), Oracle (PL/SQL), MS Access, MySQL...

codemaker

CodeMaker is a modeling tool that allows desingers to create graphically ERD diagrams. It may look just like any other designing tool, but it has an extra feature: it uses code generators to generate source code from the database model. Code Generators are plugins that can be dynamically loaded ... [More] , so basically there are no limits for them: they can be used to generate java code, php code, sql code, etc. You can develope Code Generators yourself, and that way extend CodeMaker capabilities. CodeMaker will shorten your developing times, and you will end up with a consistent api for database access, that you can fix/improve with just a mouse click. CodeMaker is a tool created by software developers and oriented to software developers. [Less]