Xata – Postgres at scale

What it is

Xata is a data platform designed to help teams operate and develop with PostgreSQL at scale. It is targeted at scaleups and enterprises that require high-performance, flexible, and secure database management. The service supports existing Postgres databases on major cloud providers (AWS RDS, Amazon Aurora, GCP Cloud SQL, Azure Database) or can host a database for the user.

Main Features

Database Branching & Development

• Instant Copy-on-Write branches for development and testing
• Automated anonymization of PII and sensitive data with configurable transformers
• Nightly-synced staging replicas with realistic, anonymized data

Performance & Infrastructure

• High-performance NVMe/TCP distributed storage architecture
• Bottomless storage (pay-per-use model)
• Tiering for cold storage and long-term data retention

Management & Optimization

• AI-powered Xata Agent for monitoring, performance issue detection, and automated recommendations
• Zero-downtime schema migrations using pgroll
• Support for custom Postgres extensions and tailored images

Deployment Flexibility

• Bring Your Own Cloud (BYOC) deployment option for AWS, GCP, or Azure
• Data remains within the user's own cloud infrastructure for security and compliance
• Full management by Xata while user pays infrastructure costs directly to cloud provider

How it works

Connecting an Existing Production Database

Users connect their production PostgreSQL database from AWS RDS, Aurora, GCP Cloud SQL, Azure Database, or self-hosted instances to the Xata platform.

Creating Anonymized Staging and Development Environments

Xata uses pgstream to mask sensitive production data while maintaining referential integrity. This creates a safe staging replica. Developers can then instantly create isolated, Copy-on-Write branches from this staging environment for each pull request or feature development.

Deploying Changes to Production

Database schema changes are applied confidently using pgroll, which serves both old and new schema versions in parallel to enable lock-free, zero-downtime migrations to production.

Performance Monitoring and Optimization

The Xata Agent continuously monitors the database, identifies performance bottlenecks like slow queries or full table scans, and provides AI-powered recommendations for indexing, configuration tuning, or scaling.

Key Points

• Focuses on developer velocity by providing instant, isolated database branches with realistic data.
• Offers significant cost efficiency and performance improvements compared to services like Amazon Aurora, as shown in benchmark data.
• Provides unparalleled flexibility with BYOC deployment, keeping data within the user's own cloud account for security and compliance.
• The AI-powered Xata Agent acts as an automated PostgreSQL expert, providing actionable insights.
• Maintains a clear separation between the control plane (managed by Xata) and the data plane (deployed in the user's cloud).

Additional Details

• Pricing: Infrastructure costs are paid directly to the cloud provider in BYOC mode. Specific platform pricing is available on a separate pricing page.
• Availability: The main platform is optimized for scaleups and enterprises. A separate product, Xata Lite, offers a simpler, fully-managed Postgres with a generous free tier (15 GB storage) for side projects and AI agents.
• Requirements: Works with existing PostgreSQL databases on AWS, GCP, Azure, or can host a new database.
• Open Source: The Xata Agent is available as an open-source project on GitHub.