DBeaver Universal Database Tool

Overview

DBeaver can connect to MariaDB SkySQL services, allowing you to run queries interactively:

  • DBeaver is a graphical database tool

  • DBeaver is available for Linux, macOS, and Windows

Compatibility

DBeaver has been tested by MariaDB to properly connect and execute queries with:

  • Distributed Transactions

  • Multi-Node Analytics

  • Replicated Transactions

  • Single Node Analytics

  • Single Node Transactions

Tested Versions

These instructions are based on:

  • DBeaver Universal Database Tool version 22.0.2 for Windows

  • DBeaver Universal Database Tool version 22.0.3 for macOS

When using other versions, these instructions may require adjustment.

Requirements

  • DBeaver requires MariaDB Connector/J. DBeaver downloads Connector/J for you, but you may want to upgrade to the latest version.

Connect

To connect to a MariaDB SkySQL service:

  1. Determine the connection parameters for your MariaDB SkySQL service.

  2. Download the certificate authority chain.

  3. In Edit connection, select "Connection Settings".

  4. In the "General" tab:

    • Fill in the connection information for your SkySQL service.

      • For Host, enter the Fully Qualified Domain Name of your service.

      • For Port, enter the read-write port or read-only port of your service.

      • For User, enter the default username for your service or the username you created.

      • For Password, enter the default password for your default user, the password you set for the default user, or the password for the database user you created.

  5. In the "Driver properties" tab:

    • Set the useSsl property to true.

    • Set the serverSslCert property to the path to the certificate authority chain (.pem) file.

  6. In the "SSL" tab, do not enter any values. The TLS/SSL configuration was completed by setting driver properties in the previous step.