Citus DB: The Scalable
Analytics Database

CitusDB is a distributed database that lets you run SQL queries over very large data sets. Designed for analytical queries, CitusDB enables real-time responsiveness.

Download Now



SQL queries over very large datasets

Powerful query engine distributes ANSI SQL queries and runs them in parallel across commodity hardware.

Real-time SQL on Hadoop

CitusDB colocates database instances on Hadoop nodes, and removes any network bottlenecks. Lets you instantly run SQL queries on Hadoop clusters without having to load any data into the database.

Dremel-like scalability

Add nodes incrementally as your data volume or performance requirements increase. Linearly scale out to hundreds of nodes using CitusDB's block-based architecture.

High availability

CitusDB recovers from failures in real-time. To achieve this, the database intelligently distributes the work for any failed nodes among the remaining nodes in the cluster.

PostgreSQL ecosystem tools. ODBC/JDBC compliance

Get the benefits of the most recent PostgreSQL version (v9.3). Connect to CitusDB through ODBC/JDBC to visualize your data with leading reporting tools.

Semi-structured data support

Write a foreign data wrapper, and run distributed SQL queries on csv, json, and log files without loading any data. Query external data sources such as MongoDB, by uploading only table metadata.

Optimized for append-only event data

CitusDB is an analytics database, where you load data in batches. It is ideal for ad-hoc analysis, reporting, and data exploration on your time-series data; but not for modifying it in real-time.

Interactive queries

Get sub-second response times to your key-value lookups. Perform aggregations, filters, projections, joins across large data sets in seconds. Achieve high performance through advanced disk and network I/O optimizations. Get your results 10x faster than dedicated analytics appliances.

Deploy anywhere: On-premise or in the cloud

No special expectations from hardware or the network. Use standard machines and network connections (100 Mbps+) to build your analytics infrastructure in a flexible, cost-efficient way.

Easy to download and use

Download the software with one click, install it on a Linux box and get up and running in as few as 5 commands. Experience CitusDB for yourself by using sample data and examples available on our site, or better still, by loading your own data.

Review our FAQ, quick start guide, and documentation page for more information, and please contact us if you have any questions or would like to set up a free trial.