What you should know about constraints in PostgreSQL
In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.
By Gulcin Yildirim Jelinek
Closing the loop: Building a coding agent that uses Postgres branches
Explore how to build an AI coding agent that follows a full developer workflow, including creating Postgres branches, using a sandbox, fixing bugs, and raising pull requests with Xata, Vercel, and GitHub.
By Divyendu Singh
How we improved Organization Invites to Keycloak
Many discussions with the Keycloak maintainers and a lot of code reviews later, our biggest contribution to Keycloak to date has been merged
By Alexis Rico
Tips for configuring Neovim for Claude Code
How to setup Neovim to see Claude Code's changes instantly and paste code with file locations back into Claude Code
By Richard Gill
pgstream v0.9.0: Better schema replication, snapshots and cloud support
Bringing connection retries, anonymizer features, memory improvements and solid community input.
By Esther Minano Sanz
The Villa Getaway: Club Xata Rome 2025
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 the same table for a while.
By Natalia Woroniec
Recap of Berlin Postgres Meetup on September 23rd 2025
Takeaways from the Sep 23, 2025 Berlin Postgres Meetup: how Xata Agent (open-source Postgres AI agent) helps manage PostgreSQL at scale, Q&A highlights, lessons.
By Divyendu Singh
Going down the rabbit hole of Postgres 18 features
A comprehensive list of PostgreSQL 18 new features, performance optimizations, operational and observability improvements, and new tools for devs.
By Tudor Golubenco
From natural language to SQL queries: How we built Generate SQL with AI
Discover how Xata used Large Language Models (LLMs) to turn natural language into accurate PostgreSQL queries, simplifying BI workflows and boosting productivity.
By Divyendu Singh
Making Postgres scale to zero with CNPG
How we built activity-aware Postgres clusters that hibernate automatically and save resources
By Esther Minano Sanz
pgstream v0.8.1: hstore transformer, roles snapshotting, CLI improvements and more
Learn how pgstream v0.8.1 transforms hstore data and improves snapshot experience with roles snapshotting and excluded tables option
By Ahmet Gedemenli
From DBA to DB Agents
Discover how a PostgreSQL DBA’s decade of expertise evolved into designing Xata’s AI-powered Postgres agent, automating monitoring and observability.
By Gulcin Yildirim Jelinek
Test on real data. Deploy with confidence.
Keep production where it is. Use Xata for safe, instant dev branches.