Branching gives every engineer and every agent their own Postgres. Now every branch has its own logs. Read, filter, and search them in the console, or match a pattern in one click. Same logs in your terminal with xata branch logs.

DeltaX, our open-source timeseries and columnar extension for Postgres, just shipped v0.2.1, mostly analytics performance work. A few engineering bits worth sharing:

DeltaX, our open-source timeseries and columnar extension for Postgres, just shipped v0.2.1, mostly analytics performance work. A few engineering bits worth sharing:

Postgres CDC has always been a thing you babysit: a CLI in a screen session, secrets in a config file, a pipeline that breaks on the next ALTER TABLE. pgstream v1.1.0 is a step toward running it as a service. K8s probes, JSON logs, and schema changes that flow to the target. xata.io/blog/pgstrea...

Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.

Today, Xata CEO Monica Sarbu joined the Berlin Buzzwords panel "The Agent Era: How AI Agents Are Reshaping Data Platforms," alongside speakers from Snowflake, Elastic, and MotherDuck, on what breaks when agents become the most demanding users of data platforms.

That sidebar full of "untitled query (3)" you never keep? We reworked the Xata query editor: new queries open as drafts, run and discard, nothing saved. Plus Run selected, per-statement tabs, autosave with AI naming. xata.io/blog/query-editor-v2-a-better-way-to-write-sql-in-xata-console

We rebuilt how every Postgres branch on Xata is observed: out of a central observability vendor, into a per-cell VictoriaMetrics stack. Nothing crosses cells, so one cell's observability can't break another's. Six weeks of work, no user-visible downtime. Full write-up: xata.io/blog/how-we-...

We open-sourced a Next.js + Postgres starter with 6 Claude Code skills. Branching, zero-downtime migrations, anonymized production clones. MIT licensed. github.com/xataio/nextjs-claude-code-starter

Monica + the Xata team are at AWS Summit Hamburg today, in the AWS Startup Zone, Hall 4. If you're thinking about Postgres for agent scale, swing by. Always up for that conversation.

DeltaX is now public: the TimescaleDB alternative with Apache 2.0. A Postgres extension for columnar storage and time-series compression. Preliminary ClickBench: ~4.7× faster on analytical queries. Star the project: github.com/xataio/deltax

Months of work just turned public. Star the repo and try the quickstart: github.com/xataio/delta...

pgstream v1.0.2 shipped. Stream-mode WAL batching means post-snapshot catch-up stops stalling on bulk-INSERT and DELETE tables (Postgres sink only for now; UPDATE still goes one at a time). Decode-time table filtering inside Postgres via wal2json.

Every Xata Postgres branch now has a managed PgBouncer endpoint, in the same memory envelope as the database. Auto-tuned to 0.9 of max_connections. 10,000 client connections per branch. Hibernates with the branch. Append `-pooler` to your branch ID. Writeup: xata.io/blog/a-conne...

We rebuilt the storage engine behind Xata Cloud. Today we're talking about why: xata.io/blog/xatasto...

I’ve written a blog post on why and how we built our own distributed storage engine. We’re calling it Xatastor and enables us to scale to a huge number of Postgres instances and branches. It’s based on ZFS and NVMe-oF as key technologies. xata.io/blog/xatasto...

Engineers are writing most of their code with AI now. The software engineering profession is not over. The job has split: AI codes, humans engineer. A thread on what changed and what didn't:

Two new per-branch settings in Xata: 1. Postgres minor version upgrades. Pick your target in the UI or CLI, the API validates it, branch restarts. 2. Password rotation. `xata branch rotate-password` generates a new password, active in under 1 second. Existing connections keep working.

Code review is a negotiation. The submitter trades shipping speed for the reviewer's confidence that this won't cause pain later. Most new coders don't realize this. They optimize for "does it work" when they should optimize for "can my reviewer approve this safely."

Remote teams don’t get stronger from more meetings. They get stronger from time together that feels human. At Xata, Club Xata France 2026 was built around good conversations, shared meals, walks, and the unplanned moments in between. Check the full story here: xata.io/blog/club-xa...

Xata is now open source. Apache 2.0. Postgres platform with Copy-on-write branching at the storage layer. Copy a TB-sized database in seconds. Inactive copies scale to zero automatically. 100% vanilla Postgres.

Built our product analytics warehouse in vanilla Postgres instead of adding an OLAP stack. Four data sources (Keycloak, PostHog, Orb, internal DB), materialized views to flatten JSONB, pg_cron for refreshes, and database branches to iterate on the schema safely: xata.io/blog/postgre...

Our CTO Tudor Golubenco is speaking tonight at the PostgreSQL Berlin Meetup, hosted at Zalando. The talk: How we reduced CloudNativePG wake-up times from 20+ seconds to sub-second for Xata's scale-to-zero Postgres clusters. 20:15 CET if you're in Berlin: meetup.com/postgresql-m...

pgstream v1.0.0 is out, with a major architectural change. Schema changes are now emitted directly into WAL as logical messages, without schema logs or stored schema state. If you work with Postgres CDC, this might be interesting. Details in the blog 👇 xata.io/blog/pgstrea...

Did you know Postgres lets you put **constraints on domains**, not just tables? A domain is a custom data type with rules attached, and Postgres stores those CHECK constraints right in `pg_constraint` linked by `contypid` instead of `conrelid`. A clean way to centralize data rules 👌

Taking database snapshots and moving large volumes of data over the network is something our customers do regularly. While batching is the de facto way to make this efficient choosing the right batch size is non-trivial considering network variability, latency & system load. Read how we solved it👇🏽

@divyendusingh.com is doing a great job making agents do all sorts of stuff using databases. In our case with a few simple instructions, they are able to do branching operations, run queries, validate bug fixes and more. The blog posts are paired with demo videos, have a look 👀 👇🏽

New in xata clone: AI-assisted PII removal config (schema → strict config → validated).

New in xata clone: xata clone config --mode=ai Feed it your schema + prompt → get a strict, reviewable anonymization config that’s typically more complete than static heuristics. Blog post: xata.io/blog/smarter...

AI agents get useful faster with guardrails, not plugins. Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix. Video + write-up:

Batching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another. We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments. Check the post 👇 xata.io/blog/postgre...

PostgreSQL stores *all* constraints: check, not-null, PK, FK, unique, exclusion and domain constraints as rows in `pg_constraint` catalog. In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).

Moving a production DB is stressful. Don’t. Keep prod on your infra. Stream a logical replica (WAL) into Xata, anonymize PII at ingest, then spin up copy-on-write Postgres branches in seconds - one per PR 👇

Testing one last change on prod before the holidays…

You wouldn’t let Claude Code touch prod. But some bugs *need* real data to reproduce. Here’s how we teach Claude to debug safely using Xata database branches 👇

It’s Friday and you want to ship to prod.

Giving agents access to realistic data via branches should scale the feature development without increasing costs. This shows how you can use the “scale to zero” feature of the Xata platform to improve feature development while keeping costs in check.

Postgres constraints are the rules that keep your data clean. Types tell you *what* can be stored but constraints enforce *what must be true*. If a row violates a rule, Postgres rejects it. No silent corruption. A few well-chosen constraints prevent entire classes of bugs. xata.io/blog/constra...

AI agents are “clever” to use available tools like grep, sed to find the relevant code files based on a prompt. Here we experiment with giving AI agent tools to change environment variables in a repository that it checked out and it worked.

We explored giving AI agents access to compute (via Sandbox) and database via Xata branches and some “commandments” to follow a developer-like workflow.

Can an AI Agent follow the same workflow that human developers can? We explored giving AI agent access to the database branch, a compute sandbox to execute code and instructions to follow a developer workflow (in plain English) and the experiment was a success.

Sometimes the right fix isn’t a workaround, but going upstream. After 6 months of work, @SferaDev from Xata landed our biggest contribution yet to Keycloak: persistent Organization invitations. Now merged, shipping in 26.5.0 🎉 Full write-up here 👇

Using Neovim with Claude Code? Xata engineer @richardgill.org shares a practical setup to: - See agent-written changes instantly - Reload git diffs in real time - Yank code with file locations so Claude gets proper context 📝 Tips for configuring Neovim for Claude Code xata.io/blog/configu...

pgstream v0.9.0 is live! This release improves schema replication, adds snapshot index progress tracking, supports more cloud providers, introduces reconnection retries, integrates with PostgreSQL Anonymizer and includes memory improvements. Big thanks to our community contributors 💜

Club Xata Rome 2025: our biannual reset. We traded Zoom for a shared table and left with sharper plans + stronger bonds.

Day 1 at #PGConfEU kicked off with Community Summits! Our own Gülçin Yıldırım Jelínek is co-organizing two of them ☸️ PostgreSQL on Kubernetes Summit 🧠 PostgreSQL & AI Summit Big thanks to the volunteers & speakers who made this happen. Community is what makes Postgres great 💙

The countdown to #PGConfEU is on ⏳ On Oct 21, @apatheticmagpie is co-hosting two community summits: 🧠 PostgreSQL & AI with Gulcin on DB Agents ☸️ PostgreSQL on Kubernetes with Esther Minano & Andrew Farries

Branch settings, faster. We reorganized the page and added search. What changed Search to jump directly to a setting. Logical groups with clear labels. Guardrails to reduce misclicks. Why it helps Quicker navigation. Less guessing, safer edits. Want early access? Ping us and we’ll enable it.

See write latency and replica lag before users do. New performance charts surface: WAL sync time → time to flush WAL to disk (disk/flush latency). Replication lag → how far a standby is behind the primary (freshness). Want early access? Ping us and we’ll switch it on for your account.

Project-level default database now live in Xata. Set one default and we point new connection strings, views, and child branches to it by default. Fewer misroutes and accidental writes to secondary DBs; faster onboarding. Set it in Project Settings → Default database. You can override per branch.