Sign in

Xata - Postgres at Scale

@xata.io
62 followers 1 following 206 posts

With copy-on-write branching, data masking, separated storage & compute , 100% Postgres

PostsRepliesMedia
Xata - Postgres at Scale @xata.io · 24/09/2026
The short version: a copy of production per task, ready in seconds with copy-on-write, and a way to get real data into it without the PII. www.wearedevelopers.com/world-congr...
wearedevelopers.com
Databases in the Agent Era · WeAreDevelopers World Congress North America
We are entering a new era where AI agents are first-class users of data infrastructure. These systems don’t behave like traditional applications. They operate in loops, branch workflows continuousl…
000
Xata - Postgres at Scale @xata.io · 24/09/2026
A coding agent wants its own database for every task, created when the work starts and removed when it ends. A shared staging database doesn't survive that for long. Our CEO Monica Sarbu on what to do instead, today 2:50pm PT, Stage 2, WeAreDevelopers San José: "Databases in the Agent Era."
110
Xata - Postgres at Scale @xata.io · 24/09/2026
Live now: Graham walks through Account Observatory, the internal tool our GTM team built on one Postgres database. 30 minutes, then your questions. www.youtube.com/watch?v=9ZH...
youtube.com
AI-native GTM Ops: Account Observatory with Scale-to-Zero Postgres
Xata is a managed Postgres company. Our product lets a team copy a ...
000
Xata - Postgres at Scale @xata.io · 22/09/2026
Our GTM team built an internal tool to stay customer focused as a PLG-first company. Account Observatory pulls PostHog, Pylon and Clarify into one Postgres database. Changes ship from a branch through a pull request. Thu Sep 24, 8:30am PT. Free on YouTube. youtube.com/watch?v=9ZH...
youtube.com
AI-native GTM Ops: Account Observatory with Scale-to-Zero Postgres
Xata is a managed Postgres company. Our product lets a team copy a ...
100
Xata - Postgres at Scale @xata.io · 27/08/2026
Setup for Codex, ChatGPT and the other supported clients: xata.io/docs/platfor... The server URL is api.xata.tech/mcp
xata.io
MCP Server - Xata
Connect Cursor, Claude, VS Code, and other MCP clients to Xata
010
Xata - Postgres at Scale @xata.io · 27/08/2026
Need production data to debug a slow query? Normally, you'd have to isolate & validate data & deploy the fix. With the Xata MCP server and Codex, you just talk to an agent. Branch your Postgres database in seconds regardless of the size and let AI do the debugging. Watch 👇
100
Xata - Postgres at Scale @xata.io · 26/08/2026
You only need the URL. Nothing to install locally, and any client that speaks Streamable HTTP can connect. claude mcp add --transport http --scope user xata api.xata.tech/mcp then /mcp to sign in. Setup for every supported client: xata.io/docs/platfor...
000
Xata - Postgres at Scale @xata.io · 26/08/2026
Coding agents write and run SQL now. The same connection that lets one fix a query lets it drop a table. The Xata MCP server gives it a branch instead: the agent creates it, works in it against real data, deletes it when the run ends. xata.io/blog/introdu...
230
Xata - Postgres at Scale @xata.io · 20/08/2026
Xata is coming to Azure. Branch-native Postgres. A copy-on-write branch of an existing database in seconds, whether the parent is 1GB or 1TB. Xata branches only incur costs for changed data plus compute while awake. A sleeping branch is basically free. Join the waitlist: xata.io/get/azure
010
Xata - Postgres at Scale @xata.io · 11/08/2026
pgp_sym_decrypt with the wrong key throws "Wrong key or corrupt data". No garbage bytes returned. The PGP integrity check earns its keep when every tenant holds a different key: the wrong key fails the query instead of quietly returning nonsense. Read about it here: xata.io/blog/multi-t...
000
Xata - Postgres at Scale @xata.io · 31/07/2026
Query Insights is live in the console too, on every branch, with any statement whose slowest run passed one second highlighted. A walkthrough that goes from a slow query in the console to the statement in your terminal: xata.io/docs/tutorials/find-slow-queries
xata.io
Find and fix slow queries on a Xata branch - Xata
Use query insights, branch logs, and instance metrics to find slow PostgreSQL queries, understand why they are slow, and confirm the fix worked.
000
Xata - Postgres at Scale @xata.io · 31/07/2026
xata branch query-insights active reads pg_stat_activity, so it shows what is executing right now, with each query's state and wait event. Currently running queries are the one part of this with no console page.
100
Xata - Postgres at Scale @xata.io · 31/07/2026
Finding a slow query on a Postgres branch, without leaving the terminal. xata branch query-insights ranks that branch's statements by cost, flags the slow ones, and prints the command to inspect any of them. Logs and instance metrics are one command away.
100
Xata - Postgres at Scale @xata.io · 23/07/2026
If every agent and PR gets its own Postgres branch, you're scripting those, not clicking them. So the CLI output has to be parseable. Now it is: piped output is clean plain text, xata branch list --json for anything automated. Boring, but that's the point at scale.
000
Xata - Postgres at Scale @xata.io · 17/07/2026
Full write-up here: xata.io/blog/the-ins...
xata.io
The instant database scratchpad: xata scratch by Divyendu Singh
Written by Divyendu Singh
010
Xata - Postgres at Scale @xata.io · 17/07/2026
2TB+ Postgres. Branch it in seconds, query it, delete it. xata scratch (new Xata CLI cmd) forks a disposable branch off your real DB, drops you into psql or runs SQL inline, tears it down on exit. Demo 👇
120
Xata - Postgres at Scale @xata.io · 10/07/2026
pgstream v1.1.1: the replication path now binds and escapes identifiers, slot names, and plugin options, so a crafted name can't break out onto the target. Backported to v0.9.15. Plus wider snapshot restore coverage. github.com/xataio/pgstr...
000
Xata - Postgres at Scale @xata.io · 08/07/2026
The Xata GitHub App is available today. Install it, connect a repo, and open a test PR: xata.io/blog/introdu...
000
Xata - Postgres at Scale @xata.io · 08/07/2026
Branch-per-PR is the starting point. The same mechanism works for every developer, every QA environment, and every agent that opens a PR. And agents open a lot of PRs.
100
Xata - Postgres at Scale @xata.io · 08/07/2026
Install once and map your repos. Every PR gets its branch created and deleted for you, the same lifecycle every time. Leave a PR open for weeks and it scales to zero, so the bill doesn't.
100
Xata - Postgres at Scale @xata.io · 08/07/2026
The app watches your PRs. When one opens, it creates a copy-on-write branch off main, mirroring production. Same branch name in GitHub and Xata, so your GitHub Action runs against it and reports back on real data, not an empty seed.
100
Xata - Postgres at Scale @xata.io · 08/07/2026
Some things a seed database can't catch. Access rules, permissions, anything whose behavior depends on real data: it passes on empty rows, then behaves differently in prod. Standing up a real copy to test against is slow and expensive, so nobody makes one per PR.
100
Xata - Postgres at Scale @xata.io · 08/07/2026
Introducing the Xata GitHub App. Connect a repo to your Xata project and every pull request gets its own isolated Postgres branch off main, with production-like data, ready in seconds when the PR opens and gone when it closes.
110
Xata - Postgres at Scale @xata.io · 30/06/2026
A Postgres for every job, now on Google Cloud. Add your card and run free until September 13. xata.io/get/gcp
xata.io
Xata on GCP
Create isolated, copy-on-write Postgres branches in seconds for every pull request, CI run, and AI agent on Google Cloud.
000
Xata - Postgres at Scale @xata.io · 30/06/2026
Built for instant Postgres branching: - branch in 3s from your full database, copy-on-write - branch from production with sensitive fields masked - scale-to-zero: idle branches stop, wake on demand - live in us-central1 (Iowa), more regions coming
100
Xata - Postgres at Scale @xata.io · 30/06/2026
AI application builders Provision a new Postgres database in a second for every generated app. Give every app its own dedicated database from day one.
100
Xata - Postgres at Scale @xata.io · 30/06/2026
Deployment previews & CI Create a fresh Postgres branch in 3 seconds for every pull request and test run. Review every change against production-like data.
100
Xata - Postgres at Scale @xata.io · 30/06/2026
Coding agents Give every coding agent its own isolated Postgres branch in 3 seconds. Build, test, and validate changes against production-like data.
100
Xata - Postgres at Scale @xata.io · 30/06/2026
Xata is now on Google Cloud. Spin up an isolated Postgres branch from your production data in 3 seconds, in-region in us-central1 (Iowa). Every coding agent, PR, and CI run gets its own production-like database. No shared staging, no migration.
111
Xata - Postgres at Scale @xata.io · 26/06/2026
New Xata region: AWS us-west-2 is live. West coast agents and CI can now run their Postgres branches next to their compute. Same instant branching, scale-to-zero, and pricing as us-east-1. xata.io/docs/changelog#aws-us-west-2-region-support
000
Reposted by Xata - Postgres at Scale
Tudor Golubenco @tudor.golubenco.org · 25/06/2026
Very proud that we are be able to sponsor pgBackRest and therefore help with the continuing maintenance of the project. It's rock solid and fast, the properties you want from the backup solution. It's the safety net we offer to all @xata.io customers.
linkedin.com
Very proud that we are be able to sponsor pgBackRest, and therefore help with the continuing maintenance of the project. It's rock solid and fast, the properties you want from the backup solution...
Very proud that we are be able to sponsor pgBackRest, and therefore help with the continuing maintenance of the project. It's rock solid and fast, the properties you want from the backup solution. It...
031
Xata - Postgres at Scale @xata.io · 25/06/2026
The open-source Postgres projects we build, contribute to, and fund: xata.io/open-source
xata.io
Open Source | Xata
Open source PostgreSQL tools by Xata. Zero-downtime migrations with pgroll, CDC replication with pgstream and the full Xata branching engine. All Apache 2.0.
000
Xata - Postgres at Scale @xata.io · 25/06/2026
And we give back in code, not just funding. Keycloak is our authentication layer. We contributed full management for organization invitations to it, our upstream contribution shipped in Keycloak 26.5.0.
100
Xata - Postgres at Scale @xata.io · 25/06/2026
We also sponsor Drizzle. It's a TypeScript-first ORM that works with Xata out of the box, because we run vanilla Postgres. We back the project to support that integration and the developers who use it.
110
Xata - Postgres at Scale @xata.io · 25/06/2026
pgBackRest nearly went unmaintained, and now runs on a coalition of sponsors. Thanks to David Steele for keeping it going.
100
Xata - Postgres at Scale @xata.io · 25/06/2026
That makes the open source ecosystem our infrastructure too, so we help keep it healthy, with code and with funding. pgBackRest is our preferred backup solution and the backup engine for new branches on Xata.
100
Xata - Postgres at Scale @xata.io · 25/06/2026
We run 100% vanilla Postgres. No fork, no modifications. A deliberate decision from day one to build a platform around Postgres, with branching at the storage layer instead of inside the database. This means the whole Postgres ecosystem just works with Xata.
101
Xata - Postgres at Scale @xata.io · 18/06/2026
More in the blog: - Slide to Now keeps your time window in place on refresh - Detail panel: raw entry, JSON, prev/next - xata branch logs -f to tail a deploy live xata.io/blog/branch-...
xata.io
Branch Logs: PostgreSQL observability, right in the console by Marcello Novelli
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.
000
Xata - Postgres at Scale @xata.io · 18/06/2026
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.
231
Reposted by Xata - Postgres at Scale
Xata - Postgres at Scale @xata.io · 17/06/2026
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:
131
Xata - Postgres at Scale @xata.io · 17/06/2026
Parallel aggregation with no GROUP BY, plus faster codec decode. Apache 2.0, PG 17/18: github.com/xataio/delta... v0.2.1 also includes our first outside contribution: a new maintenance-worker GUC from Will Ezell (CTO of dotCMS).
github.com
Release v0.2.1 · xataio/deltax
What's Changed Codec decode optimizations by @tsg in #19 join-query performance: planner stats for compressed partitions by @tsg in #22 Improvements to planner stats by @tsg in #23 Fix ProcessUtil...
010
Xata - Postgres at Scale @xata.io · 17/06/2026
Planner statistics for compressed partitions: DeltaX now builds histograms, MCV lists, and distinct-value estimates for its columnar segments, so the planner picks the right plan for joins and multi-table queries on compressed data.
110
Xata - Postgres at Scale @xata.io · 17/06/2026
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:
131
Xata - Postgres at Scale @xata.io · 16/06/2026
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...
xata.io
pgstream v1.1.0: running Postgres replication as a service by Noémi Ványi
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.
020
Xata - Postgres at Scale @xata.io · 11/06/2026
1000 pure vanilla Postgres databases for $1. No fork, no proprietary APIs, every extension already works. You can get started for free at xata.io. The full write-up: xata.io/blog/a-thous...
xata.io
Xata – One Postgres, thousands of branches.
Instant branches of your Postgres with anonymized production data. No more slow, expensive staging replicas. Ship faster with confidence.
010
Xata - Postgres at Scale @xata.io · 11/06/2026
With Xata, you are only billed for the minutes a branch is awake, and you only pay for your data once. Copies are free thanks to Copy-on-Write. A branch awake for just five minutes on a xata.micro costs $0.001.
110
Xata - Postgres at Scale @xata.io · 11/06/2026
Runner AI opens 30-40 PRs a day, each getting an isolated branch. Enginy.ai branches on every agent run and every CI build, averaging more than 270 branches per team member. Each branch is full Postgres, isolating agents from Prod.
enginy.ai
IA para prospección B2B | Enginy (antes como Genesy)
From finding prospects to booking meetings. Enginy is the AI-native sales platform that automates prospecting and outreach for faster pipeline growth.
100
Xata - Postgres at Scale @xata.io · 11/06/2026
This makes branches truly ephemeral. Cloning a big Postgres for every test or agent run is slow and expensive, so teams share one staging database. Now every PR, CI job, and agent task gets its own isolated Postgres. If it goes sideways, delete and start again.
100
Xata - Postgres at Scale @xata.io · 11/06/2026
Two new pieces of the Xata platform: the Xatastor storage engine and warm compute pools. Xatastor separates compute from storage, so a branch is copy-on-write: it shares the parent's data and stores only its changes. Warm pools keep clusters ready, so a branch is up in about a second.
100
Xata - Postgres at Scale @xata.io · 11/06/2026
Introducing the latest in Postgres for agentic workloads. Agents can now branch or wake your Postgres database instantly.
111