SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
GUI tools for MS Access
Graphical user interface (GUI) tools consist of an interface that includes visual components such as buttons or icons, through which the user interacts with electronic devices. The biggest advantage of graphical user interface is an improvement in usability for the average person. It gives the ability to perform various tasks on an electronic device, without any programming knowledge.
Dataedo
Dataedo lets you visualize your data models with ER diagrams. You can discover and document relationships between data entities and visualize them with automatically built diagrams. It reads foreign key constraints from DBMS and adds table relationships to the diagram automatically.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
ERDPlus
ERDPlus is a web-based database modeling tool that lets you quickly and easily create Entity Relationship Diagrams (ERDs), Relational Schemas (Relational Diagrams), and Star Schemas (Dimensional Models). It enables drawing standard ERD components. The notation supports drawing regular and weak entities, various types of attributes, and all possible cardinality constraints of relationships.
| Desktop/Cloud: | Cloud |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Free |
| Forward engineering: |
|
| Reverse enginering: |
|
DeZign for Databases
DeZign for Databases is an intuitive data modeling tool Visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular databases.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
RazorSQL
RazorSQL is a software application that provides both easy to use visual tools and advanced features to allow users to do database browsing, editing, management, administration, and programming.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
DbSchema
DbSchema is a universal database designer and GUI tool that provides a diagram-oriented database designer for relational and No-SQL databases. Using DbSchema, you will interact with the database using the mouse. Even if you are not an SQL expert, you will be able to create new tables, columns, or foreign keys, explore the data from multiple tables, create reports or generate test data.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
Toad Data Modeler
Toad Data Modeler is an easy-to-use, multi-platform data modeler. It lets you visualize database structures and better understand existing databases and relationships. Create high-quality logical and physical data models. Reverse engineer existing database structures to view them in a diagram. Generate detailed HTML, RTF or PDF reports.
| Desktop/Cloud: | Cloud |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
ConceptDraw DIAGRAM
ConceptDraw DIAGRAM is a very easy-to-use and intuitive database design tool for database modeling, drawing database structure, and diagramming databases. The enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, while flexible datatype mapping allows you to add and remove Target DBMS data types, including data type modifiers, and create auto-increment data types.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
DatabaseSpy
Altova DatabaseSpy is the unique multi-database query and design tool. The DatabaseSpy graphical Design Editor lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database, edit tables to better suit your needs, or even can add entire tables and specify all their column attributes and relationships to other tables from scratch.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
Enterprise Architect
Enterprise Architect is a visual modeling and design tool based on the OMG UML. As a multi-user graphical tool, it is designed to help enterprises built logical and physical data models. It helps individuals, groups, and large organizations to model and manage complex information effectively.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
ModelSphere
Open ModelSphere is a powerful tool for business process, data, and UML modeling. It is a complete data modeling tool, that covers conceptual and logical data modeling as well as physical design, i.e., database modeling (database modeling). It supports several notations, e.g., Entity-Relationship, DATARUN, and Information Engineering. Conceptual models can be converted to relational models and vice versa.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Free |
| Forward engineering: |
|
| Reverse enginering: |
|
dModelAid
dModelAid is the perfect modeling tool for documenting a complex database design in a simple, interactive diagram. You can clearly visualize model objects supporting EER and three data modeling phases. In addition, you can quickly find any object or properties with the search function
| Desktop/Cloud: | Cloud |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
Model Xtractor
Model Xtractor is a software utility designed to inspect modeling for traditional or enhanced ER models, with support for most relational database platforms. It lets you hide, collapse, or minify table/view shapes. Bypass intersection tables and show conceptual many-to-many connectors between shapes.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
The key feature of GUI tools is to present system resources, in graphical objects, that are easy to find, understand and use. Through these elements users have an easy access to interact with and manipulate available functions. They allow us to speed up the most frequent tasks in the easiest and most accessible way.
We prepared simple data modeling tools as well as more advanced GUI tools for visually designing and managing databases.