Database design tools for Apache Derby

List of tools that allow for the design of a database.

Database design is a set of activities aimed at improving the development, implementation, and maintenance of an enterprise data management system. Its main goal is to reflect the outline of the database system into real models: physical and logical. Database designers determine what data is to be stored inside the database, and how objects are to be related to each other.

Jeddict

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.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: Yes
ER Diagram: Yes

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.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: Yes
ER Diagram: Yes

X-TEA Modeler

X-TEA Modeler helps you write models and plans of enterprise systems. Its editor helps you to write specifications of tables, functions, and also to create/alter tables in your database.

Desktop/Cloud: Desktop
Generate DDL scripts: No
Free edition: Yes
ER Diagram: Yes

Gleek.io

Gleek.io diagram maker is freemium text-to-diagram tool for developers and software architects. It enables the visual design of database online, in the cloud and from any browser. Create informal, UML, or entity-relationship diagrams - using just your keyboard.

Desktop/Cloud: Cloud
Generate DDL scripts: No
Free edition: Yes
ER Diagram: Yes

Aqua Data Studio Entity Relationship Modeler

Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps in designing database models and uses the Forward Engineer feature to model entities and convert them into SQL Scripts, or Reverse Engineer existing databases to visualize a database model.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes

Visual Paradigm

Visual Paradigm provides a tool to create and communicate visual database design with professional ERD tool.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes

RazorSQL

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool. It provides visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: No

DbSchema

DbSchema is a intuitive designer for complex databases, visual interaction and documentation.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes

DbVisualizer

DbVisualizer is the universal database tool for developers, DBAs, and analysts. It is aimed to simplify database development and management. It provides tree-based navigation through database objects and let multiple objects to be displayed side-by-side.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: Yes
ER Diagram: Yes

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.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: Yes
ER Diagram: Yes

The database design process can be very complicated. The more complex the system, the more sophisticated the tool is needed. Their functionality can vary greatly, however, core features include:
• creating and editing database objects,
• database architecture modeling,
• visualization of a database schema,
• tracking relationships between entities,
• grouping logically related objects into clusters,
• diagrams overview.

Database designer tools enable building graphical models and generating DDL scripts on their basis. The script describes data and relations between entities in the designed database. Furthermore, the tools enable reverse engineering (visualization of the model from the SQL script).

Key factors of creating a reliable and well-organized database are:
• a properly designed data structure,
• establishing what data should be stored in particular objects,
• how objects should be related to each other.

All of them can be improved by using the relevant Database design tool. Additionally, some of them allow the visual representation of data using ERD, makes it easier to visualize even more complex schemas.

Without proper software, development is based on raw code. This increases the risk of errors at the initial stage. The tools allow users to edit the visual layout using simple drag-and-drop functions. With a user-friendly interface, browsing the structure is possible even for non-IT people.

We have created a list of tools that support the process of creating database structure and its content. Our list includes free database design tools as well as advanced, more professional data management tools.