---
title: "Xata – the branch native Postgres platform"
description: "Start fresh or branch an existing Postgres in seconds. Scale to zero when idle."
source: "https://xata.io/"
---

A production Postgres database with a tree of branches that are created, become active, hibernate and are deleted within seconds

Used by agents and humans at

- ![Checkfront](/images/client-logos/checkfront.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![Clade](/images/client-logos/cledade.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![Flo](/images/client-logos/flo.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![Academia](/images/marketing-v2/academia.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![MotherDuck](https://xata.io/images/client-logos/motherduck.png)
- ![GoTab](https://xata.io/images/client-logos/gotab.png)
- ![Numeric](/images/marketing-v2/numeric.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![Toot’n Totum](https://xata.io/images/client-logos/toot-n-totum.png)
- ![Grid](/images/client-logos/grid.svg?dpl=dpl_4HPaBRzSwkUbEMC9hK4PWaL5eySM)
- ![Prequel](https://xata.io/images/client-logos/prequel.png)

## 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.

Loading

#### claude(db): fix migration

Pull request _#1827_

Loading

#### feat(onboarding): add billing

Pull request _#3842_

Loading

#### feat(settings): add permissions

Pull request _#1237_

Loading

#### chore(*): deploy

Preview deployment _a7bde2_

Schema changed when tests were running

Loading

#### claude(db): fix migration

Pull request _#1827_

Loading

#### feat(onboarding): add billing

Pull request _#3842_

Loading

#### feat(settings): add permissions

Pull request _#1237_

Loading

#### chore(*): deploy

Preview deployment _a7bde2_

## Change schemas safely

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

## Test with production-like data

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

## 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

1.
2.
3.
4.

dev/preview-001

8.5 MB (Δ0.039%)

1.
2.
3.
4.

### 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.

stg/main-preview-2a3ef

CPU history: steady while running, zero while idle

RAM history: steady while running, zero while idle

Compute history: steady while running, zero while idle

### Scale to zero

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

A SQL query wakes an inactive development branch, activates it, and returns ten distinct users.

### Wake on the first query

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

Standard PostgreSQL features, extensions, drivers, and tools, including JSONB, PostGIS, pgvector, psql, Prisma, and Drizzle.

### 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.

### [Pull Requests](/docs/automations/ga-pr)

[Create a production-like database branch when a pull request opens. Run migrations and tests against it, then delete it after merge.](/docs/automations/ga-pr)

### [Coding Agents](/docs/ai-agents/overview)

[Let agents create isolated branches through the API or MCP, safely modify schemas and data, and clean up when the task finishes.](/docs/ai-agents/overview)

### [Preview Deployments](/docs/automations/vercel-github-app)

[Connect every preview to its own Postgres branch so the complete application, code, schema, and data, can be validated before publishing.](/docs/automations/vercel-github-app)

## 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](/use-cases/ci-cd)

## Production-ready Postgres

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

[Start deploying](https://console.xata.io/signup)

Illustrative database monitoring dashboard showing 99.99% uptime, 4 millisecond P99 latency, 2,011 connections, and read and write throughput.

### 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)

Storage for 100 pull requests, excluding production: Traditional DB 10 TB, Xata 0.3 TB. Linear scale starting at zero.

Traditional DB

Xata

### Compute (hours)

Compute for 100 pull requests, excluding production: Traditional DB 2,400 HR, Xata 8 HR 20 MIN. Linear scale starting at zero.

Traditional DB

Xata

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](/solutions/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 a fantastic way to run the pg_duckdb extension in the cloud. The platform’s flexibility and API access make Xata a terrific PostgreSQL partner for us.

Jordan Tigani

CEO

![MotherDuck](/api/media/file/motherduck-logo.png)

> 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](/api/media/file/safestreets-logo.png)

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

Jignesh Chauhan

Co-founder

![CallKarma.ai](/api/media/file/callkarma-logo.png)

> 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](/api/media/file/saasgrid-logo.png)

## Get started now. Branch in seconds.

[Get in touch](https://cal.com/team/xata/xata-sales)[Start free trial](https://console.xata.io/signup)
