A Schema Diagram for Every Xata Branch

Connect DbSchema to Xata and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed for relational modeling, migration planning, and SQL-first collaboration — keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Xata Features Download Xata JDBC Driver · All drivers

Xata's Serverless PostgreSQL with Branching and Built-In Search

Xata is a serverless data platform built on PostgreSQL that combines relational database capabilities with built-in full-text search, file attachments, and a branch-based development workflow. Every Xata database is organized into workspaces, databases, and branches, where each branch is an isolated PostgreSQL environment with its own schema state. Branching works similarly to git — you can fork a branch for a feature, apply schema changes, and merge back to the main branch without affecting other environments.

Download DbSchema Free See Xata Features

DbSchema connects to Xata via the standard PostgreSQL JDBC driver because Xata exposes a PostgreSQL-compatible wire protocol endpoint. Once connected, DbSchema reverse-engineers the branch's schema into a visual diagram. Tables created by Xata's search integration (which uses Elasticsearch under the hood but exposes them through SQL-like views) appear alongside your regular tables, giving you a complete picture of every queryable surface in your Xata branch.

Writing PostgreSQL Queries and Exploring Xata's Search-Enabled Tables

Xata's PostgreSQL endpoint accepts standard SQL, including joins, aggregations, window functions, and CTEs. DbSchema's SQL editor lets you write and execute queries against any Xata branch using the same interface you would use with any other PostgreSQL database. Xata's built-in full-text search is exposed as a xata_search function that can be called from SQL, so you can write search queries directly in the editor and review ranked results in the results grid.

Because Xata auto-generates a unique endpoint URL per branch, you can save separate DbSchema connection profiles for your main, preview, and development branches and switch between them with a single click. This makes it easy to test SQL changes against a feature branch before those changes are merged and applied to the main branch's schema.

Browsing Branch-Specific Schemas and Table Data

The DbSchema data explorer works with Xata the same way as any PostgreSQL database: browse table records row by row, apply a filter on any column, and follow foreign-key links to see how your application data connects. This is particularly useful during feature development on a Xata branch, where you need to confirm that your application is writing records with the correct structure before merging the branch.

Xata's file attachment feature stores file metadata in a dedicated JSON column alongside your table data. The explorer renders JSON column values as formatted text, letting you inspect attachment metadata — file name, MIME type, size, and storage URL — without writing custom queries. The CSV export feature lets you extract table snapshots from any branch for reporting or testing purposes.

Connect DbSchema to a Xata Branch

Because every Xata branch is its own PostgreSQL-compatible endpoint, connect to one branch at a time:

1. Install DbSchema — the PostgreSQL JDBC driver (org.postgresql.Driver) is bundled, so no additional driver install is needed.
2. Open the Xata dashboard under Settings → Connection strings and copy the direct PostgreSQL connection string for the branch you want, for example jdbc:postgresql://us-east-1.sql.xata.sh/mydb:main?sslmode=require — the path segment encodes the database name and branch name separated by a colon.
3. Select PostgreSQL as the database type in DbSchema and paste the connection string. SSL is required, so keep sslmode=require in the URL.
4. Authenticate with an API key generated from the Xata dashboard, used as the password, and your Xata workspace email (or the username given in the connection string) as the username.
5. Connect. DbSchema reverse-engineers that branch's schema into a diagram.

Each branch generates a distinct endpoint, so create one DbSchema connection profile per branch if you work across multiple branches regularly.

Xata Branch Workflows Benefit from DbSchema

• Provides a visual schema diagram per Xata branch, making branch-based development workflows easier to review and document.
• Lets developers run SQL queries against any branch without switching to the Xata web UI for every query.
• Surfaces search-enabled table views in the schema diagram, helping teams understand the full queryable surface of their Xata database.
• Simplifies management of multiple branch connection profiles in a single tool for teams that maintain several active Xata branches.
• Enables JSON column inspection (e.g., file attachment metadata) through the data explorer without requiring custom SQL.
• Generates offline schema documentation useful for architecture reviews and compliance processes.

Reviewing a feature branch shouldn't mean guessing at its schema state. Download DbSchema for free and diagram every Xata branch you work on before it merges to main.

Related databases

Teams working with Xata often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases