Azure Database for PostgreSQL (both Flexible Server and the legacy Single Server) runs standard Postgres with an endpoint under .postgres.database.azure.com. Dora connects to it the same way any Postgres client does.
Azure requires SSL on managed Postgres connections by default. Dora applies SSL automatically.
PostgreSQL connection string
postgresql://[USER]:[PASSWORD]@[SERVER].postgres.database.azure.com:5432/[DBNAME]?sslmode=requireSteps
1.Open your server in the Azure portal
In the Azure portal, navigate to your Azure Database for PostgreSQL resource.
2.Find the connection string
Under Settings → Connection strings, select "psql" or "ADO.NET" to see the URI format. Note the server name (ending in .postgres.database.azure.com), port (5432), and admin username.
3.Configure firewall access
Under Security → Networking, add your machine's IP address to the firewall allowlist if you have not already done so.
4.Add a connection in Dora
Create a new connection in Dora. Use the Azure server name as host, 5432 as port, your admin username, and your password. For Single Server, the username format is user@servername; for Flexible Server, just the username.
5.Test and connect
Click Test, then Connect. Your Azure Postgres schemas and tables appear in the sidebar.
Good to know
- Azure requires SSL. Use sslmode=require in the connection string or enable SSL in the Dora connection dialog.
- Flexible Server is the recommended deployment type; Single Server is being retired. The connection method in Dora is identical for both.
- Azure also offers Azure Database for MySQL. Add a MySQL connection in Dora using the .mysql.database.azure.com endpoint for MySQL workloads.