Connection guide

Connect YugabyteDB to Dora

YugabyteDB speaks Postgres (YSQL). Dora connects to YugabyteDB Managed clusters using the connection string from the YugabyteDB console.

YugabyteDB is a distributed SQL database with full PostgreSQL compatibility (YSQL). Dora connects to YugabyteDB Managed clusters using the standard Postgres connection string.

Note that YugabyteDB uses port 5433 by default for YSQL (not the standard 5432). Dora handles this correctly when you paste the full connection string.

PostgreSQL connection string

postgresql://admin:[PASSWORD]@[HOST].ybdb.io:5433/yugabyte?sslmode=require

Steps

  1. 1.Open your cluster in YugabyteDB Managed

    Log into cloud.yugabyte.com and open your cluster.

  2. 2.Add your IP to the allow list

    Go to the Security tab → Network Allow List and add your machine's IP address. YugabyteDB Managed blocks all external IPs by default.

  3. 3.Copy the connection string

    On the Connect tab, select "Connect to your Application" and copy the connection string. It looks like postgresql://admin:[PASSWORD]@[HOST].ybdb.io:5433/yugabyte?sslmode=require.

  4. 4.Add a connection in Dora

    Create a new connection in Dora and paste the connection string. Dora reads the port 5433 and sslmode from the URL automatically.

  5. 5.Test and connect

    Click Test, then Connect. Your YugabyteDB schemas and tables appear in the sidebar.

Good to know

  • YugabyteDB YSQL uses port 5433, not the standard 5432. Make sure to include the port in the connection string.
  • YugabyteDB Managed requires SSL (sslmode=require). The connection string from the console includes this.
  • YugabyteDB is PostgreSQL-compatible, so standard SQL, joins, indexes, and transactions all work as expected in Dora.