pgModeler!

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and much more. MySQL Workbench is available on Windows, Linux and Mac OS.

pgAdmin is the most popular and feature rich open source administration and development platform for PostgreSQL, the most advanced open source database in the world. The application may be used on Linux, FreeBSD, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial and derived versions of PostgreSQL such as Postgres Plus Advanced Server and Greenplum database.

dbForge Studio for MySQL is the universal MySQL and MariaDB front-end client for database management, administration and development. Devart's MySQL GUI tool provides utilities to compare, synchronize, and backup MySQL databases with scheduling, and gives possibility to analyze and report MySQL tables data. dbForge Studio for MySQL now works with any MariaDB database servers, and supports all MariaDB objects types. Everyone can visually design database structures, execute SQL queries and scripts, and manage MariaDB users and privileges. »

Online tool for visual database design. This one web application support seven major database engines: PostgreSQL, MySQL, Microsoft SQL Server, SQLite, Oracle 11g, IBM DB2 and HSQLDB.Vertabelo allows you to create your database model simply by graphically drawing tables and references. The application validates your model all the time and gives you hints on how to improve it. At any moment you can see a preview of the SQL that will be generated for a selected element.You can share your database models at three different access levels: Owner, Editor and Viewer. Furthermore, everyone who shares a model may open it at the same time. When the model is opened for editing for one person, it is read-only for others. Everyone can see changes in the model just after an autosave.If you need to share a model with your customers or partners and they don't want to create accounts in Vertabelo, you can generate the public link to your model and send it via e-mail.Reverse engineering tool allows you to import an existing database structure and build a model of it. This way you can visualize the data structure of your database and work on it.If you develop web applications, Vertabelo delivers you built-in support for some popular ORMs like Propel (for PHP developers), SQLAlchemy (for Python developers) and JOOQ (for Java developers).The application works completely online and no installation is needed. Just register an account, log in and you can start working on your model from any place in the world connected to internet. Vertabelo offers a free plan which is limited by a certain number of models available to create and the number of tables per one model. For larger projects and companies there are different paid plans. Notice that Vertabelo is totally free for students, lecturers, open source projects and non-profit organizations, provided that it will be used only for educational or non-commercial purposes. »

Skipper, previously ORM Designer, is a visualization tool and a code generator for favourite ORM frameworks (Doctrine ORM, Doctrine2 ORM, Propel ORM and CakePHP). Application allows to edit ORM models in graphical interface and then export them directly to standardized and ready-to-use schema definition files. With Skipper, you can focus only on project logic, as syntax and keywords are taken care of by Skipper. With possibility to import existing projects and possibility of continuous exports, work on creating, extending and maintaining ORM definitions is up to four time faster. Main advantages of using Skipper in your workflow are: - Development in visual environment is efficient, fast and comfortable. - Documentation is always kept up-to-date and in accordance with code. - Typos and semantic errors are completely eliminated. - Older projects can be imported quickly and orientation in them is easier. Above advantages are further enhanced by wide possibilities of customization, built-in wizards and user-friendly interface. »

The SQL Power Architect data modeling tool was created by data warehouse designers and 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.

Database design and modeling tool - DeZign for Databases. Features: visual database design, data modeling ER Diagrams (ERD), Reverse Engineering, database creation, sql script generation.

The MicroOLAP Database Designer for PostgreSQL is an comprehensive CASE tool with intuitive graphical interface allowing you to

Simple to use PostgreSQL GUI client

Aqua Data Studio is a complete Integrated Development Environment (IDE) for database developers. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3) a complete and integrated source control client for Subversion (SVN) and CVS; and 4) a database modeler as powerful as the best standalone database diagramming tools.

This software is for all developers, database designers and for all who want to create and maintain their database structures effectively. Key features include: Entity relationship diagrams - Physical, Logical and Universal models. Support for various databases(Oracle, Microsoft SQL Server, MySQL, PostgreSQL, DB2...)Generation of SQL (DDL) scripts Reverse engineering Generation of Alter Scripts Model Update and Model Merge Gallery for storing frequently used parts of model Refactoring Utility Generation of detailed HTML and RTF documentationConversion from Logical to Physical modelSupport for UnicodeUNDO / REDOModeless dialogs, user-friendly GUI Editable forms, scriptable objects...Entity relationship diagrams - ER diagrams Using the graphically very well arranged Entity Relationship Diagrams (ER Diagrams) you can easily create and maintain your database structures. In your models you will have all the entities, attributes, domains, primary keys, foreign keys, constraints, relationships, indexes, descriptions, notes and other physical and logical data, laid-out in a transparent order. While creating models you will have a perfect view of all database elements. Triggers, Procedures, Views.... Toad™ Data Modeler supports Functions, Procedures, Triggers, Views, Packages, Package bodies, Object types, Object type bodies, Sequences and Synonyms etc.. »

erwin Data Modeler provides a collaborative environment to manage enterprise data though an intuitive, graphical interface. With a centralized view of key data definitions, you can leverage information as a strategic asset and more efficiently manage your data resources to save time and money.

SAP PowerDesigner: Enterprise Architecture tools for digital transformation successPlan and manage complex business transformation initiatives with SAP PowerDesigner. The software’s data modeling tools let you build a blueprint of your current enterprise architecture and visualize the impact of change before it happens. Automatically capture architecture layers and requirements, tap into a powerful metadata repository, and share discoveries with your team.

Powerful software development environment

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. The unique thing about OSA is that it is an Open Source product licensed under the General Public License (GPL). The free factor makes OSA particularly interesting for students but OSA is powerful enough to compare favourably with products costing thousands of dollars.