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 MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, SimpleDB, Firebird, ClickHouse. Adminer has a rich 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}

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 like Postgres, Redshift, SQL Server.

Beekeeper Studio includes the following features:

• Tabbed interface

• SSH tunneling

• SQL autocomplete

• Multi-connection

The Community Edition is free and open source, and is privacy respecting, with no usage tracking or similar behavior.

Links

• Homepage - beekeeperstudio.io

• GitHub - beekeeper-studio

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

SQL Diagnostic Manager (sql-diagnostic-manager-for-mysql) A monitoring tool that gives DBAs 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.

Features specifically for RDS and Aurora instances also available. SQL Diagnostic Manager is browser based and is a proud MariaDB Monitor and Advisor.

SQLyog Ultimate (en) A MySQL administration tool for DBAs, developers, and database architects. This tool enables database developers, administrators, and architects to visually compare, optimize, and document schemas.

Key Features:

1. Automatically synchronize data

2. Visually compare data

3. Import external data

SQLyog runs on Windows and is a graphical MariaDB manager and admin tool, combining the features of MySQL Administrator, phpMyAdmin and other MariaDB Front Ends and MariaDB GUI tools.

_{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: MySQL, MariaDB, Oracle, Firebird, InterBase, Microsoft SQL Server, SQL Anywhere and NexusDB.

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, more screen shots are available.

Database Workbench comes in multiple editions and is licensed on a per module basis, so there's always a version that suits you.

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

dbForge Data Compare helps compare and synchronize data in MariaDB, MySQL, and Percona databases and scripts folders. With this powerful GIU tool, you can easily find differences between your data, as it helps analyze comparison results, creates a synchronization script, and applies changes. Plus, MariaDB data can be compared with command-line support.

dbForge Data Compare Tool Features:

1. Database Synchronization Features

• Create accurate synchronization scripts

• Synchronize asynchronous data

• Create custom scripts with execution before/after the process of data synchronization

• Get warning messages on errors during synchronization

2. MySQL & MariaDB Task Automation

• Automate routine synchronizations with a command-line interface

• Plan your routine execution with Windows Scheduler

• Support for PowerShell compatibility

3. Script for Folder Data Comparison

• Compare data from your database with the data placed in the script folder locally

• Choose any database, connection, or script folder with the new Data Comparison Wizard

• See the data comparison results in a data result grid

4. Rich configurations for data comparison

• Enjoy various options for automatic mapping

• Compare customized queries

• Compare custom keys

5. Supported Data

• Tables

• Temporal tables

• Views

• BLOB data

• Compare databases and sync different MariaDB versions

6. Broad Compatibility Options

• All popular MariaDB server versions

• MariaDB set up on Windows, Linux, FreeBSD, etc.

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

• Secure Socket Layer (SSL), Secure Shell (SSH), HTTP Tunneling, PAM Percona security connections

7. Manage Comparison Results

• Find tables by name

• Filter the comparison process results

• Enter the values of default comparison options

• Group records by type in each compared object

8. Export Comparison Results

• Use only relevant data in your reports

• Generate comparison reports in various formats

Download a free 30-day trial of dbForge Data Compare here.

Documentation

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

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 here.

Documentation

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

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.

dbForge Documenter for MariaDB and MySQL Key Features:

1. Searchable MariaDB & MySQL documentation

Get the benefits of the search as you type principle

View the highlighted matching text after entering the name of a required object in the search field

2. 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

3. Broad picture of database structure

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

4. Rich customization of document management

Enjoy various style templates allowing for alteration of documentation layout

5. Several Document Formats supported:

• HTML and PDF (searchable formats)

• Markdown

6. Extended properties support

Edit an object description or add it if it is not specified

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

Documentation

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

dbForge Edge 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.

Key Features of dbForge Edge:

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.

SQL Development

dbForge Edge offers a powerful set of features to simplify SQL coding tasks. The code assistance module offers context-based keyword and object suggestions, code completion, instant syntax validation, customizable code formatting profiles, debugging, and code refactoring capabilities. Another feature worth mentioning is Query Builder – a tool that allows users to construct even the most complex SQL queries effortlessly in a visual mode.

Database Management

The solution incorporates schema and data comparison tools, enabling users to identify and manage differences in database schemas and table data. With automatically generated synchronization scripts, changes can be seamlessly deployed to target platforms. Comparison and synchronization jobs can also be automated, improving user efficiency.

dbForge Edge supports data migration (import and export) in over 10 major data formats. Both the import and export processes can be tailored to meet any specific requirements and automated for efficient workflows.

Also, dbForge Edge delivers Source Control, an integrated tool that enables version control of database schemas and static data, available for MariaDB, MySQL, and SQL Server databases. With its help, users can compare database versions, commit and revert changes with dependency awareness, view and resolve conflicts, and examine the history of changes. Source Control supports all popular version control systems, such as Git (including GitHub, GitLab, Azure DevOps, and Bitbucket), Apache Subversion (SVN), TFVC, Mercurial (Hg), Perforce (P4), and SourceGear Vault.

Testing

The solution features a robust Data Generator capable of producing high-quality test data in varying volumes and formats. Additionally, the Query Profiler tool enables comprehensive analysis and optimization of queries, thereby saving valuable time and resources.

Security Management

The dedicated module deals with user management configurations. The functionality provided by the software allows easy creation, editing, and management of user accounts and privileges.

Documenting and Reporting

With dbForge Edge, users can create detailed database documentation in various formats and with convenient navigation. The reporting module enables the summarization and analysis of data, presenting comprehensive reports with informative graphs, diagrams, and pivot tables.

dbForge Edge is not just a comprehensive IDE for MySQL and MariaDB – it goes far beyond that. It serves as an all-in-one solution for database experts who work with multiple database management systems, eliminating the need to assemble toolsets for each. With its extensive feature set, dbForge Edge empowers professionals to efficiently perform their tasks across diverse database environments.

Download a free 30-day trial of dbForge Edge

Order now

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

dbForge Fusion is a powerful 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.

dbForge Fusion add-in Key Features:

1. MySQL & MariaDB Data Import to Visual Studio

Import table data from multiple tables in various formats with the Data Import Wizard

Save import configuration templates for future use

2. Data Export from Visual Studio

Export data from multiple tables to various formats

Create templates with export settings for later use

3. Visual Studio Schema Compare

Generate schema synchronization scripts

Filter the results of a comparison process

Generate comparison reports

4. Data Comparison

Sync data with a command-line interface

Adjust and export comparison results

Generate a schema synchronization script

Filter objects during data comparison

5. Integration with Devart dotConnect

Complete codes easily

Enjoy advanced formatting

6. Drag&Drop from Database Explorer to WinForms

Drag database objects easily

Execute automatically generated scripts of components

See the result in a convenient grid

7. Code Formatter and Syntax Checker

Code snippets

Keyword and object suggestion

Errors highlighting

8. Code formatting

Embedded formatting profiles that can be swapped

Command-line support for automatic and scheduled formatting tasks

Bulk formatting

9. Routine Debugger

Automate the debugging process

Simplify your work with stored routines and triggers

10. Object editors

Enjoy visual creation, modification and management of any database and table objects

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

Documentation

Editions

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

dbForge Query Builder is a powerful visual tool that helps create any sort of MariaDB queries. Building a code has never been so easy – the query can be drawn on a diagram.

dbForge Query Builder Key features:

1. Exporting Data

Export your data to 14 popular formats

Export data from several tables simultaneously

Create templates for repeated operations

2. Database Explorer

Work with multiple database connections

Easy MariaDB query management with drag&drop functionality

Quick script generation

3. Visual Drag and Drop Query Builder

Enjoy zooming and keyboard support in a sophisticated diagram

Preview and print diagrams

Add and edit sub-queries visually

MariaDB JOINs generator

4. SQL Editing and Execution

Check the syntax automatically

Get quick information about schema objects

Customize formatting profiles

Execute scripts, statements and MariaDB fragments seamlessly

5. Query Profiler

Compare the results of the query visually

Review and evaluate a query plan shown in the tree view

Get the detailed query information

6. Data Editor

Enjoy advanced data filters

Browse and edit large objects in Data Viewer and Editor windows

Fetch asynchronous data

7. Data Reports

Data Report wizard supports building Data Reports and customizing them with a rich set of controls.

8. Master-Detail Browser

Allows users to view and analyze the data of several related database objects in a master-detail structured document. Edit data, build relationships, filter data based on specific criteria, sort data, etc. in the Design and Data views.

9. Pivot Tables

Let the user manipulate the data visually, including sorting, grouping, or filtering fields, building charts, and calculating totals.

Download a free 30-day trial of dbForge Query Builder for MariaDB and MySQL here.

Documentation

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

dbForge Schema Compare is an efficient solution that allows for the comparison of the MariaDB database structure. With this tool, you can easily find the differences in MariaDB database schemas.

Schema Compare Tool Key features:

1.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

Sync asynchronous structure

2. MariaDB Backup and Restore

Enjoy the advantages of MariaDB backup and restore Wizards

Have a full or partial backup

Restore database and schedule backups with a command-line interface

Support for databases over 2Gb

3. Scripts Folder Comparison

Compare the data both in two different databases and the database data with the data placed locally

Choose any connection and script folder stored locally with the new Data Comparison Wizard

View the comparison process results in a data grid

4. Routine Tasks Automation

Sync and compare database schemas with command-line support

Use the Windows Scheduler to automate the sync processes

Run synchronization and schema comparison tasks with command-line execution files

5. Supported Schema Objects

Packages

Sequences

6. Database Structure Comparison Configuration

Filter the types of objects before the comparison

Dismiss particular table options while comparing

Use the Schema Comparison Wizard for switching between the Target and Source databases

7. Comparison Results Analysis

Sort and filter the compared objects

Get a clear view of MariaDB and MySQL schema diffs in the grid.

Manage groups of compared objects

8. Comparison Results Export

Generate comparison results reports in HTML, Excel XML, XML for Excel

Include specifically selected objects in your comparison report

9. Broad Compatibility

MariaDB server versions 5.5-11.4

All MariaDB instances set up on Windows, Linux, FreeBSD, etc.

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 MariaDB and MySQL Schema Compare here.

Documentation

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

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 powerful 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. Apart from that, dbForge Studio supports the following servers:

• MariaDB,

• SkySQL (the MariaDB cloud database),

• All MySQL Server versions,

• Percona servers and TokuDB,

• MySQL and MariaDB on Amazon RDS and Amazon Aurora.

• Google Cloud, Alibaba Cloud, Tencent Cloud, Galera Cluster,

• Sphinx, etc.

Key Features:

1. Intelligent SQL Coding

• Automatic code completion

• MariaDB syntax highlighting

• Code refactoring and formatting

• CRUD generation

2. Database Compare and Sync

• Data and schema synchronization and comparison

• Recurring database sync tasks planning

• Comparison report generation

3. Import/Export Data MariaDB

• MariaDB data export to 14 commonly-used formats

• Data import from 10 popular formats into MariaDB table

• Rich customization ability

• Command-line automation for data tasks

4. MariaDB Admin Tools

• MariaDB databases backing up and restoring

• User accounts and permissions configuration

• Table maintenance

• Database scripts generation

5. Copy Database

• Source and Target servers’ selection

• Database to be copied or dropped selection

• Configuration of the database copying parameters

• Progress of copying tracing and abortion of the copying

6. Database Designer

• Schema diagrams generation

• Visual database construction

• Foreign key relations between tables

7. 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

8. Query Profiler

• Visual query profiling

• Profiling results comparison

9. 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

10. 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

11. Database Refactoring

• Renaming database objects with preview

• Refactoring script

12. 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

• Examination and resolution of conflicts

• History of changes

13. Database Projects

• MariaDB version control system providing efficient database team development

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

14. 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

15. 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

16. Support for MariaDB objects:

• Packages

• Sequences

• Temporal tables

Nowadays, with the growing popularity of the MariaDB database, the demand for a convenient, multi-functional tool is increasing, too. This solution must meet users’ needs, be easy to work with and provide constant support. Fortunately, dbForge Studio for MariaDB and MySQL is such a solution. 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 here.

Documentation

Editions

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

Powerful, yet easy-to-use, DbSchema helps you design, document and manage databases without having to be a SQL pro. Easily design new tables, generate HTML5 documentation, explore and edit the database data, compare and synchronize the schema over multiple databases, edit and execute SQL, generate random data.

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

You can download and evaluate DbSchema 15 days for free.

DBSchema Webpage

_{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 version available.

Supported databases: MySQL, MariaDB, PostgreSQL, Netezza, Db2, SQLite, Oracle, Amazon Redshift, Vertica, Snowflake and more.

For almost two decades 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

• All features

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

DeZign for Databases is an intuitive data modeling tool for developers and DBA's that can help you model, create and maintain MariaDB databases.

Supported platforms include:

• MariaDB

• MySQL

• Snowflake

• SQL Server

• PostgreSQL

• SQLite

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.

Supported OS

DeZign for Databases is available for Windows OS.

More information

See www.datanamic.com for more information.

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

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

Supported DBMS include:

• MariaDB

• MySQL

• Microsoft SQL Server

• Microsoft Azure SQL database

• Oracle

• PostgreSQL

• SQLite

• Firebird

• Amazon Redshift

• Amazon RDS

Key features:

• Visual data modeling

• Forward and Reverse Engineering

• Data Model Validation

• Data model documentation

• Schema Comparison and Synchronization

• Test data generation

• Change Database Platform

• Generate web user interface for CRUD

• Version management

Freeware version

Feature limited free version is available for download. Advanced features are available in the commercial edition. A feature comparison matrix is available for more details about features, pricing, and "trial" versions,

More information

See www.soft-builder.com for more information.

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

DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular relational databases: MySQL, MariaDB, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, Netezza, etc. Also, it supports NoSQL databases: MongoDB, Cassandra, Redis, Apache Hive, etc. in the Enterprise Edition version.

A brief list of basic features can be found below:

• 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).

• Data transfer: export and import for files in various formats (CSV, HTML, XML, XLS, XLSX).

• ER diagrams: possibility to automatically generate ER diagrams for a database/schema (diagram will contain all schema tables) or for a single table and export the diagram in a suitable format.

• SQL editor: possibility to organize all your scripts in folders, reassign database connections for particular scripts.

• Data and metadata search: full-text data search using against all chosen tables/views.

• Database structure comparing: possibility to perform objects structure compare.

DBeaver is actively developed and maintained. Usability is the main goal of this project, so program UI is carefully designed and implemented. Every user can send bug report and feature request on the GitHub page.

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

OmniDB is a browser-based tool that simplifies MariaDB database management focusing on interactivity, 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.

OmniDB Web Page:

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

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL and MariaDB databases.

Sequel Pro is open source, so it's easy to be involved and enhance it for MariaDB. You can also help by donating to the project!

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

See Also

• Sequal Pro home site

• Source code

• Issue tracking

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

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

HeidiSQL can:

• Connect to multiple servers in one window

• Connect to servers via commandline

• Create and edit tables, views, stored routines, triggers and scheduled events.

• Generate nice SQL-exports

• Export from one server/database directly to another server/database

• Manage user-privileges

• Import text-files

• Export table rows as CSV, HTML, XML, SQL, LaTeX and Wiki Markup

• Browse and edit table-data using a comfortable grid

• Bulk edit tables (move to db, change engine, collation etc.)

• Batch-insert ascii or binary files into tables

• Write queries with customizable syntax-highlighting and code-completion

• Pretty reformat disordered SQL

• Monitor and kill client-processes

• Find specific text in all tables of all databases of one server

• Optimize and repair tables in a batch manner

• And more...

More information, including Screenshots of HeidiSQL are available at the HeidiSQL Website.

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

Devart has upgraded dbForge Tools for MySQL and MariaDB with improved SQL document parser performance.

Devart, a recognized vendor of database management software, has released new versions of dbForge tools for MySQL product line – dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL, dbForge Query Builder for MySQL and dbForge Data Generator for MySQL.

dbForge Tools for MySQL have the following new features and improvements:

• Improved SQL document parser performance;

• Connection through Named Pipe implemented;

• Improved XML View and new JSON View for Data Editor and Viewer Window;

• Additional SQL statements are supported;

• Syntax Check supports new MariaDB 10.0 - 10.1 statements;

• Styled icons are used by default.

The upgraded versions of dbForge Schema Compare for MySQL, dbForge Data Compare for MySQL, dbForge Query Builder for MySQL and dbForge Data Generator for MySQL are provided with Syntax Check that supports new MariaDB 10.0 - 10.1 statements, also additional SQL statements are supported and other improvements were made.

For more information about dbForge tools for MySQL, please visit.

About Devart

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects. For additional information about Devart, visit.

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

Overview

KS DB Merge Tools for MySQL and MariaDB is an easy to use diff & merge tool for MySQL and MariaDB databases 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).

Product home page

Download

Use cases

Documentation

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:

Home tab

It is a starting point to open databases. Shows summary about all database objects. Note that it does not provide information about data/content changes, only about object definitions.

This tab is also used as a starting point to manage diff profiles, making it easy to customize the tool for your specific database project. Here, you can save and reuse custom queries, mappings, and data slices, allowing you to create tailored data diff summaries.

Object list

Lists all objects of some particular type - tables, views, etc. Allows to identify whether some object is new, changed or unchanged (note that for tables and views it does not provide information about data/content changes, only about object definitions). Quick filters available to show only new/changed/new+changed objects. Here we can select required objects on one side and generate a synchronization script to merge these changes to the other side.

Table data diff

Compares data for particular table or view. Quick filters available to show only new/changed/new+changed rows. We can select required rows on one side and generate synchronization script to merge these changes to the other side

Text diff

Compares definition of some particular database programming object like view or stored procedure.

Table structure diff

Compares definition of particular table. Here we can select required changes and generate synchronization script for them. This tab is available only in the Standard version, the Free version is using Text diff tab to compare table definitions.

Batch data diff

Allows to compare data for multiple tables and views, providing summary of data changes for the whole database. This tab is available only in the Standard version.

Query result diff

Compares arbitrary query results, it can be the same query running on both databases or different queries running on the same or different databases. This tab is available only in the Standard version.

Automation and Scripting

The Standard version has support of own domain-specific scripting language designed to automate diff and merge tasks provided by GUI. In addition to the primary GUI, there is a Script Editor application designed to help in writing and troubleshooting scripts and a separate command line utility that is used to run these scripts without user interaction. For the most typical tasks the scripts can be generated just with a single button click on GUI which produces a script relevant for the data or objects you currently observe on UI.

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

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

Preparing the ODBC Connection

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

That includes:

• Download the latest MariaDB Connector/ODBC

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

• Install the unixodbc, unixodbc-dev, openssh-client, odbcinst packages

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

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

$ sudo odbcinst -i -d -f MariaDB_odbc_driver_template.ini
odbcinst: Driver installed. Usage count increased to 1. 
    Target directory is /etc

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

$ odbcinst -j
unixODBC 2.3.6
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/anel/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

$ cat /etc/odbcinst.ini 
[MariaDB ODBC 3.1 Driver]
Description=MariaDB Connector/ODBC v.3.1
Driver=/usr/lib/x86_64-linux-gnu/libmaodbc.so
UsageCount=1

• Create a template file for the Data Source Name (DSN). A sample “MariaDB_odbc_data_source_template.ini” could be:

• Install data source:

odbcinst -i -s -h -f MariaDB_odbc_data_source_template.ini

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

$ cat ~/.odbc.ini 
[MariaDB-server]
Description=MariaDB server
Driver=MariaDB ODBC 3.1 Driver
SERVER=MariaDB
USER=anel
PASSWORD=
DATABASE=test
PORT=3306

• Verify successful installation also using the isql utility, for example:

$ isql MariaDB-server
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> show tables;
+--------------------------------------------------------------------------+
| Tables_in_test                                                           |
+--------------------------------------------------------------------------+
| Authors                                                                  |
| tbl_names                                                                |
| webposts                                                                 |
| webusers                                                                 |
+--------------------------------------------------------------------------+
SQLRowCount returns 4
4 rows fetched

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 Using a Registered Database.

It opens the following window:

It consists of three windows/panels:

1. “Database” window with the options

2. "Tables",

3. "Queries",

4. "Forms",

5. "Reports".

6. "Tasks window (dependent on what is selected in the “Database” window). When “Tables” is selected, the options are:

7. "Create Table in Design View",

8. "Use Wizard to Create Table" and

9. "Create View".

10. "Tables" window - shows list of tables that are created.

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 posts, and another table using the same mechanism from users, 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 CONNECT - Files Retrieved Using Rest Queries article.

The queries we need to run in MariaDB are:

CREATE TABLE webusers ENGINE=CONNECT TABLE_TYPE=JSON
  HTTP='http://jsonplaceholder.typicode.com/users';

CREATE TABLE webposts ENGINE=CONNECT TABLE_TYPE=JSON
  HTTP='http://jsonplaceholder.typicode.com/posts';

The result in LibreOffice Base will be 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}

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

• 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 www.datensen.com 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}

Navicat is a graphical front-end 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 compatible with all versions of MariaDB and with MySQL 3.21 and above. It is available for Windows, MacOS, and Linux.

In addition to standard client features, it includes:

• a SQL Builder/Editor

• a Data Modeling Tool (Enterprise version only)

• Data/Structure Synchronization

• Report Builder (Windows-only)

• "Premium" version which can connect to MariaDB, MySQL, SQL Server, SQLite, Oracle, and PostgreSQL databases simultaneously.

A feature comparison matrix is available. More information, including pricing and "trial" versions, is available on the Navicat website.

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

The Ocelot GUI (ocelotgui), a database client, allows users to connect to a MySQL or MariaDB DBMS server, enter SQL statements, and receive results. Some of its features are: syntax highlighting, user-settable colors and fonts for each part of the screen, result-set displays with multi-line rows and resizable columns, and a debugger.

Visit ocelot.ca for more information and to download.

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

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}

Querious is a database administration tool for macOS.

It can be purchased/downloaded at querious

_{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. The tool 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 will be 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

Learn more about SB Data Generator

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

SQLPro Studio is a fully native database client for macOS macOS and iOS. It supports databases such as MySQL, Postgres, Microsoft SQL Server, SQLite, Oracle and more.

Features include:

• Syntax highlighting & Autocomplete (sometimes called intellisense).

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

• The ability to run multiple queries at one time (and a customizable run query shortcut).

• Improved query error detection (errors in queries will be underlined red).

• Full dark mode & light mode support, along with custom themes.

Other features include:

• Complete SSH Tunnel support.

• Inline data filtering.

• Exporting & Exporting options to CSV, JSON & XML.

_{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 ● 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. Learn about why you should consider upgrading from the Community edition to the Ultimate edition here.

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

TablePlus is a modern, native app with a clean user interface that allows developers to simultaneously manage databases in a very fast and secure way. TablePlus supports most of the popular databases such as MySQL, Postgres, SQL Server, SQLite, Microsoft SQL Server, Redis, Redshift, Oracle, and many more.

TablePlus is compatible with all versions of MariaDB. It is available for macOS, Windows, iOS, and Linux at the moment.

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 TablePlus website.

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

Characteristics

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.

In TOAD Edge 1.2, support for MariaDB 10.1 has been added.

Product Information

toad-edge

downloads

Download: Freeware

1657

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

Features

• Version control integration.

• Macro record and playback.

• Database browser.

• Code snippet editor.

• Security manager.

• SQL editor.

• Fast, multi-tabbed schema browser.

• DB extract, compare-and-search utility.

• Import/export utility.

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

Valentina Studio is a graphical front end for MariaDB with two versions: a free version which supports features offered only in paid for versions of competing products 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 including all versions of MariaDB and MySQL 5.0.6 and later*

• 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 Valentina Studio FREE vs Valentina Studio PRO feature matrix to see which version is best for your needs or download to immediately evaluate.

_{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 SkySQL 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.

MariaDB Enterprise ColumnStore is a columnar storage engine designed to handle the extremely large data sets and ad hoc queries of analytical workloads. Data is written to disk by column rather than row and is automatically partitioned. Columnar data storage is designed to deliver real time analysis on billions of rows. MariaDB Enterprise ColumnStore is a plugin storage engine and is included with MariaDB Enterprise Server.

MariaDB Direct Query Adapter enables Power BI users to work with remote data without the need to download it onto the local machine. Downloading analytical data sets can present challenges such as download speed and inadequate memory on a local machine, and even a powerful laptop or desktop will be outperformed by the processing power of a high end server or MPP system. MariaDB's Direct Query Adapter enables users to avoid these limitations and provides robust querying and data visualization from any location.

Requirements

MariaDB Direct Query Adapter for Microsoft Power BI requires:

• Microsoft Power BI Desktop

• MariaDB ODBC Connector v3.1.10 or later.

Download and Install

To use MariaDB Direct Query Adapter with Microsoft Power BI Desktop:

1. Check the system requirements for Microsoft Power BI Desktop.

2. Download Microsoft Power BI Desktop using the Microsoft instructions.

3. Download MariaDB ODBC Connector.

4. Select MariaDB ODBC Connector v3.1.10 or later for MS Windows 64-bit.

5. Click on the download or choose "Open" to start the MariaDB ODBC Connector 64-bit Setup Wizard.

6. Click "Next".

7. Read and accept the terms and agreement.

8. Click "Next".

9. Choose "Typical" for installation type and click "Install".

10. When asked if you want to allow this app to makes changes to your device, click "Yes".

11. If you have older versions of MariaDB ODBC Connector 64-bit, select "Make User DSN's for older Connector version to use this version" and click "Finish". Otherwise, just click "Finish".

Connect

Connect to your remote MariaDB database from Power BI Desktop using the MariaDB Direct Query Adapter.

1. Open Microsoft Power BI Desktop.

2. From the Power BI home screen, choose Get Data->More. Enter "MariaDB". Select MariaDB from the menu and click "Connect".

3. Enter the data source. This will be an IP address and port number, or in the case of SkySQL, it will be the qualified domain name and port number.

4. Select "DirectQuery" and click "OK".

5. Enter your user name and password and click "Connect".

You are now connected to your remote MariaDB database and can use Microsoft Power BI to run queries without the need to download the data locally.

Queries

The MariaDB Direct Query Adapter for Power BI interacts with the SQL layer. It is upstream of the storage engine, so queries can be done regardless of the underlying storage engine.

For example, MariaDB Direct Query Adapter for Microsoft Power BI can be used to query data on a row-based transactional database using the InnoDB storage engines or a column-based data warehouse using the MariaDB Enterprise ColumnStore storage engine to deliver real time analysis of billions of rows of data.

Relationships

Power BI depends on relationships for data analysis. These relationships are automatically established for row-based databases, for example those using the InnoDB storage engine.

Because column-based storage engines such as MariaDB Enterprise ColumnStore do not use indexes, relationships must be set up manually. For more about creating relationships in Power BI see Create and Manage Relationships in Power BI.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}

See dbForge Studio for MariaDB