Xata - Postgres at Scale
@xata.io
With copy-on-write branching, data masking, separated storage & compute , 100% Postgres
Pinned
Xata - Postgres at Scale
@xata.io
· May 14
Xata: Postgres with data branching and PII anonymization | xata
Relaunching Xata as "Postgres at scale". A Postgres platform with Copy-on-Write branching, data masking, and separation of storage from compute.
xata.io
📣 We have a brand new Postgres platform with:
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
It’s for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in 🧵
Instant Copy-on-Write branching
Built-in data anonymization
Separation of storage and compute
100% vanilla Postgres
It’s for staging/dev environments as well as for production workloads.
Blog post: xata.io/blog/xata-po...
And more details in 🧵
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...
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...
pgstream v1.0.0: Stateless schema change replication by Esther Minano Sanz
A major architectural milestone that removes schema logs and simplifies how pgstream captures and replicates Postgres schema changes
xata.io
February 4, 2026 at 4:00 PM
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...
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 👌
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 👌
What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
xata.io
January 29, 2026 at 5:23 PM
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 👌
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 👌
Reposted by Xata - Postgres at Scale
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👇🏽
Read how we solved it👇🏽
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...
We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments.
Check the post 👇
xata.io/blog/postgre...
Optimizing data throughput for Postgres snapshots with batch size auto-tuning by Esther Minano Sanz
Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.
xata.io
January 12, 2026 at 3:18 PM
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👇🏽
Read how we solved it👇🏽
Reposted by Xata - Postgres at Scale
@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 👀 👇🏽
The blog posts are paired with demo videos, have a look 👀 👇🏽
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:
Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix.
Video + write-up:
Database branching in the age of AI: One markdown file is all you need by Divyendu Singh
Learn how to enable database branching for coding agents like Claude Code and Amp Code using simple Xata CLI instructions in AGENTS.md. No complex skills required.
xata.io
January 14, 2026 at 1:41 PM
@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 👀 👇🏽
The blog posts are paired with demo videos, have a look 👀 👇🏽
Reposted by Xata - Postgres at Scale
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...
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...
January 19, 2026 at 3:40 PM
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...
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...
January 19, 2026 at 2:00 PM
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...
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:
Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix.
Video + write-up:
Database branching in the age of AI: One markdown file is all you need by Divyendu Singh
Learn how to enable database branching for coding agents like Claude Code and Amp Code using simple Xata CLI instructions in AGENTS.md. No complex skills required.
xata.io
January 14, 2026 at 1:38 PM
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:
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...
We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments.
Check the post 👇
xata.io/blog/postgre...
Optimizing data throughput for Postgres snapshots with batch size auto-tuning by Esther Minano Sanz
Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.
xata.io
January 12, 2026 at 2:35 PM
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...
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`!).
In Postgres 18, even NOT NULL constraints now get their own entries here (before 18 they lived in `pg_attribute`!).
January 8, 2026 at 1:43 PM
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`!).
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 👇
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 👇
Modernize Database Workflows Without a Migration. Branch Postgres by Claudiu Dascalescu
Modernize dev workflows: replace your shared, fragile staging database with instant branches for your Postgres database.
xata.io
December 23, 2025 at 6:15 PM
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 👇
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…
December 20, 2025 at 6:39 AM
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 👇
But some bugs *need* real data to reproduce.
Here’s how we teach Claude to debug safely using Xata database branches 👇
December 17, 2025 at 4:55 PM
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 👇
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.
December 12, 2025 at 5:04 PM
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.
This shows how you can use the “scale to zero” feature of the Xata platform to improve feature development while keeping costs in check.
December 12, 2025 at 12:12 PM
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.
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...
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...
What you should know about constraints in PostgreSQL | xata.io by Gulcin Yildirim Jelinek
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
xata.io
December 11, 2025 at 3:19 PM
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...
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.
Here we experiment with giving AI agent tools to change environment variables in a repository that it checked out and it worked.
December 10, 2025 at 9:28 AM
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.
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.
December 9, 2025 at 1:42 PM
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.
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.
December 8, 2025 at 1:48 PM
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.
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 👇
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 👇
How we improved Organization Invites to Keycloak | xata.io by Alexis Rico
Many discussions with the Keycloak maintainers and a lot of code reviews later, our biggest contribution to Keycloak to date has been merged
xata.io
December 2, 2025 at 1:45 PM
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 👇
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...
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...
December 1, 2025 at 4:53 PM
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...
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 💜
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 💜
November 26, 2025 at 12:31 PM
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 💜
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.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
The Villa Getaway: Club Xata Rome 2025 by Natalia Woroniec
Somewhere between a team retreat and a family holiday, our week in Rome was about connection, ideas, and joy of being in one place together. A reminder of what can happen when the whole team shares…
xata.io
October 31, 2025 at 1:36 PM
Club Xata Rome 2025: our biannual reset.
We traded Zoom for a shared table and left with sharper plans + stronger bonds.
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 💙
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 💙
October 21, 2025 at 1:38 PM
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 💙
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
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
PGConf.EU 2025 Schedule
PGConf.EU 2025 Schedule
www.postgresql.eu
October 17, 2025 at 3:38 PM
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
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.
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.
October 8, 2025 at 12:30 PM
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.
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.