Xata - Postgres at Scale
@xata.io
With copy-on-write branching, data masking, separated storage & compute , 100% Postgres
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…
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.
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.
Finally, AI won’t replace DBAs, it scales them.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
October 21, 2025 at 1:38 PM
Finally, AI won’t replace DBAs, it scales them.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
Gülçin's talk at the AI Summit walks through how Xata built the open-source Postgres Agent, powered by LLMs and human-written playbooks.
From pager fatigue to self-healing clusters for a future that’s safer and saner.
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.
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.
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.
October 6, 2025 at 12:30 PM
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.
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.
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.
October 4, 2025 at 5:39 AM
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.
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.
Create a Postgres branch in one screen.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
October 3, 2025 at 12:30 PM
Create a Postgres branch in one screen.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Name it → get the branch → run queries.
No org/project setup first.
Sane defaults now, easy rollback later.
Want early access? Ping us and we’ll enable it.
Preload extensions once, use them everywhere.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
October 2, 2025 at 1:15 PM
Preload extensions once, use them everywhere.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
Set shared_preload_libraries at the branch level and every database on that branch shares the same foundation. Example:
pg_stat_statements, pg_trgm → consistent query stats + text ops across envs.
Notes: applies to all DBs on the branch.
PostgreSQL 18 is supported on Xata.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
September 30, 2025 at 5:15 PM
PostgreSQL 18 is supported on Xata.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Try PG18 in a safe, branch-based workflow:
How to start:
• Clone with anonymization → test on look-alike data.
• Create a PG18 branch → run queries and migrations.
• When ready, promote with pgroll for zero-downtime changes.
Thinking about changing your data model?
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
September 26, 2025 at 2:05 PM
Thinking about changing your data model?
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
View your schema as a table or UML diagram.
When you are ready, use xata roll to apply changes without downtime.
Shipping Text to SQL you can trust isn’t just prompting.
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
September 24, 2025 at 12:28 PM
Shipping Text to SQL you can trust isn’t just prompting.
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
It’s engineering for simplicity.
At Xata we use a tiny context, pass schema + current SQL, a focused system prompt, and the right model per task.
Fewer moving parts, cleaner UX.
Build notes → xata.io/blog/how-we-...
What if your Postgres cluster could hibernate when idle and wake instantly when needed?
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
September 20, 2025 at 5:39 AM
What if your Postgres cluster could hibernate when idle and wake instantly when needed?
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
At Xata, we built exactly that with a CNPG plugin.
→ Cut costs
→ Power ephemeral DBs
→ Open source
Full details: xata.io/blog/making-...
Data exploration is easier with the ability to generate SQL from a simple question.
No need to worry about syntax.
Just dive into the data.
No need to worry about syntax.
Just dive into the data.
September 19, 2025 at 12:15 PM
Data exploration is easier with the ability to generate SQL from a simple question.
No need to worry about syntax.
Just dive into the data.
No need to worry about syntax.
Just dive into the data.
Branch metrics provide insight into CPU, memory, throughput, egress, and more.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
September 18, 2025 at 1:16 PM
Branch metrics provide insight into CPU, memory, throughput, egress, and more.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Use interactive charts to view trends over time or investigate anomalous spikes.
Metrics are stored for up to 60 days at no additional cost.
Have a branch you don’t need running all the time?
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
September 16, 2025 at 12:45 PM
Have a branch you don’t need running all the time?
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Save money by setting scale-to-zero as the default for a project or override it in the branch settings.
Our list of supported extensions is growing every day.
Got any requests?
Got any requests?
September 15, 2025 at 12:31 PM
Our list of supported extensions is growing every day.
Got any requests?
Got any requests?
Xata @ PGDay UK 2025 🐘
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
September 13, 2025 at 5:39 AM
Xata @ PGDay UK 2025 🐘
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
Andrew dove into pgroll, our OSS tool for zero-downtime Postgres schema migrations.
Great Qs from the community: logical replication, multi-schema & more.
Always grateful for the Postgres crowd in London!
You have full control over your branches directly from the console.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
September 11, 2025 at 1:33 PM
You have full control over your branches directly from the console.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Adjust the instance size, add replicas, tune compute settings, and modify your Postgres config.
Tomorrow at @pgdaylowlands.bsky.social 🐘, @apatheticmagpie.bsky.social speaks at 09:40 on "Anatomy of Table-level Locks in PostgreSQL."
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
September 11, 2025 at 9:05 AM
Tomorrow at @pgdaylowlands.bsky.social 🐘, @apatheticmagpie.bsky.social speaks at 09:40 on "Anatomy of Table-level Locks in PostgreSQL."
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
She’s given Postgres talks in a church ⛪, and now in… a zoo! 🦒
And don’t miss tonight’s meetup 👉 meetup.com/postgresql-user-group-nl/events/310728717
In Xata, every branch is a full Postgres instance.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
September 10, 2025 at 3:26 PM
In Xata, every branch is a full Postgres instance.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
Use it as a staging replica with PII automatically obfuscated, a production-ready database, or an ephemeral copy for a quick PR.
Now live: AWS Frankfurt (eu-central-1)
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
September 5, 2025 at 8:54 AM
Now live: AWS Frankfurt (eu-central-1)
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
• Lower latency for EU users
• Full EU data residency
• Competitive, region-specific pricing
Request access today: xata.io/get-access
More details on pricing: xata.io/pricing
If you want to understand Postgres locks beyond the basics, this talk is for you.
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
September 4, 2025 at 8:48 AM
If you want to understand Postgres locks beyond the basics, this talk is for you.
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/
Catch it today at PGDay Austria! 🔒🐘
📍 14:10 – 14:55
📍 Room: Sophie
🗓️ Full schedule: pgday.at/schedule/