Connect OVHcloud Databases from a Desktop GUI (IP + project CA + verify-full)
Connect OVHcloud Public Cloud PostgreSQL or MySQL from a laptop GUI: authorize your IP, avoid console sslmode=require alone for production, download the project CA for verify-full—with HiDataLinker, a free local-first PostgreSQL and MySQL desktop client.
OVHcloud Public Cloud Databases encrypt every session with TLS—and by default accept no public IPs until you authorize one. The console connection URI also defaults to sslmode=require, which encrypts traffic but does not verify the server certificate. This guide walks an OVHcloud Postgres GUI (and MySQL sibling) path with HiDataLinker, a free MIT open-source PostgreSQL and MySQL desktop client: local-first credentials, URL paste, Dump / same-engine migrate, and no seat or tab freemium wall on the core workflow.
1. Authorize your laptop IP first
In the OVHcloud Control Panel: Public Cloud → your project → Databases → select the service → Configuration → IPs.
Add your current public IP (or a tight CIDR). Until at least one address is allowed, clients time out even though the service looks “available.” Prefer a /32 for a fixed workstation; avoid 0.0.0.0/0 except short tests. Re-add when home ISP or travel Wi‑Fi rotates your public IP.
2. Copy Connection details (hostname, not an IP)
On the service Overview / Connection details card, note:
- Hostname like
postgresql-….database.cloud.ovh.net(or the MySQL host twin) - Service-specific port (not always 5432 / 3306)
- User (docs often show
avnadmin; prefer a least-privilege user in production) - Database (often
defaultdb) - Connection URI
- CA certificate (project CA—shared by databases in that Public Cloud project)
Always connect with the console hostname. In verify-full, an IP or custom DNS alias fails hostname checks against the server certificate.
3. sslmode=require vs verify-full (PostgreSQL)
| Mode | Encrypted | Verifies server cert | Verifies hostname |
|---|---|---|---|
require (console URI default) |
Yes | No* | No |
verify-ca |
Yes | Yes | No |
verify-full (OVH recommendation for production) |
Yes | Yes | Yes |
*With libpq, a CA in the default path can make require act like verify-ca—set sslmode=verify-full explicitly.
OVH’s project CA is not in the OS trust store. Download it from Connection details (ca.pem), then upgrade the URI:
postgres://USER:PASSWORD@HOST:PORT/defaultdb?sslmode=verify-full&sslrootcert=/path/to/ca.pem
Many GUIs start from the console URI (sslmode=require)—encrypted only. Switch to verify-full + project CA when the client can attach sslrootcert.
4. MySQL twin (same project CA idea)
For Public Cloud MySQL, authorize IPs the same way. Use host / port / user / defaultdb, SSL Require for encryption; for identity checks attach the project CA and Require and Verify Identity. Timeouts usually mean the IP list.
5. Connect with HiDataLinker
- Install from hidatalinker.onesolo.app (check the download page for macOS / Windows / Linux builds).
- Open New Connection → paste the OVH connection URI (keep TLS on; do not strip
sslmode). - Test, then connect. Profiles stay on your machine—local-first, no hosted workspace for secrets.
- Browse schemas, run SQL, and use Dump (
.sql) or same-engine migrate (PostgreSQL→PostgreSQL or MySQL→MySQL) when you need a free clone between saved connections.
Source: github.com/henrybit/HiDataLinker · Overview: /db-client
Why a light dual-engine client helps here
OVH Public Cloud Databases ship PostgreSQL and MySQL under one console. HiDataLinker is a thin Tauri desktop app for both engines in one place—paste DATABASE_URL, keep creds local, and avoid seat / connection / tab freemium walls on daily browse and query. Honest v1 focus: MySQL + PostgreSQL as marketed; not an OVH Control Panel, vRack manager, or in-app OVH bastion.
Common failures (and the fix)
- Timeout, no clear auth error — Client IP not in Configuration → IPs.
certificate verify failed/ missing root cert — Wrong or missing projectca.pem, or CA from a different Public Cloud project.- verify-full fails after “it worked with require” — Connecting by IP or custom alias; use the console hostname.
- Auth / wrong database — Re-copy URI after confirming user and
defaultdb(or your app database); keep password percent-encoding.
Soft next step
Need an OVHcloud database.cloud.ovh.net desktop client that pastes the string, respects TLS, and stays local-first for PostgreSQL (and MySQL)?
- Download: https://hidatalinker.onesolo.app/
- Source: https://github.com/henrybit/HiDataLinker
Authorize the laptop IP, copy the console hostname and URI, prefer verify-full + project CA for production, then query from a free MIT dual-engine desktop client.