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 Amazon Redshift
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: |
|
Retool
Retool gives you a multi-purpose, cross-platform SQL GUI so you can quickly build apps on top of your data. Connecting Retool to your SQL DB lets you run queries, inspect your schema and database objects, and auto-complete in our IDE. Manage, manipulate, and visualize your data with custom components instead of getting stuck in a CLI.
| Desktop/Cloud: | Cloud |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
Aqua Data Studio Entity Relationship Modeler
The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design physical database models for all major RDBMS vendors and versions. It uses the forward engineer feature to model entities and the reverse engineer feature to visualize a database model from existing databases. Besides that, the schema compare tool functionality within the ER Modeler allows comparing ER models.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
TablePlus
TablePlus is a modern, native, and friendly GUI tool for relational databases. With the native build, simple design, and powerful features, TablePlus makes database management easier, faster & more efficient for you. You can browse, query, edit your data and database structure in a simple and clean spreadsheet-like editor.
| Desktop/Cloud: | Desktop |
|---|---|
| Free edition: |
|
| Schema design: |
|
| Commercial: | Commercial |
| Forward engineering: |
|
| Reverse enginering: |
|
SqlDBM
SqlDBM is a browser-based online database design tool does not require writing a single line of code to develop a database. By bringing your existing DB/DW to SqlDBM, you can automatically create a database model that will provide powerful and effective visualization. Make changes and generate new SQL scripts including Alter scripts.
| Desktop/Cloud: | Cloud |
|---|---|
| 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: |
|
DbVisualizer
DbVisualizer is a smart and powerful database tool aimed to simplify database development and management for database administrators and developers. It lets you create and manage the database visually. Generate SQL code by drag & drop and copy & paste it into other applications.
| Desktop/Cloud: | Desktop |
|---|---|
| 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.