corpus.blog
41554 blogs · [ { "id": "01a0821a-31af-72b9-83c2-4bb0d5490f7f", "title": "Introducing the Xata MCP server 2.0", "url": "https://xata.io/blog/introducing-the-xata-mcp-server", "published_at": "2026-08-26T12:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d5a1a941", "title": "Multi-tenant BYOK encryption in PostgreSQL with pgcrypto", "url": "https://xata.io/blog/multi-tenant-byok-encryption-in-postgresql-with-pgcrypto", "published_at": "2026-08-11T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d67df665", "title": "The instant database scratchpad: xata scratch", "url": "https://xata.io/blog/the-instant-database-scratchpad-xata-scratch", "published_at": "2026-07-17T13:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d6aef894", "title": "Introducing the Xata GitHub App", "url": "https://xata.io/blog/introducing-the-xata-github-app", "published_at": "2026-07-08T15:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d77e9a6e", "title": "PostgreSQL as a temporal database", "url": "https://xata.io/blog/postgres-as-a-temporal-db", "published_at": "2026-06-30T16:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d7b01b30", "title": "Branch Logs: PostgreSQL observability, right in the console", "url": "https://xata.io/blog/branch-logs-postgresql-observability-right-in-the-console", "published_at": "2026-06-18T11:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d83f8ac9", "title": "pgstream v1.1.0: Steps towards turning it into a service", "url": "https://xata.io/blog/pgstream-v110-steps-towards-turning-it-into-a-service", "published_at": "2026-06-16T17:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d8961b00", "title": "A thousand Postgres branches for $1", "url": "https://xata.io/blog/a-thousand-postgres-branches-for-1", "published_at": "2026-06-11T16:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d8fa7e7a", "title": "Query Editor v2: A Better Way to Write SQL in Xata Console", "url": "https://xata.io/blog/query-editor-v2-a-better-way-to-write-sql-in-xata-console", "published_at": "2026-06-04T13:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d9a045ca", "title": "How we rebuilt PostgreSQL branch metrics on VictoriaMetrics, per cell", "url": "https://xata.io/blog/how-we-rebuilt-postgresql-branch-metrics-on-victoriametrics-per-cell", "published_at": "2026-06-02T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0d9ca2494", "title": "Building production AI apps with Xata and Claude Code", "url": "https://xata.io/blog/building-production-ai-apps-with-xata-and-claude-code", "published_at": "2026-05-27T15:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0da3331bf", "title": "A connection pooler for every Postgres branch, scaling to zero instances with it", "url": "https://xata.io/blog/a-connection-pooler-for-every-postgres-branch", "published_at": "2026-05-07T12:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0dade19cb", "title": "Inside Xatastor: ZFS + NVMe-oF for millions of Postgres databases", "url": "https://xata.io/blog/xatastor-zfs-nvme-of-for-millions-of-postgres-databases", "published_at": "2026-04-30T16:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0db216a28", "title": "AI codes. Humans engineer", "url": "https://xata.io/blog/ai-codes-humans-engineer", "published_at": "2026-04-26T23:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0db947f06", "title": "Code Review for Vibe Coders", "url": "https://xata.io/blog/code-review-for-vibe-coders", "published_at": "2026-04-23T14:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0dc898874", "title": "The Rural Reset: Club Xata France 2026", "url": "https://xata.io/blog/club-xata-france-2026", "published_at": "2026-04-20T11:26:33+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0dd895f02", "title": "What if database branching was easy?", "url": "https://xata.io/blog/what-if-database-branching-was-easy", "published_at": "2026-04-16T14:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0de585cb6", "title": "Xata is now open source", "url": "https://xata.io/blog/xata-is-now-open-source", "published_at": "2026-04-15T13:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0de5c6ac1", "title": "Introducing Xata OSS: Postgres platform with branching, now Apache 2.0", "url": "https://xata.io/blog/open-source-postgres-branching-copy-on-write", "published_at": "2026-04-15T12:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0de9506b3", "title": "The missing layer in LLM knowledge bases", "url": "https://xata.io/blog/llm-knowledge-bases", "published_at": "2026-04-06T21:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0debb0d5f", "title": "Every AI agent needs a database it can break", "url": "https://xata.io/blog/every-ai-agent-needs-a-database-it-can-break", "published_at": "2026-03-23T22:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0dec5b3df", "title": "We skipped the OLAP stack and built our data warehouse in vanilla Postgres", "url": "https://xata.io/blog/postgres-data-warehouse", "published_at": "2026-03-17T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0dfc40fdb", "title": "My git-worktree setup using worktrunk and caddy", "url": "https://xata.io/blog/my-git-worktree-setup-using-worktrunk-and-caddy", "published_at": "2026-02-25T11:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e067e6bd", "title": "The 5 Best Data Anonymization Tools for Development Teams in 2026", "url": "https://xata.io/blog/the-5-best-data-anonymization-tools-for-development-teams-in-2026", "published_at": "2026-02-25T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e1053444", "title": "Data Pseudonymization Explained: When Anonymization Isn't Enough", "url": "https://xata.io/blog/data-pseudonymization-explained-when-anonymization-isnt-enough", "published_at": "2026-02-17T19:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e16ea61d", "title": "Skim-review is the new normal. Your data workflow has to catch up", "url": "https://xata.io/blog/skim-review-is-the-new-normal-your-data-workflow-has-to-catch-up", "published_at": "2026-02-13T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e1e5b8db", "title": "Dynamic Data Masking: Use Cases, Limitations, and Going Beyond", "url": "https://xata.io/blog/dynamic-data-masking-use-cases-limitations-and-going-beyond", "published_at": "2026-02-12T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e210055e", "title": "Is Postgres really enough in 2026?", "url": "https://xata.io/blog/is-postgres-really-enough-in-2026", "published_at": "2026-02-10T23:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e2d9d35e", "title": "Introducing the xata CLI container image: Automate your database workflows in Kubernetes", "url": "https://xata.io/blog/introducing-the-xata-cli-container-image-automate-your-database-workflows-in-kubernetes", "published_at": "2026-02-05T17:01:38+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e3b6d34b", "title": "What is database branching? A complete guide for development teams", "url": "https://xata.io/blog/what-is-database-branching-a-complete-guide-for-development-teams", "published_at": "2026-02-05T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e3d6829a", "title": "pgstream v1.0.0: Stateless schema change replication", "url": "https://xata.io/blog/pgstream-v100-stateless-schema-change-replication", "published_at": "2026-02-04T15:58:34+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e4369927", "title": "Secure by design: Data masking, obfuscation, and pseudonymization for engineering teams", "url": "https://xata.io/blog/secure-by-design-data-masking-obfuscation-and-pseudonymization-for-engineering-teams", "published_at": "2026-01-29T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e46ae788", "title": "Pseudonymization vs. Anonymization: Which approach fits your data strategy?", "url": "https://xata.io/blog/pseudonymization-vs-anonymization-which-approach-fits-your-data-strategy", "published_at": "2026-01-28T18:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e52f972f", "title": "Xata acquires Privacy Dynamics for advanced anonymization", "url": "https://xata.io/blog/xata-acquires-privacy-dynamics", "published_at": "2026-01-26T21:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e5dbeedb", "title": "Anonymization: The missing link in dev workflows", "url": "https://xata.io/blog/anonymization-the-missing-link-in-dev-workflows", "published_at": "2026-01-22T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e5f69d21", "title": "Introducing AI-assisted PII removal for safer staging", "url": "https://xata.io/blog/smarter-safer-staging-introducing-ai-assisted-pii-removal", "published_at": "2026-01-18T22:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e6928711", "title": "Database branching for AI coding agents: a minimal, CLI-first setup that actually works", "url": "https://xata.io/blog/database-branching-for-ai-coding-agents", "published_at": "2026-01-14T08:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e722d7f1", "title": "Optimizing data throughput for Postgres snapshots with batch size auto-tuning", "url": "https://xata.io/blog/postgres-snapshots-with-batch-size-auto-tuning", "published_at": "2026-01-12T14:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e74b5236", "title": "Modernize your database workflows without a migration (code with real data)", "url": "https://xata.io/blog/modernize-database-workflows-without-migration", "published_at": "2025-12-22T11:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e7ad6a44", "title": "Teaching Claude Code to use isolated database branches with Agent Skills", "url": "https://xata.io/blog/teaching-claude-code-to-use-isolated-database-branches-with-agent-skills", "published_at": "2025-12-17T14:21:12+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e85aab74", "title": "What you should know about constraints in PostgreSQL", "url": "https://xata.io/blog/constraints-in-postgres", "published_at": "2025-12-10T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e85d6557", "title": "Closing the loop: Building a coding agent that uses Postgres branches", "url": "https://xata.io/blog/a-coding-agent-that-uses-postgres-branches", "published_at": "2025-12-08T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0e953faf7", "title": "How we improved Organization Invites to Keycloak", "url": "https://xata.io/blog/how-we-improved-organization-invites-to-keycloak", "published_at": "2025-12-02T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ea130520", "title": "Tips for configuring Neovim for Claude Code", "url": "https://xata.io/blog/configuring-neovim-coding-agents", "published_at": "2025-12-01T11:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ea7a4636", "title": "pgstream v0.9.0: Better schema replication, snapshots and cloud support", "url": "https://xata.io/blog/pgstream-v090-better-schema-replication-snapshots-and-cloud-support", "published_at": "2025-11-26T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0eafdc097", "title": "The Villa Getaway: Club Xata Rome 2025", "url": "https://xata.io/blog/club-xata-rome-2025", "published_at": "2025-10-23T13:51:16+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ebf2393e", "title": "Recap of Berlin Postgres Meetup on September 23rd 2025", "url": "https://xata.io/blog/recap-of-berlin-postgres-meetup-on-september-23rd-2025", "published_at": "2025-10-02T13:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ec1c0baa", "title": "Going down the rabbit hole of Postgres 18 features", "url": "https://xata.io/blog/going-down-the-rabbit-hole-of-postgres-18-features", "published_at": "2025-09-29T07:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ec73c27b", "title": "From natural language to SQL queries: How we built Generate SQL with AI", "url": "https://xata.io/blog/how-we-built-generate-sql-with-ai", "published_at": "2025-09-18T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ecdb39c8", "title": "Making Postgres scale to zero with CNPG", "url": "https://xata.io/blog/making-postgres-scale-to-zero-with-cnpg", "published_at": "2025-09-17T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0eceff1f0", "title": "pgstream v0.8.1: hstore transformer, roles snapshotting, CLI improvements and more", "url": "https://xata.io/blog/pgstream-v081-update", "published_at": "2025-09-15T06:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ede89d49", "title": "From DBA to DB Agents", "url": "https://xata.io/blog/dba-to-db-agent", "published_at": "2025-09-03T15:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ee8c6d5b", "title": "PGConf.EU Community Events Day: CfPs closing soon", "url": "https://xata.io/blog/pgconfeu-community-events-day-cfps-closing-soon", "published_at": "2025-08-29T18:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ef4f2485", "title": "Postgres in Malmö: Powered by Elly Phneah", "url": "https://xata.io/blog/postgres-in-malmo", "published_at": "2025-08-08T10:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f0204411", "title": "Zero Downtime Schema Changes with Vercel and Xata", "url": "https://xata.io/blog/zero-downtime-schema-changes-with-vercel-and-xata", "published_at": "2025-07-24T15:10:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f03382df", "title": "pgroll is on a roll! We hit 5k stars on Github", "url": "https://xata.io/blog/pgroll-5k-stars-on-github", "published_at": "2025-07-18T14:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f0a9e88c", "title": "Reaction to the PlanetScale PostgreSQL benchmarks", "url": "https://xata.io/blog/reaction-to-the-planetscale-postgresql-benchmarks", "published_at": "2025-07-16T16:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f0ea482d", "title": "pgroll 0.14 - New commands and more control over version schemas", "url": "https://xata.io/blog/pgroll-0-14-0-update", "published_at": "2025-07-04T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f17ff475", "title": "Behind the scenes: Speeding up pgstream snapshots for PostgreSQL", "url": "https://xata.io/blog/behind-the-scenes-speeding-up-pgstream-snapshots-for-postgresql", "published_at": "2025-07-01T10:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f25904d9", "title": "PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 2", "url": "https://xata.io/blog/neon-vs-supabase-vs-xata-postgres-branching-part-2", "published_at": "2025-06-25T15:54:51+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f2c36b79", "title": "pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshots", "url": "https://xata.io/blog/pgstream-v071-update", "published_at": "2025-06-20T13:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f3bd3212", "title": "Neon vs Supabase vs Xata: Postgres Branching Compared", "url": "https://xata.io/blog/neon-vs-supabase-vs-xata-postgres-branching-part-1", "published_at": "2025-06-09T14:33:29+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f42276d3", "title": "pgstream v0.6.0: Template transformers, observability, and performance improvements", "url": "https://xata.io/blog/pgstream-v060-update", "published_at": "2025-05-29T13:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f4737d62", "title": "pgroll v0.13.0: Start using pgroll on existing databases with the new baseline feature", "url": "https://xata.io/blog/pgroll-0-13-0-update", "published_at": "2025-05-27T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f4db4073", "title": "Xata Agent v0.3.1: Custom tools via MCP, Ollama integration, support for reasoning models & more", "url": "https://xata.io/blog/xata-agent-v031", "published_at": "2025-05-21T12:30:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f5d06f73", "title": "From OpenAPI Spec to MCP Server: A Practical Guide with Kubb and Next.js", "url": "https://xata.io/blog/built-xata-mcp-server", "published_at": "2025-05-20T22:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f6672895", "title": "pgstream v0.5.0: New transformers, YAML configuration, CLI refactoring & table filtering", "url": "https://xata.io/blog/pgstream-v050-update", "published_at": "2025-05-20T12:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f7169e3e", "title": "Highlights from PGConf.DE 2025", "url": "https://xata.io/blog/highlights-from-pgconfde-2025", "published_at": "2025-05-20T09:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f7be3e3b", "title": "Off the grid, on the same page - Club Xata Iceland 2025", "url": "https://xata.io/blog/club-xata-iceland-2025", "published_at": "2025-05-15T11:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f883bd21", "title": "Xata: Postgres with data branching and PII anonymization", "url": "https://xata.io/blog/xata-postgres-with-data-branching-and-pii-anonymization", "published_at": "2025-05-14T11:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f91871db", "title": "pgroll v0.12.0: create command, verbose mode & idempotent migrate command", "url": "https://xata.io/blog/pgroll-v0120-update", "published_at": "2025-05-09T13:57:22+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0f951edcc", "title": "Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & more", "url": "https://xata.io/blog/postgres-agent-0-2-0-update", "published_at": "2025-04-16T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fa11b018", "title": "pgroll v0.11.0: YAML migration support, pgroll.migration table improvements & more", "url": "https://xata.io/blog/pgroll-0-11-0-update", "published_at": "2025-04-08T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fa69df6f", "title": "Writing an LLM Eval with Vercel's AI SDK and Vitest", "url": "https://xata.io/blog/llm-evals-with-vercel-ai-and-vitest", "published_at": "2025-04-02T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fadedaf9", "title": "pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformations", "url": "https://xata.io/blog/pgstream-0-4-0-update", "published_at": "2025-03-27T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fb2332e1", "title": "Are AI agents the future of observability?", "url": "https://xata.io/blog/are-ai-agents-the-future-of-observability", "published_at": "2025-03-25T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fb4c9c51", "title": "pgroll 0.10.0 update", "url": "https://xata.io/blog/pgroll-0-10-0-update", "published_at": "2025-02-28T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fb71b9ad", "title": "Postgres Cafe: Building PostgreSQL extensions in Zig using pgzx", "url": "https://xata.io/blog/postgres-cafe-pgzx", "published_at": "2025-02-12T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fc5108ca", "title": "pgroll 0.9.0 update", "url": "https://xata.io/blog/pgroll-0-9-0-update", "published_at": "2025-02-10T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fca03bb6", "title": "Anatomy of table-level locks: Reducing locking impact", "url": "https://xata.io/blog/anatomy-of-locks-reduce", "published_at": "2025-01-20T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fd023293", "title": "Postgres Cafe: Solving schema replication gaps with pgstream", "url": "https://xata.io/blog/postgres-cafe-pgstream", "published_at": "2025-01-15T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fd7e86f3", "title": "Anatomy of Table-Level Locks in PostgreSQL", "url": "https://xata.io/blog/anatomy-of-locks", "published_at": "2025-01-13T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fdec6788", "title": "Postgres Cafe: Exploring pgroll for zero-downtime schema changes", "url": "https://xata.io/blog/postgres-cafe-pgroll", "published_at": "2024-12-18T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fe773f8f", "title": "pgroll v0.8.0: Support for multi-column primary keys, multi-column constraints & new CLI commands", "url": "https://xata.io/blog/pgroll-0-8-0-update", "published_at": "2024-12-09T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ff0a5a7e", "title": "Is pg_dump a backup tool?", "url": "https://xata.io/blog/postgresfm", "published_at": "2024-12-05T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ff12785c", "title": "Changes to the Xata free plan", "url": "https://xata.io/blog/changes-free-tier", "published_at": "2024-12-04T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ff93a0ab", "title": "Maintaining Postgres for Modern Workloads", "url": "https://xata.io/blog/maintainable-postgres-podcast", "published_at": "2024-11-27T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0ffeb07c7", "title": "Prague PostgreSQL Meetup on November 18th", "url": "https://xata.io/blog/prague-postgres-meetup-november-2024", "published_at": "2024-11-17T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb0fff42aaf", "title": "Recap of PGConf.EU 2024 in Athens", "url": "https://xata.io/blog/pgconfeu-recap-2024", "published_at": "2024-11-15T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb100699f7e", "title": "Schema changes and the power of expand-contract with pgroll", "url": "https://xata.io/blog/pgroll-expand-contract", "published_at": "2024-11-13T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb1007c7a63", "title": "Prague PostgreSQL Meetup on October 29th", "url": "https://xata.io/blog/prague-postgres-meetup-october-2024", "published_at": "2024-10-28T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb100a003f1", "title": "pgroll 0.7.0 update", "url": "https://xata.io/blog/pgroll-0-7-0-update", "published_at": "2024-10-23T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb101941ea7", "title": "What I look forward to at PGConf.EU in Athens", "url": "https://xata.io/blog/pgconfeu-2024", "published_at": "2024-10-21T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb1020a2788", "title": "Trackstack improves query performance by 67% with Xata", "url": "https://xata.io/blog/case-study-trackstack", "published_at": "2024-10-16T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb1027af7df", "title": "Recap of OSS Vienna: What is Happening in the Open Source World", "url": "https://xata.io/blog/oss-vienna-recap", "published_at": "2024-10-04T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb10317466f", "title": "Prague PostgreSQL Meetup on September 30th", "url": "https://xata.io/blog/prague-postgres-meetup-september-2024", "published_at": "2024-09-25T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb10323ccdc", "title": "HydroPro Solutions achieves a 60% reduction in search time using the Xata Postgres-powered platform", "url": "https://xata.io/blog/case-study-hydropro-solutions", "published_at": "2024-09-19T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb1038b042b", "title": "Meet Xata at PGConf NYC 2024", "url": "https://xata.io/blog/pgconf-nyc2024", "published_at": "2024-09-17T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb10465ea6f", "title": "Savas Labs saves 60+ hours in development time with Xata's Serverless Postgres", "url": "https://xata.io/blog/case-study-savas-labs", "published_at": "2024-09-05T00:00:00+00:00" }, { "id": "01a0821a-31af-72b9-83c2-4bb10554b319", "title": "Postgres Happy Hour with Xata at Open Source Summit Europe", "url": "https://xata.io/blog/oss-vienna-happy-hour", "published_at": "2024-09-03T00:00:00+00:00" } ] posts Claim your blog
Back to Xata Blog
Blog · corpus.blog/blogs/xata.io/posts

Xata Blog

xata.io

2026

Introducing the Xata MCP server 2.0original ↗
26 Aug 2026
Multi-tenant BYOK encryption in PostgreSQL with pgcryptooriginal ↗
11 Aug 2026
The instant database scratchpad: xata scratchoriginal ↗
17 Jul 2026
Introducing the Xata GitHub Apporiginal ↗
8 Jul 2026
PostgreSQL as a temporal databaseoriginal ↗
30 Jun 2026
Branch Logs: PostgreSQL observability, right in the consoleoriginal ↗
18 Jun 2026
pgstream v1.1.0: Steps towards turning it into a serviceoriginal ↗
16 Jun 2026
A thousand Postgres branches for $1original ↗
11 Jun 2026
Query Editor v2: A Better Way to Write SQL in Xata Consoleoriginal ↗
4 Jun 2026
How we rebuilt PostgreSQL branch metrics on VictoriaMetrics, per celloriginal ↗
2 Jun 2026
Building production AI apps with Xata and Claude Codeoriginal ↗
27 May 2026
A connection pooler for every Postgres branch, scaling to zero instances with itoriginal ↗
7 May 2026
Inside Xatastor: ZFS + NVMe-oF for millions of Postgres databasesoriginal ↗
30 Apr 2026
AI codes. Humans engineeroriginal ↗
26 Apr 2026
Code Review for Vibe Codersoriginal ↗
23 Apr 2026
The Rural Reset: Club Xata France 2026original ↗
20 Apr 2026
What if database branching was easy?original ↗
16 Apr 2026
Xata is now open sourceoriginal ↗
15 Apr 2026
Introducing Xata OSS: Postgres platform with branching, now Apache 2.0original ↗
15 Apr 2026
The missing layer in LLM knowledge basesoriginal ↗
6 Apr 2026
Every AI agent needs a database it can breakoriginal ↗
23 Mar 2026
We skipped the OLAP stack and built our data warehouse in vanilla Postgresoriginal ↗
17 Mar 2026
My git-worktree setup using worktrunk and caddyoriginal ↗
25 Feb 2026
The 5 Best Data Anonymization Tools for Development Teams in 2026original ↗
25 Feb 2026
Data Pseudonymization Explained: When Anonymization Isn't Enoughoriginal ↗
17 Feb 2026
Skim-review is the new normal. Your data workflow has to catch uporiginal ↗
13 Feb 2026
Dynamic Data Masking: Use Cases, Limitations, and Going Beyondoriginal ↗
12 Feb 2026
Is Postgres really enough in 2026?original ↗
10 Feb 2026
Introducing the xata CLI container image: Automate your database workflows in Kubernetesoriginal ↗
5 Feb 2026
What is database branching? A complete guide for development teamsoriginal ↗
5 Feb 2026
pgstream v1.0.0: Stateless schema change replicationoriginal ↗
4 Feb 2026
Secure by design: Data masking, obfuscation, and pseudonymization for engineering teamsoriginal ↗
29 Jan 2026
Pseudonymization vs. Anonymization: Which approach fits your data strategy?original ↗
28 Jan 2026
Xata acquires Privacy Dynamics for advanced anonymizationoriginal ↗
26 Jan 2026
Anonymization: The missing link in dev workflowsoriginal ↗
22 Jan 2026
Introducing AI-assisted PII removal for safer stagingoriginal ↗
18 Jan 2026
Database branching for AI coding agents: a minimal, CLI-first setup that actually worksoriginal ↗
14 Jan 2026
Optimizing data throughput for Postgres snapshots with batch size auto-tuningoriginal ↗
12 Jan 2026

2025

Modernize your database workflows without a migration (code with real data)original ↗
22 Dec 2025
Teaching Claude Code to use isolated database branches with Agent Skillsoriginal ↗
17 Dec 2025
What you should know about constraints in PostgreSQLoriginal ↗
10 Dec 2025
Closing the loop: Building a coding agent that uses Postgres branchesoriginal ↗
8 Dec 2025
How we improved Organization Invites to Keycloakoriginal ↗
2 Dec 2025
Tips for configuring Neovim for Claude Codeoriginal ↗
1 Dec 2025
pgstream v0.9.0: Better schema replication, snapshots and cloud supportoriginal ↗
26 Nov 2025
The Villa Getaway: Club Xata Rome 2025original ↗
23 Oct 2025
Recap of Berlin Postgres Meetup on September 23rd 2025original ↗
2 Oct 2025
Going down the rabbit hole of Postgres 18 featuresoriginal ↗
29 Sept 2025
From natural language to SQL queries: How we built Generate SQL with AIoriginal ↗
18 Sept 2025
Making Postgres scale to zero with CNPGoriginal ↗
17 Sept 2025
pgstream v0.8.1: hstore transformer, roles snapshotting, CLI improvements and moreoriginal ↗
15 Sept 2025
From DBA to DB Agentsoriginal ↗
3 Sept 2025
PGConf.EU Community Events Day: CfPs closing soonoriginal ↗
29 Aug 2025
Postgres in Malmö: Powered by Elly Phneahoriginal ↗
8 Aug 2025
Zero Downtime Schema Changes with Vercel and Xataoriginal ↗
24 Jul 2025
pgroll is on a roll! We hit 5k stars on Githuboriginal ↗
18 Jul 2025
Reaction to the PlanetScale PostgreSQL benchmarksoriginal ↗
16 Jul 2025
pgroll 0.14 - New commands and more control over version schemasoriginal ↗
4 Jul 2025
Behind the scenes: Speeding up pgstream snapshots for PostgreSQLoriginal ↗
1 Jul 2025
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 2original ↗
25 Jun 2025
pgstream v0.7.1: JSON transformers, progress tracking and wildcard support for snapshotsoriginal ↗
20 Jun 2025
Neon vs Supabase vs Xata: Postgres Branching Comparedoriginal ↗
9 Jun 2025
pgstream v0.6.0: Template transformers, observability, and performance improvementsoriginal ↗
29 May 2025
pgroll v0.13.0: Start using pgroll on existing databases with the new baseline featureoriginal ↗
27 May 2025
Xata Agent v0.3.1: Custom tools via MCP, Ollama integration, support for reasoning models & moreoriginal ↗
21 May 2025
From OpenAPI Spec to MCP Server: A Practical Guide with Kubb and Next.jsoriginal ↗
20 May 2025
pgstream v0.5.0: New transformers, YAML configuration, CLI refactoring & table filteringoriginal ↗
20 May 2025
Highlights from PGConf.DE 2025original ↗
20 May 2025
Off the grid, on the same page - Club Xata Iceland 2025original ↗
15 May 2025
Xata: Postgres with data branching and PII anonymizationoriginal ↗
14 May 2025
pgroll v0.12.0: create command, verbose mode & idempotent migrate commandoriginal ↗
9 May 2025
Xata Agent v0.2.0: Powered-up chat, custom playbooks, GCP support & moreoriginal ↗
16 Apr 2025
pgroll v0.11.0: YAML migration support, pgroll.migration table improvements & moreoriginal ↗
8 Apr 2025
Writing an LLM Eval with Vercel's AI SDK and Vitestoriginal ↗
2 Apr 2025
pgstream v0.4.0: Postgres-to-Postgres replication, snapshots & transformationsoriginal ↗
27 Mar 2025
Are AI agents the future of observability?original ↗
25 Mar 2025
pgroll 0.10.0 updateoriginal ↗
28 Feb 2025
Postgres Cafe: Building PostgreSQL extensions in Zig using pgzxoriginal ↗
12 Feb 2025
pgroll 0.9.0 updateoriginal ↗
10 Feb 2025
Anatomy of table-level locks: Reducing locking impactoriginal ↗
20 Jan 2025
Postgres Cafe: Solving schema replication gaps with pgstreamoriginal ↗
15 Jan 2025
Anatomy of Table-Level Locks in PostgreSQLoriginal ↗
13 Jan 2025

2024

Postgres Cafe: Exploring pgroll for zero-downtime schema changesoriginal ↗
18 Dec 2024
pgroll v0.8.0: Support for multi-column primary keys, multi-column constraints & new CLI commandsoriginal ↗
9 Dec 2024
Is pg_dump a backup tool?original ↗
5 Dec 2024
Changes to the Xata free planoriginal ↗
4 Dec 2024
Maintaining Postgres for Modern Workloadsoriginal ↗
27 Nov 2024
Prague PostgreSQL Meetup on November 18thoriginal ↗
17 Nov 2024
Recap of PGConf.EU 2024 in Athensoriginal ↗
15 Nov 2024
Schema changes and the power of expand-contract with pgrolloriginal ↗
13 Nov 2024
Prague PostgreSQL Meetup on October 29thoriginal ↗
28 Oct 2024
pgroll 0.7.0 updateoriginal ↗
23 Oct 2024
What I look forward to at PGConf.EU in Athensoriginal ↗
21 Oct 2024
Trackstack improves query performance by 67% with Xataoriginal ↗
16 Oct 2024
Recap of OSS Vienna: What is Happening in the Open Source Worldoriginal ↗
4 Oct 2024
Prague PostgreSQL Meetup on September 30thoriginal ↗
25 Sept 2024
HydroPro Solutions achieves a 60% reduction in search time using the Xata Postgres-powered platformoriginal ↗
19 Sept 2024
Meet Xata at PGConf NYC 2024original ↗
17 Sept 2024
Savas Labs saves 60+ hours in development time with Xata's Serverless Postgresoriginal ↗
5 Sept 2024
Postgres Happy Hour with Xata at Open Source Summit Europeoriginal ↗
3 Sept 2024
Next