The instant database scratchpad: xata scratch
xata scratch gives you a disposable copy of your Postgres from the terminal. One command forks a branch with your real data, runs your query, and deletes it.
xata scratch gives you a disposable copy of your Postgres from the terminal. One command forks a branch with your real data, runs your query, and deletes it.
Giving every pull request its own copy-on-write branch of the production Postgres you already run, even at terabyte scale. Ready in about three seconds, gone when the PR closes.
Read, filter, and search your PostgreSQL logs for any branch in the Xata console or the CLI. Per-branch, per-instance, no log drain to set up.
See how we reduced branching times from 20+ seconds to around a second and what use-cases these speed improvements enable.
How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.
Every Xata Postgres branch includes a built-in PgBouncer pooler in transaction mode. Tuned for serverless and edge, scales to zero with the branch.
Read the technical details of our new distributed storage system, which is the key to scaling to a huge number of Postgres instances.
We usually think branching means copying the whole database. With copy-on-write, it doesn't. Let's compare workflows like seeding to DB branching.
Xata is an open-source Postgres platform for agent scale. Instantly create isolated databases with copy-on-write branching at low cost.
Xata core is now available as open source under the Apache 2 license. It adds copy-on-write branching, scale-to-zero compute to Postgres.
Learn about the new xata container image, designed to integrate the xata CLI into your containerized workflows.
How copy-on-write branching works, where the platforms differ, and what it takes to branch an existing RDS or Aurora database in seconds without migrating it first.