TablePlus

Overview

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

  • TablePlus is a graphical database tool

  • TablePlus is available for Linux, macOS, and Windows

Compatibility

TablePlus 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:

  • TablePlus version 4.5.2 for macOS

  • TablePlus version 4.8.6 for Windows

When using other versions, these instructions may require adjustment.

Connecting with TablePlus

To connect to a MariaDB SkySQL service:

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

  2. Download the certificate authority chain.

  3. Create a new connection.

  4. Select "MariaDB".

  5. In the "MariaDB Connection" window:

    • Fill in the connection information for your 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.

    • In the "SSL mode" dropdown list, select "REQUIRED".

    • Click the "CA Certificate" button.

    • Enter the path to the certificate authority chain (.pem) file.