DigitalOcean Managed Databases provides hosted PostgreSQL and MySQL clusters. Dora connects to the public endpoint using the connection string from the control panel.
SSL is required on DigitalOcean managed databases. Dora applies it automatically when it detects a DigitalOcean host.
PostgreSQL connection string
postgresql://[USER]:[PASSWORD]@[HOST].db.ondigitalocean.com:[PORT]/[DBNAME]?sslmode=requireSteps
1.Open your cluster in the control panel
In the DigitalOcean control panel, go to Databases and open your Postgres cluster.
2.Copy the connection string
Click the "Connection Details" dropdown and select "Connection string" from the mode selector. Copy the URI. It ends with ?sslmode=require.
3.Add a connection in Dora
Create a new connection in Dora and paste the connection string. Dora reads the host, port, user, password, database, and SSL parameter from it.
4.Test and connect
Click Test, then Connect. Your cluster's schemas and tables appear in the sidebar.
Good to know
- DigitalOcean requires sslmode=require on all managed database connections. The copied string already contains this.
- Dora connects to the public endpoint. If you have restricted incoming IPs on the cluster, add your machine's IP in Databases → your cluster → Settings → Trusted Sources.
- DigitalOcean also offers MySQL managed databases. Add a MySQL connection in Dora and use the MySQL connection string from the same control panel page.