Blog

Xata is joining ClickHouse

Postgres branching without moving your database

Stream production Postgres into a continuously updated mirror with pgstream, then give every pull request and agent its own copy-on-write branch. No migration.

Introducing the Xata MCP server 2.0

Let a coding agent branch your Postgres, work in the copy, and delete it. No sandbox flags, no mock modes, no credentials in the model's context.

Multi-tenant BYOK encryption in PostgreSQL with pgcrypto

Implement multi-tenant BYOK column encryption in PostgreSQL with pgcrypto using customer-managed encryption keys.

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.

Introducing the Xata GitHub App

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.

PostgreSQL as a temporal database

Postgres 18 introduced temporal keys (WITHOUT OVERLAPS, PERIOD).Postgres 19 expands (UPDATE/DELETE ... FOR PORTION OF) temporal capabilities further.

Branch Logs: PostgreSQL observability, right in the console

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.

pgstream v1.1.0: Steps towards turning it into a service

What's new in pgstream v1.1.0: env vars in YAML config, JSON logs, Kubernetes health probes, custom TLS for OpenSearch, and fixes for composite primary keys.

A thousand Postgres branches for $1

See how we reduced branching times from 20+ seconds to around a second and what use-cases these speed improvements enable.

Query Editor v2: A Better Way to Write SQL in Xata Console

We've rebuilt the query editor from the ground up. The new version is faster, smarter, and easier to use.

How we rebuilt PostgreSQL branch metrics on VictoriaMetrics, per cell

How we rebuilt Xata's PostgreSQL branch metrics on a self-hosted VictoriaMetrics stack in six weeks, with zero user-visible downtime.