There are 3 versions of YugabyteDB that are available across several platforms. You can read about them and choose on the Yugabyte Install Page
Go to the Yugabyte Cloud Console click on your cluster, click on Connect, and grab the credentials. You MUST allow your IP address in the cluster by using Yugabyte Cloud's whitelist feature. You can copy them all at once into a SQL client like Arctype as shown below.
YougabyteDB can also be hosted locally or deployed and self hosted with an enterprise license. It is supported with a first class integration in Arctype and shown below in dark and light mode.
To read more on the features available with this integration, please refer to the Arctype Docs on YugabyteDB.