Fast analytics for PostgreSQL,
powered by DuckDB
Zero-ETL sync between your Postgres database and Apache Iceberg. Unlock scalable and cost-effective analytics without any complexity.
Fast, scalable, and cost-effective
Run lightning-fast analytics queries on your data at any scale. It delivers sub-second query performance on billions of rows.
Zero-ETL
Continuous sync between your Postgres database and Apache Iceberg on object storage (S3), without maintaining pipelines.
No vendor lock-in
Built on modern open-source technologies and data formats (Apache Iceberg, DuckDB, PostgreSQL protocol), it is fully compatible with existing tools and workflows.
Relieve your PostgreSQL database from heavy analytics queries
Leverage DuckDB and Apache Iceberg to unlock efficient analytics and time-series use-cases.
Sync the PostgreSQL database to Apache Iceberg
The data is continuously and automatically synced to Apache Iceberg on object storage (S3). We use logical replication from a read-replica, so the impact to production is minimal.
Use DuckDB to run analytics queries
Query with familiar tools
Connect and query using standard PostgreSQL syntax with your existing apps, BI dashboards, or notebooks.
Why you need an analytical database
PostgreSQL is a fantastic database for OLTP workloads, but its storage is row-oriented and its execution engine is not optimized for analytics.
The challenges you are facing
Slow analytical queries are putting unnecessary pressure on your main database.
Setting up ETL pipelines takes months of engineering effort and constant maintenance.
Vendor lock-in is a major risk when using proprietary data warehouse platforms.
How Xata solves them
DuckDB vectorized query engine executes complex queries on billions of rows with sub-second performance.
Zero-ETL sync copies and keeps your data in sync without any complexity.
Open formats like Apache Iceberg and open-source tools like PostgreSQL and DuckDB.
Use our cloud, or bring your own
Xata cloud Running your PostgreSQL service in our cloud is the easiest way to get DuckDB-powered analytics on top of your PostgreSQL database.
Bring your own Cloud (BYOC) A fully managed Xata service for large-scale deployments deployed in your own AWS, Azure or GCP account. Best for security and compliance.
Frequently Asked Questions
Find answers to common questions about Xata's PostgreSQL analytics offering