Adminer is a database administration web interface. It is usable via a web browser. It is written in PHP and requires a web server.

Adminer mainly supports MySQL, but it also supports MariaDB and other database management systems. Adminer has a wide range of plugins, some of which have been developed by the community.

Adminer is distributed with a dual license: Apache License 2.0 and GPL 2. Adminer does not have a commercial edition, but it accepts donations.

_{This page is licensed: CC BY-SA / Gnu FDL}

Database Workbench is a Windows application (which works fine under Wine on Linux) for database design, development, maintenance and testing for several database systems, including MySQL and MariaDB.

With Database Workbench you can:

• design a database;

• connect to multiple databases;

• view and modify meta data;

• view and modify data;

• import and export data;

• connect to any ODBC/ADO data source;

• transfer data between database systems;

• migrate meta data;

• compare meta data;

• manage privileges;

• debug stored procedure;

• print meta data or data.

It includes numerous other tools.

Database Workbench comes in multiple editions and is licensed on a per-module basis.

_{This page is licensed: CC BY-SA / Gnu FDL}

dbForge Fusion is an add-in for Visual Studio. It provides automatic and simple MariaDB database development, and boosts data management capacity. With this tool integrated, it is easy to work with database development and administration tasks from Visual Studio.

is a GUI data modeling tool that allows developers to visualize, design, and model databases by using entity relationship diagrams and automatically generate the most popular SQL databases, and to generate and share the data model documentation. Optimize your data model by using advanced features such as test data generation, schema compare, and schema synchronization.

Supported DBMS include MariaDB, MySQL, and Microsoft SQL Server.

Key features:

• Visual data modeling.

• Forward and Reverse Engineering.

The Ocelot GUI (ocelotgui), a database client, allows to connect to a MySQL or MariaDB server, enter SQL statements, and receive results. Features include syntax highlighting, user-settable colors and fonts for each part of the screen, resultset displays with multiline rows and resizable columns, and a debugger.

Visit for more information and to download.

_{This page is licensed: CC BY-SA / Gnu FDL}

TablePlus is an application with a clean user interface that allows developers to simultaneously manage databases in a very fast and secure way. It supports many popular database management systems like MariaDB, MySQL, and Postgres.

TablePlus is is available for macOS, Windows, iOS, and Linux.

Some notable features:

• Native build.

• Convenient query editor.

• Multi Tabs & Code Review.

• Can connect to multiples databases simultaneously.

TablePlus is available for free, but users can purchase a license to remove some limitations and customize the tool for higher needs on .

_{This page is licensed: CC BY-SA / Gnu FDL}

DbVisualizer is a cross-platform database tool for developers, DBAs, analysts and SQL programmers. Both Free and paid Pro versions are available. Supported databases include MySQL, MariaDB, and PostgreSQL.

DbVisualizer has been carefully developed by a small and dedicated team. Development decisions are based on user feedback.

Example of features:

• Simple navigation of database objects and their properties.

• Visual rendering of primary/foreign keys.

• Table data editing in spreadsheet with Export and import database schema.

• Flexible user interface in light and dark themes.

• Query optimization with an explain plan feature.

• Visual query builder using drag and drop.

• Flexible SQL scripts execution with parameter support.

• SQL formatting and Command-line interface for headless execution.

• .

_{This page is licensed: CC BY-SA / Gnu FDL}

OmniDB is a browser-based tool that simplifies MariaDB database management focusing on interactivity. It is designed to be powerful and lightweight.

Characteristics:

• Browser-based Tool: Accessible from any platform, using a browser as a medium.

• Responsive Interface: All available functions in a single page.

• Unified workspace: Different technologies managed in a single workspace.

• Simplified Editing: Easy to add and remove connections.

• Safety: Multi-user support with encrypted personal information.

• Interactive Tables: All functionalities use interactive tables, allowing copying and pasting in blocks.

• Smart SQL Editor: Contextual SQL code completion.

• Beautiful SQL Editor: You can choose between many available color themes.

• Tabbed SQL Editor: Easily add, rename or delete editor tabs.

More information .

_{This page is licensed: CC BY-SA / Gnu FDL}

is a modern SQL editor database management toolkit.

PgManage supports MariaDB along many other databases.

Features:

Desktop or Browser-based: Runs as desktop application or can be installed as a webapp and used in a browser.

Modern Interface: The UI is optimized to be easy to use efficient to navigate.

Multiple Workspaces: Work with many database sessions at once and easily switch between them

phpMyAdmin is a web-based tool for administering MariaDB and MySQL.

It requires a web server, PHP, and a browser.

Read more at phpmyadmin.net.

_{This page is licensed: CC BY-SA / Gnu FDL}

DbSchema helps you design, document and manage databases. Design new tables, generate HTML5 documentation, explore and edit the database data, compare and synchronize the schema over multiple databases, edit and execute SQL, and generate random data.

DbSchema is compatible with all relational and some No-SQL databases. It works on all major operating systems, including Windows, Linux and macOS.

You can download and evaluate DbSchema 15 days for free.

DBSchema Webpage

_{This page is licensed: CC BY-SA / Gnu FDL}

Luna Modeler is a database design tool for MariaDB and other relational databases.

Draw diagrams, reverse engineer existing database structures and generate SQL code.

Supported platforms include MariaDB, PostgreSQL, and SQLite.

Key features:

• Database modeling & schema design.

• Reverse engineering.

• Support for database-specific settings.

• Three display modes: metadata, sample data or descriptions.

• Default values for newly created objects.

• Export to PDF.

• Dark and Light themes.

• SQL script generation.

Supported OS

Luna Modeler is available for Windows, Linux and macOS.

More information

See for more information.

_{This page is licensed: CC BY-SA / Gnu FDL}

mycli is a command-line interface for MariaDB, MySQL, and Percona, with auto-completion and syntax highlighting. It is written in Python, and runs on Linux, Mac and Windows.

Read more at mycli.net.

_{This page is licensed: CC BY-SA / Gnu FDL}

Toad Edge is a database management application that allows you to perform database administration tasks with ease.

Toad Edge allows you to:

• Connect to your MySQL database, view, explore and edit database structure, database objects and properties.

• Manage database objects, easily add, edit or drop objects in Object Explorer.

• Manage data stored in your database, add, edit or remove records.

• Write complex SQL code comfortably in Worksheet.

• Compare and synchronize databases using powerful Schema Compare.

• Obtain detailed information about your databases.

More information .

_{This page is licensed: CC BY-SA / Gnu FDL}

Generate and populate databases with large volumes of realistic test data.

SB Data Generator is a simple and powerful GUI tool for creating large volumes of realistic test data to populate selected tables or entire databases. The tool reverses your database and displays tables and columns, so you can assign to them multiple data generator templates. It includes multiple built-in generators that allow populating MariaDB database tables with realistic data of various types.

Key Benefits:

• Understand your database structure by visualizing the ER Diagram (tables, columns, relationships, keys, sequences, indexes, and triggers).

• Ability to generate a large volume of realistic test data.

• Preview what data is generated before populating the database with test data.

• Multiple built-in generators available with the ability to create custom data generators.

• Generate test data for most popular DBMS including MariaDB and MySQL.

.

_{This page is licensed: CC BY-SA / Gnu FDL}

is a solution that allows for the comparison of the MariaDB database structure. With this tool, you can find the differences in MariaDB database schemas.

Features are described in the following.

MariaDB & MySQL Schema Synchronization

Update MariaDB schemas by generating accurate synchronization scripts.

Preview sync scripts for any schema objects.

Customize the synchronization output with various options.

Get warnings on possible errors while synchronization.

Overview

KS DB Merge Tools for MySQL and MariaDB is a diff & merge tool for MySQL and MariaDB, allowing to compare and sync both schema and data. It is a Freemium application - many features are exposed in the Free version (available for commercial use), some extended features are available only in the paid Standard version (in many cases can be provided at no cost for open source developers).

Application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. Here are the primary application tabs:

is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports many popular relational databases like MySQL, MariaDB, and PostgreSQL.

A list of basic features:

• Data viewer and editor: sorting, filtering, image displaying, export of selected data and much more.

• Metadata browser: possibility to view and edit existing tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions, etc), security entities (users, roles, etc).

is a versatile software solution designed to meet the needs of full-stack database specialists. It offers a wide range of features to address database challenges across major providers: MySQL/MariaDB, SQL Server, Oracle, and PostgreSQL. When it comes to MySQL and MariaDB, dbForge Edge provides a highly functional IDE that covers almost all aspects of database development and management.

Features are described in the following.

Design

dbForge Edge includes a built-in Database Designer equipped with ER diagrams, allowing users to construct and edit databases. An intuitive interface facilitates the creation of database structures and generation of reusable SQL scripts for creating actual databases. Table Designer is a separate feature for visual creation and management of tables that covers the setup of columns, data types, constraints, etc.

is a fully native database client for macOS and . It supports database management systems such as MariaDB, MySQL, and Postgres.

Features include:

• Syntax highlighting & Autocomplete (sometimes called intellisense).

• Customizable themes allowing the query editor to be completely customized.

is a fast, database management application for working with MySQL and MariaDB databases. It runs on macOS only.

is open source, so it's easy to be involved and enhance it for MariaDB.

If you have any issues with Sequel Pro on MariaDB, please use the for that!

See Also

is a monitoring tool that gives database administrators real-time insights for optimizing the performance of MariaDB servers.

Key Features:

1. Agentless monitoring.

2. Fully customizable.

3. Affordable.

Webyog’s SQL DM is fully compatible with Amazon Aurora databases, and Webyog is an Amazon launch partner.

is a graphical frontend for MariaDB. It is a commercial product with several different versions (Navicat Premium, Navicat for MySQL, etc...) and different "editions" within those versions (Non-commercial, Standard, and Enterprise). Certain features are only available in certain editions/versions.

Navicat is available for Windows, MacOS, and Linux.

In addition to standard client features, it includes

• An SQL Builder/Editor,

• A Data Modeling Tool (Enterprise version only),

dbForge Data Generator for MariaDB and MySQL is a powerful solution that helps create massive volumes of meaningful and realistic data. This tool performs various predefined data generators with customizable options.

Data Generator Key Features:

1. Extensive support for all column data types

Enjoy the advantage of various data types support

2. Multiple generators with unique test data

Enjoy multiple customization options with individual generators for every data type supported

3. MariaDB data generation and data integrity support

Generate consistent random data through multiple tables

Disable triggers and constraints to avoid interference with database logic

4. MariaDB data distribution modes

Fine-tune the way you want your data to be generated

5. Multiple ways to generate data in MySQL

Generate a data population script, execute it against a MariaDB database, save or edit it later

6. Basic generators

Populate tables with a great variety of values types, like JSON, Python, XML, etc.

7. Meaningful test data generators

Select any of 200+ real-world generators and populate tables with realistic data related to various spheres

8. User-defined generators

Create, save and use your own data generators tailored for your needs

9. Real-time data generation preview

Enjoy real-time visualization of the alterations you make

Visually assess the data to be generated

10. Command-line interface

Schedule your routine data generation tasks

Create a command line execution file for running database documentation tasks

11. Broad compatibility options

MariaDB server versions 5.5-11.4

Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud

Security connections: Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona

Download a free 30-day trial of dbForge Data Generator .

_{This page is licensed: CC BY-SA / Gnu FDL}

Beekeeper Studio is an open-source database GUI available for Linux, MacOS, and Windows.

Beekeeper Studio works with MariaDB, but also works with other databases.

Beekeeper Studio includes the following features:

• Tabbed interface.

• SSH tunneling.

• SQL autocomplete.

• Multi-connection.

The Community Edition is , and is , with no usage tracking or similar behavior.

Links

• Homepage -

• GitHub -

_{This page is licensed: CC BY-SA / Gnu FDL}

Valentina Studio is a graphical front end for MariaDB with a free version, and a Pro version that adds advanced features.

Free Valentina Studio offers the following features:

• natively available on macOS, Windows & Linux,

• a feature rich, visual SQL Editor with powerful search functionality,

• SQLDIFF,

• a highly productive Data Editor,

• support for many data sources,

• ODBC import,

• Schema Editor with powerful visual diagramming features, Diagram Editor; import diagrams from MySQL Workbench,

• Report Viewer with printing, export to PDF and HTML (local reports and from Valentina Server),

• Forms Client for working with visual forms and MariaDB (locally and from Valentina Server),

• Free supports most popular data sources, MariaDB, MySQL, SQL Server, SQLite, PostgreSQL and more.

Use the to see which version is best for your needs or

_{This page is licensed: CC BY-SA / Gnu FDL}

DeZign for Databases is a data modeling tool for developers and DBA's that helps model, create, and maintain MariaDB databases. It runs on Windows only.

Supported database management systems include MariaDB, MySQL, and SQL Server.

Key features:

• Visual database modeling (Entity relationship diagrams).

• Generate database schemas directly from the data model.

• Incorporate changes from live databases into your existing models.

• Create change scripts by comparing your model with the live database structure.

• Publish and maintain data definitions to ensure consistency and accessibility.

• Convert models into SQL, streamlining database creation.

• Create clear and visually appealing ER diagrams, including sub-diagrams for complex systems.

• Support version control to manage different iterations of your model.

See for more information.

_{This page is licensed: CC BY-SA / Gnu FDL}

SQLyog is a GUI tool to manage MySQL and MariaDB servers and databases in physical, virtual, and cloud environments. DBAs, developers, and database architects alike, use SQLyog to visually compare, optimize, and document schemas.

Key Features:

• Automatically synchronize data,

• Visually compare data, and

• Import external data.

Additional Highlights:

• Runs on Microsoft Windows with no dependencies on runtimes (such as Microsoft .NET and Java) and database abstraction layers (such as ODBC and JDBC).

• Distributed as a free Community edition and as a paid, proprietary Ultimate edition.

More information .

_{This page is licensed: CC BY-SA / Gnu FDL}

MariaDB Direct Query Adapter for Power BI enables Microsoft Power BI Desktop users to remotely connect to and query their MariaDB database including on MariaDB MariaDB Cloud without downloading the entire data set to their local machine.

MariaDB Direct Query Adapter is a Microsoft certified connector for Microsoft Power BI Desktop.

About

Microsoft Power BI Desktop is a free business intelligence tool available as a downloadable desktop client. Built for analysts, Microsoft Power BI provides state-of-the-art interactive visualizations, with industry-leading data query and modeling built-in. It is one of the top business intelligence tools in use globally.

MariaDB database products support analytics and data warehousing in addition to transactional databases. Customers can meet the challenges from complex workloads using a single stack. MariaDB Enterprise Server includes pluggable smart storage engines to meet specific workload needs and connectors for high-performance data access by applications.

dbForge Documenter is a useful tool for the MariaDB database that allows for the automatic generation of database documentation in such formats as HTML, PDF, and Markdown. Users can adjust the created documentation with a great variety of options.

Features are described in the following.

Searchable MariaDB & MySQL Documentation

Search as you type. View the highlighted matching text after entering the name of a required object in the search field.

Compatibility Options

Various cloud services: Amazon RDS, Amazon Aurora, Google Cloud, Oracle MySQL Cloud, Alibaba Cloud,

Security connections: Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona.

Database Structure

Detailed MariaDB database information, such as types, details, and properties of the objects, inter-object dependencies, and DDL codes.

Customization of Document Management

Various style templates allowing for alteration of documentation layout.

Document Formats

• HTML and PDF (searchable formats).

• Markdown.

Extended Properties Support

Edit or add an object description.

Download a free 30-day trial of dbForge Documenter for MariaDB and MySQL .

is available, too.

_{This page is licensed: CC BY-SA / Gnu FDL}

helps compare and synchronize data in MariaDB, MySQL, and Percona databases and scripts folders. You can find differences between your data, as it helps analyze comparison results, creates a synchronization script, and applies changes. Additionally, MariaDB data can be compared with command-line support.

Features are described in the following.

Database Synchronization Features

• Create accurate synchronization scripts.

is a visual tool that helps create any sort of MariaDB queries. Queries can be drawn on a diagram.

Features are described in the following.

Exporting Data

Export data to many popular formats.

Export data from several tables simultaneously.

Create templates for repeated operations.

dbForge Studio for MariaDB is a universal IDE with GUI tools that has all the necessary built-in capabilities to work with MariaDB and MySQL databases for their development, management, and administration. It allows for creating, managing, and editing the data without the need to store them locally.

This GUI tool offers a rich visual design that is perfect for working with large scripts, preparing data reports, and database projects. At any time, you can back up or restore your data, export or import them to and from the most commonly used formats, and compare or synchronize the MariaDB databases.

Features are described in the following.

Intelligent SQL Coding

• Automatic code completion.

• MariaDB syntax highlighting.

• Code refactoring and formatting.

• CRUD generation.

Database Compare and Sync

• Data and schema synchronization and comparison.

• Recurring database sync tasks planning.

• Comparison report generation.

Import and Export Data

• MariaDB data export to commonly used formats.

• Data import from popular formats into MariaDB table.

• Rich customization ability.

• Command-line automation for data tasks.

MariaDB Administration Tools

• MariaDB databases backing up and restoring.

• User accounts and permissions configuration.

• Table maintenance.

• Database scripts generation.

Copy Database

• Source and Target server selection.

• Database to be copied or dropped selection.

• Configuration of the database copying parameters.

• Progress of copying tracing and abortion of the copying.

Database Designer

• Schema diagrams generation.

• Visual database construction.

• Foreign key relations between tables.

Data Generator

• Data customization supported by multiple generators.

• All kinds of generators: basic, meaningful, and user-defined.

• Real-time preview of generated data.

• Command-line interface.

Query Profiler

• Visual query profiling.

• Profiling results comparison.

Visual Query Builder

• Automatic generation of the script template for queries.

• Easy navigation through the database objects.

• Support for different query types.

• Support for sequence tables.

Table Designer

• Table creation and editing in MariaDB with no code.

• Automatic data type setting for frequently-used column values.

• Errors prevention while working with tables.

• MariaDB script automatic generation according to the changes made by a user.

Database Refactoring

• Renaming database objects with preview.

• Refactoring script.

Source Control

• Version control of database schemas and static table data.

• Compatibility with all major version control systems.

• Dedicated and shared development models.

• Quick comparison of database versions.

Database Projects

• MariaDB version control system providing efficient database team development.

• Scripts folder for exporting a database project to a MariaDB script file.

Report and Analysis

• Pivot tables for summarizing and viewing the data.

• A powerful wizard with robust features.

• Full command line support.

• 9 formats for reports' delivery.

Database Documenter

• A comprehensive overview of the database structure.

• Examine the internal dependencies between objects and databases.

• Customize the style and generate the docs in several formats.

Support for MariaDB Objects

• Packages.

• Sequences.

• Temporal tables.

This database tool is one of the most appreciated worldwide and trusted by many people. Devart’s dbForge Studio has received a lot of awards that confirm its overwhelming popularity.

Download a free 30-day trial of dbForge Studio for MariaDB and MySQL .

is available, too.

_{This page is licensed: CC BY-SA / Gnu FDL}

is a Windows client for MariaDB and MySQL, and is bundled with the Windows version of MariaDB.

LibreOffice Base is an open source RDBMS (relational database management system) frontend tool to create and manage various databases.

Preparing the ODBC Connection

First, make sure to prepare MariaDB Connector/ODBC as explained in .

This includes

• downloading the latest MariaDB Connector/ODBC,

• copying the shared library libmaodbc.so to /usr/lib/[multi-arch],

• installing the unixodbc, unixodbc-dev, openssh-client, odbcinst packages, and

• creating a template file for the .

• Install the ODBC driver from the template file by running:

Verify the installation was successful in /etc/odbcinst.ini file (this path is obtained by the config info /-j/ option, where drivers are installed in that predefined location).

• Create a template file for the . A sample “MariaDB_odbc_data_source_template.ini” could be:

• Install data source:

• Verify successful installation in the /.odbc.ini file

• Verify successful installation also using the utility:

Start with LibreOffice Base

Start Libreoffice Base from the terminal by running lobase (make sure to install the libreoffice-base package if needed). The default option is to create a new database, which is HSQLDB. In order to connect to a running MariaDB server, choose “Connect to an existing database” and choose “ODBC” driver as shown below:

After that, choose DSN (the one that we created in the previous step) and click “Next”:

Provide a user name (and password if needed) and again check the connection (with the “Test Connection” button) and click “Next”:

After that, we have options to register the database. Registration in this sense means that the database is viewable by other LibreOffice modules (like LibreOffice Calc and LibreOffice Writer). So this step is optional. In this example, we will save as “fosdem21_mariadb.odb”. See .

It opens the following window:

It consists of three panels:

1. “Database” window with the options,

2. "Tables",

3. "Queries",

4. "Forms",

As we can see, there are system tables in the “mysql” database as well as “test” database.

Let’s say we create a table using the REST API from JSON data from , and another table using the same mechanism from , and let’s call them webposts and webusers. In order to do so, we have to enable the CONNECT storage engine plugin and start with REST_API. See more in the article.

The queries we need to run in MariaDB are:

The result in LibreOffice Base is as shown below:

Double clicking on the table opens a new window with the data displayed to inspect:

To create the table from the “Tasks” window, use the option “Create Table in Design View”, where one can specify specific field names and types as shown:

From the “Tasks” window one can create a table using the option “Use Wizard to Create Table” to create some sample tables.

One can fill the data in the existing table, or create and define the new table from the LibreOffice Calc module with simple copy-paste (in the "Tasks" window).

Using a Registered Database

Other modules can use the registered database, for example, open "LibreOffice Calc" and go to "Tools", "Options" and you will see the "odb" file we registered when starting "LibreOffice Base".

_{This page is licensed: CC BY-SA / Gnu FDL}

Querious is a database administration tool for macOS.

It can be purchased and downloaded at .

_{This page is licensed: CC BY-SA / Gnu FDL}