Download Xata JDBC Driver

Download the Xata JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Xata JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Xata. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Xata driver uses its own syntax — see the connection details below.

The Xata JDBC driver

Xata is a serverless database platform built on PostgreSQL that adds built-in full-text search, branching, and a spreadsheet-like UI for data management. It is designed for modern web applications that need a combination of relational data storage and search capabilities without managing separate infrastructure. Xata supports database branching for safe schema migrations across environments.

The Xata JDBC URL

• Required File(s): postgresql-xxx.jar
• Java Driver Class: org.postgresql.Driver
• JDBC URL: jdbc:postgresql://{HOST}:{PORT}/{DB}
• Website: Xata

Xata provides a direct PostgreSQL connection URL accessible from the Xata dashboard (Settings → PostgreSQL endpoint). Requires sslmode=require. Use the PostgreSQL JDBC driver for connectivity. The direct PostgreSQL endpoint supports standard SQL queries against Xata tables.

Connecting to Xata

Xata exposes a real PostgreSQL endpoint, so any PostgreSQL client reaches it. There is no server to configure and no firewall to open — three details decide whether the connection succeeds.

1. Copy the JDBC URL from the Xata console. You will find it in the branch's PostgreSQL endpoint settings.
2. Keep ?sslmode=require in the URL. Xata refuses connections that are not encrypted, and the parameter is easy to lose when the string is retyped by hand.
3. Choose direct or pooled. Swapping -rw for -pooler in the host name moves the connection onto the pooler. A desktop tool opens few connections, so either is fine.
4. Paste the URL into DbSchema. In the Connection Dialog set Connection Mode to Edit the JDBC URL Manually and paste the string you copied. The user and the password are entered in the first tab, not in the URL.

Every Xata branch has its own endpoint. Connect DbSchema to two of them to compare a migration branch against main before it is merged.

DbSchema and Xata

DbSchema connects to Xata via its PostgreSQL-compatible endpoint using the standard JDBC driver, enabling visual schema exploration across Xata database branches, SQL query execution, and documentation of Xata table structures including full-text search column types.