Client Connections

Overview

SkySQL database services are queried over client connections.

This page describes how to connect to most SkySQL services using a MariaDB-compatible client.

  • For Serverless Analytics services, see "Serverless Analytics" or "Notebook".

  • For Enterprise Server With Replica(s), the NoSQL Interface is an alternative way to connect to the database service.

  • Query Editor allows you to run queries directly in the browser to interact with data stored in SkySQL databases.

Connection Parameters

Service-specific Connection Parameters

Service-specific Connection Parameters
https://skysql.mariadb.com/dashboard

Connection parameters include:

  • Default username

  • Default password

  • Hostname (Fully Qualified Domain Name)

  • TCP port

  • PEM file containing the Certificate Authority Chain

To see the connection parameters specific to your service:

  1. Log in to the Portal.

  2. From the Dashboard, click the "CONNECT" button for the desired service.

To connect to a service, you must also manage the Firewall settings and add the client's IP address or netblock to the allowlist.

Supported Connectors

Applications can connect to MariaDB SkySQL services.

The following documentation is available for the SkySQL previous release, and can be adapted for the current release of SkySQL using the details on this page (Firewall management, different PEM file, and Connect page details).

Supported Clients

Clients listed here have been tested to properly connect with MariaDB SkySQL and execute queries.

The following documentation is available for the SkySQL previous release, and can be adapted for the current release SkySQL using the details on this page (Firewall management, different PEM file, and Connect page details).

Client Configuration

  1. Manage the Firewall settings and add the client's IP address or netblock to the allowlist.

  2. Download the "Certificate Authentication Chain" PEM file by clicking the displayed PEM file link. The PEM file used for the current release of SkySQL is different from the PEM files used by SkySQL previous release.

  3. Configure your client per the Connection Parameters.