Skip to content
TrustList
P
Data Warehouse Software

Pivot

New· 4

Open-source analytics database written in Rust that queries Iceberg and Delta Lake tables through the Postgres protocol

About Pivot

Querying data where it already sits, in open table formats on object storage, is the idea behind Pivot, an analytics database written in Rust. It runs low-latency, high-concurrency queries on external Apache Iceberg tables and on its own managed Delta Lake tables, which spares teams from loading it into a dedicated real-time engine first.

A shared server or a local command line

Pivot can run as a shared server or cluster that applications, BI tools and SQL clients reach over the Postgres protocol. It can also run locally from a terminal or an AI agent for ad hoc queries, with no server to manage. Both modes read the same tables in object storage, so no extra copies need to be maintained.

Scaling to zero

Because object storage is the only place where state lives, Pivot can grow, shrink or drop to zero in moments. When it is idle it costs nothing to keep.

Open formats, open code

Pivot handles ingestion, compaction and statistics to keep its Delta Lake tables ready for sub-second SQL queries. Because the files are Delta Lake, other engines such as Snowflake, Spark, DuckDB and Trino can query them too. Connecting to existing Iceberg tables leaves the data where it is. The code is released under the Apache 2.0 licence.

Benchmarks and maturity

The maker calls Pivot the fastest real-time analytical database and publishes comparisons with ClickHouse, DuckDB, DataFusion and Spark, and its repository holds the harness so others can rerun the tests. Those figures are the maker's own. The site is run by Epsio Labs, no location is stated, and its documentation describes Pivot as early in development and not yet ready for production. The maker introduced it on Hacker News on 8 October 2026.

TrustList summary

Pivot is a database for analytics, written in Rust, that runs queries directly on open table formats. It works with external Apache Iceberg tables and with Delta Lake tables it manages itself. The site is run by Epsio Labs, and the documentation says the engine is in early development and not yet ready for production.

Main features

  • Queries on open formats: runs SQL against Iceberg tables where they sit, and against its own Delta Lake tables, without copying the data into a separate engine.
  • Shared server: runs as a central server that BI tools and SQL clients can connect to via the Postgres wire protocol.
  • Local mode: runs from a terminal or AI agent for ad hoc queries, reading object storage with no server to manage.
  • Scaling: can be scaled up, down or to zero, because object storage holds all of its state.
  • Benchmarks: the developer publishes speed comparisons against ClickHouse, DuckDB, DataFusion and Spark, with the test harness in its repository.

Clients

It serves applications, BI tools, SQL clients and AI agents that query data kept in Iceberg or Delta Lake tables, which other engines such as Snowflake, Spark and Trino can also read.

Key facts

  • Operator: Epsio Labs
  • Licence: Apache 2.0
  • Status: early development, not production ready, according to its documentation
  • Presented: 8 October 2026, on Hacker News by the maker

Summary written by TrustList from the business's own published information, Nov 2026.

Categories & features

Trust Score

4/ 100
Trust Score: New

An earned signal from verification, reviews, awards, transparency and engagement - the vendor can't buy it.

Verification
0/100 · 20%
Reviews
0/100 · 30%
Awards
0/100 · 15%
Transparency
18/100 · 20%
Engagement
0/100 · 15%
Joining soon
Recommendations
Coming soon
Complaints
Coming soon

Updated 10/9/2026

Request a demo or quote from Pivot

Protected by reCAPTCHA - Google Privacy Policy and Terms apply.

By sending, you agree we may share your request and contact details with the provider once you confirm your email.

Reviews

Write the first review of Pivot

Used it? Your experience helps other buyers decide.

Write a review

Questions & answers

No questions yet. Be the first to ask about Pivot.

Pivot alternatives

Similar listings buyers compare against this one.

Microsoft cloud analytics service for bringing data together and preparing it for analysis

Cloud data platform for warehousing, data lakes, analytics, AI and data sharing

MotherDuck is a managed cloud analytics service built around DuckDB, with shared databases and per-second billed compute, for small teams to enterprises.

ClickHouse is an open-source column-oriented database management system for real-time analytical reports, run self-managed or as ClickHouse Cloud.

Apache Cloudberry is an open-source MPP data warehouse derived from Greenplum, built on a newer PostgreSQL kernel and still incubating at Apache.

Amazon Redshift is a managed data warehouse from Amazon Web Services, offered as provisioned clusters or Serverless with storage scaled separately.

Microsoft Fabric Warehouse is an enterprise-scale relational warehouse on a data lake foundation, delivered as part of Microsoft's Fabric SaaS platform.

Databricks SQL is the SQL warehousing product of the Databricks lakehouse platform, working over open formats on AWS, Azure and Google Cloud.