GUI tools for MariaDB

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: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes
Dataedo Data Lineage
Dataedo Business Glossary
Dataedo ERD

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: No
Schema design: No
Commercial: Commercial
Forward engineering: No
Reverse enginering: No

dbForge Studio

dbForge Studio offers powerful GUI tools for relational databases. It lets you visually design new databases and analyze the structure of existing ones, track logical relations between tables, export database diagrams to images, edit table data, rebuild tables, configure database options, and more.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

QuickDBD

Quick Database Diagrams (QuickDBD) is a simple online tool to quickly draw database diagrams by typing. It develops premium diagrams and let you share your diagrams online.

Desktop/Cloud: Cloud
Free edition: Yes
Schema design: Yes
Commercial: Free
Forward engineering: No
Reverse enginering: Yes

phpMyAdmin

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the web with its intuitive web interface. It lets you create graphics of your database layout in various formats

Desktop/Cloud: Cloud
Free edition: Yes
Schema design: Yes
Commercial: Free
Forward engineering: Yes
Reverse enginering: Yes

Navicat Data Modeler

Navicat Data Modeler lets you create, modify, and design your models using professional object designers, available for Tables and Views. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

Valentina Studio

Valentina Studio is a visual data modeling and database management tool that lets you manage multiple databases in tabs and dockable views, create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views, Stored Procedures, Properties, Sequences, Types, and do plenty of other activities.

Desktop/Cloud: Desktop
Free edition: Yes
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

DataGrip

DataGrip is a database IDE that is tailored to suit the specific needs of professional SQL developers. It offers database diagram support that lets you graphically show the structure of the database and relations between database objects. You can generate a diagram for a data source, a schema, or a table.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes

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: No
Schema design: No
Commercial: Commercial
Forward engineering: No
Reverse enginering: No

SQLyog

SQLyog enables database developers, administrators, and architects to visually compare, optimize, and document schemas. The Schema Designer (introduced in SQLyog version 6.1) offers a visual interface where tables and table structures can be defined, displayed, and manipulated.

Desktop/Cloud: Desktop
Free edition: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: No

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: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes

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: No
Schema design: Yes
Commercial: Commercial
Forward engineering: Yes
Reverse enginering: Yes

Adminer

Adminer is a PHP written full-featured database management tool. It provides an enhanced user interface, higher performance, more security, and more feature sets. You can create, alter, drop, and search tables, foreign keys, columns, triggers, etc. You can list data in tables with search, aggregate, sort and limit results.

Desktop/Cloud: Desktop
Free edition: Yes
Schema design: Yes
Commercial: Free
Forward engineering: Yes
Reverse enginering: Yes

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: No
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes

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: Yes
Schema design: Yes
Commercial: Commercial
Forward engineering: No
Reverse enginering: Yes


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.