Xata is built on Postgres and exposes a direct Postgres wire endpoint, so Dora connects to it like any other Postgres database — no Xata SDK required.
Your API key acts as the password in the connection string, and the database and branch are part of the host path. Keep the key secret; Dora stores it encrypted on your device.
PostgreSQL connection string
postgresql://[WORKSPACE]:[API_KEY]@[REGION].sql.xata.sh/[DBNAME]:[BRANCH]?sslmode=requireSteps
1.Enable the Postgres endpoint in Xata
In the Xata web app, open your database settings and make sure the direct Postgres (wire protocol) endpoint is enabled for the branch you want to connect to.
2.Create an API key
Under Account Settings, generate an API key. This key is used in place of a password in the connection string.
3.Assemble the connection string
Copy the Postgres connection string shown in your workspace settings. It includes your workspace, region, database, and branch, and ends with sslmode=require.
4.Add the connection in Dora
Create a new connection in Dora, paste the string, then Test and Connect. Your Xata tables load into the sidebar.
Good to know
- Xata requires SSL. Keep sslmode=require in the connection string.
- The branch is part of the host path (for example main). To inspect a different branch, add a separate connection in Dora pointing at that branch.
- Treat the API key like a password — it grants access to your data. Disconnect in Dora to remove the stored credentials.