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.

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.