The Postgres for agentic workloads

Create instant database clones with production-like data for every agent, workflow, and CI/CD pipeline.

Used by agents and humans at

  • Checkfront
  • Clade
  • Flo
  • Academia
  • MotherDuck
  • GoTab
  • Numeric
  • Toot’n Totum
  • Grid
  • Prequel

Modern development needs more than a single staging database.

Coding agents multiply the number of changes happening at once. A single shared database cannot safely support all those migrations, tests, and experiments.

With a shared staging database

Everyone modifies the same dataset at once

claude(db): fix migration

Pull request #1827

feat(onboarding): add billing

Pull request #3842

feat(settings): add permissions

Pull request #1237

chore(*): deploy

Preview deployment a7bde2

Schema changed when tests were running

With Xata

Every workflow gets its own isolated branch

claude(db): fix migration

Pull request #1827

feat(onboarding): add billing

Pull request #3842

feat(settings): add permissions

Pull request #1237

chore(*): deploy

Preview deployment a7bde2

badge 13

Change schemas safely

Run migrations and test schema changes without affecting production or anyone else’s work.

badge 13

Test with production-like data

Catch issues that empty databases, fixtures, and mocks cannot reveal before changes ship.

badge 13

Work in parallel

Give every developer, agent, and preview an isolated database without waiting on shared staging.

Clone any Postgres database in seconds

Create isolated branches from production without copying the full database. Each branch gets its own schema, compute, and production-like data.

prod/main
21.82 GB
dev/preview-001
8.5 MB (Δ0.039%)

Copy-on-write storage

Using copy-on-write storage, each branch shares data with its parent and stores only changes instead of creating full copies.

badge 13stg/main-preview-2a3ef
CPU
4 vCPU
RAM
16 GB
Compute
$0.19 / hr

Scale to zero

Run branches only when needed. When idle, they hibernate and use no compute.

Wake on the first query

Branches wake on first query and respond instantly: no connection timeouts, no spin-up delays.

Upstream Postgres

Branching happens in the storage layer, not through a custom Postgres fork, so you keep standard PostgreSQL, extensions, drivers, and tooling.

Created when work starts.
Removed when it ends.

Xata runs vanilla PostgreSQL with high-performance storage, isolation, and instant branching built in.

Adopt Xata without moving production.

Keep production where it is, or move it to Xata. Either way, every pull request and deployment preview gets its own isolated Postgres branch.

  • Branches from a production clone
  • Production data with built-in anonymization
  • Continuously synced with production
Create a production clone

Production-ready Postgres

Xata runs vanilla PostgreSQL with high-performance storage, isolation, and instant branching built in.

Start deploying

Vanilla Postgres

No forks and no compatibility issues.

High availability

Automatic failover to read-replicas.

PITR backups

Restore your database to any point

Premium storage

Low latency and high throughput.

Example

How much does a hundred pull requests cost?

Consider a company creating 100 pull requests per day against a 100 GB production database.*

  • With traditional database infrastructure, giving every pull request its own isolated database quickly becomes unsustainable.

  • With Xata Copy-on-Write, branches share unchanged data with production. Scale-to-Zero reduces compute usage by pausing idle branches.

*Assumes 3 GB of unique changes per branch, 24 hours of always-on compute per traditional copy, and 5 active minutes per Xata branch at equivalent compute size. Storage totals assume all 100 branches are retained. Production is excluded from both comparisons. Resource usage only; actual costs depend on rates and how long storage is kept.

Additional branch storage and compute for 100 pull requests. Each chart uses a separate linear scale starting at zero. Storage uses decimal terabytes (1 TB = 1,000 GB).

Storage (TB)

Traditional DB

Compute (hours)

Traditional DB

Built for platforms

Add branch-native Postgres to your product

Xata runs vanilla PostgreSQL with high-performance storage, isolation, and instant branching built in.

Explore Xata for Platforms

Provision instantly

Create a new Postgres database in a second through a simple API.

Branch at any scale

Create a production-like branch in seconds, regardless of size. Scale to zero when idle and wake in 1s.

Scale to millions

Support large numbers of short-lived databases without duplicating storage or paying for idle compute.

Deploy on your terms

Use Xata Cloud or run in your own cloud with BYOC, private networking, and regional control.

Used by builders, engineers, and leaders worldwide

Xata is currently the best way to run the pg_duckdb extension in the cloud. The platform’s flexibility and API access make Xata the perfect PostgreSQL partner for us.

Jordan Tigani

CEO

MotherDuck
Xata was an easy choice for our team because of how straightforward the entire platform is, while simultaneously providing a suite of adequate features that we need. The Xata team has also been super responsive and more importantly quick to resolve the hiccups that we brought upon ourselves.

Chris Windsor

Lead Software Engineer

Safestreets
By adopting Xata, we cut database costs vs. our RDS setup and got better help from Postgres experts.

Jignesh Chauhan

Co-founder

CallKarma.ai
Xata was a no-brainer for our team. We get a lot of value out of the copy-on-write database branching and scale-to-zero features.

Ben Hubsch

Software Engineer

SaaSgrid

Get started now. Branch in seconds.