MariaDB

Overview

MariaDB is an open-source relational database forked from MySQL. It offers enhanced storage engines (Aria, ColumnStore), improved replication, and additional SQL features while maintaining MySQL wire-protocol compatibility. MariaDB is available as a managed service on SkySQL, Amazon RDS, Google Cloud SQL, and Azure Database.

Driver

Crate: mysql_async
Version: 0.36

Connection fields

Field	Description
Host	Hostname or IP address of the MariaDB server.
Port	TCP port the server listens on.
Database	Name of the default database to connect to.
User	Authentication username.
Password	Authentication password. Stored in the macOS Keychain.
SSL Mode	One of `disable`, `prefer`, `require`, `verify-ca`, or `verify-full`.
Options	Additional connection parameters as `key1=val1&key2=val2`.

All connections also support an optional SSH tunnel. Configure the bastion host, port, user, and private key file under the SSH section of the connection form. SeeSSH tunnels for details.

URI format

Instead of filling in each field individually, you can paste a connection URI into thePaste URI field. Arris parses the URI and populates all fields automatically.

textConnection URI

mariadb://user:password@host:3307/dbname?ssl-mode=REQUIRED

SSL & TLS

MariaDB supports five SSL modes. Arris defaults to prefer, which uses SSL if the server supports it but falls back to unencrypted if not.

SSL Mode	Behavior
`disable`	Never use SSL. Not recommended for production.
`prefer`	Use SSL if available, fall back to unencrypted.
`require`	Always use SSL. Fail if the server does not support it.
`verify-ca`	Require SSL and verify the server certificate against a CA.
`verify-full`	Require SSL, verify the CA, and verify the server hostname matches the certificate.

Schema browser

Once connected, Arris fetches the schema tree from information_schema and organizes it into groups. In MariaDB, databases act as schema-level containers — the tree shows databases at the top level, each containing its own object groups.

The schema tree displays the following object types, grouped by category:

Tables — regular tables
Views — views
Routines — functions and stored procedures
Events — scheduled events
Triggers — table-level triggers
Sequences — sequences (MariaDB 10.3+)

Double-click any table or view to open it in a new tab with browse mode.

Supported SQL commands

Command	Notes
`SELECT`	Query data with `WHERE` filters, `JOIN`s, aggregates, and window functions.
`INSERT`	Insert single or multiple rows.
`UPDATE`	Update existing rows.
`DELETE`	Delete rows.
`CREATE` / `DROP`	Create and drop tables, views, and other schema objects.