Aiven runs managed PostgreSQL (and other engines) across multiple cloud providers. From Dora's perspective, it is a standard Postgres host — just paste the service URI.
Aiven enforces SSL on all connections. Dora applies SSL automatically when it sees an Aiven host, so nothing extra is needed on your end.
PostgreSQL connection string
postgresql://[USER]:[PASSWORD]@[HOST].aivencloud.com:[PORT]/[DBNAME]?sslmode=requireSteps
1.Open your Aiven service
In the Aiven Console, navigate to your project and open the PostgreSQL service you want to connect to.
2.Copy the Service URI
On the Overview tab, find the "Service URI" field. Click the copy icon. The URI looks like postgresql://[USER]:[PASSWORD]@[HOST].aivencloud.com:[PORT]/[DBNAME]?sslmode=require.
3.Add a connection in Dora
Create a new connection in Dora and paste the Service URI. Dora reads all fields — host, port, user, password, database, and SSL mode — from the string.
4.Test and connect
Click Test to verify the connection, then Connect. Your Aiven tables and schemas appear in the sidebar.
Good to know
- Aiven requires SSL (sslmode=require). The Service URI includes this parameter, and Dora respects it automatically.
- Aiven also provides a CA certificate for sslmode=verify-full. For most desktop use, sslmode=require is sufficient and simpler.
- If you use Aiven's connection pooler (PgBouncer), the Service URI changes — find the pooler-specific URI under Advanced configuration in the Aiven console.