Introduction
Pivot is a high-performance analytics database that runs on open data formats. It delivers low-latency queries and high concurrency without replicating data into a dedicated database or proprietary format.
Key features
Section titled “Key features”- Fast - Written in Rust and built on state-of-the-art columnar execution techniques, including morsel-driven parallelism, SIMD, NUMA-aware execution, and cache-conscious aggregation and joins, in addition to a few novel additions (Why is Pivot fast?).
- Scalable - With object storage as its backing store, Pivot can be scaled up, down, or to zero almost instantly.
- Portable - Pivot can run both as a server serving backends and clients, or as a local engine where users and agents query the source of truth directly, allowing local ad-hoc and agentic analytics to share the same engine and architecture as traditional dashboards and in-app analytics
- Open - Pivot is open source and built on open data formats (Delta Lake and Apache Iceberg). This means you can use Pivot with data already stored in your data warehouse, while data ingested by Pivot remains accessible to other query engines.
Where to start
Section titled “Where to start”- Quickstart runs a server and issues a first query.
- Architecture explains how a query becomes work across the Dispatch pool.
- Roadmap shows what is available, in progress, and planned.
- SQL reference documents commands, functions, operators, and data types with examples.
- CLI & server reference covers CLI commands, configuration, datastores, authentication, and system tables.
