Distributed SQL Database
4.4k 2026-04-30
crate/crate
CrateDB is a distributed SQL database combining SQL benefits with NoSQL scalability for real-time data analysis.
Core Features
Standard SQL via PostgreSQL wire protocol or HTTP API.
Supports time-series, full-text search, and geospatial data with dynamic schemas.
Horizontally scalable, highly available, and fault-tolerant clusters.
Extremely fast distributed query execution with auto-management features.
Quick Start
docker run --publish 4200:4200 --publish 5432:5432 --env CRATE_HEAP_SIZE=1g crate '-Cdiscovery.type=single-node'Detailed Introduction
CrateDB is an open-source, distributed SQL database designed for real-time storage and analysis of massive datasets. It uniquely blends the familiarity and power of standard SQL with the horizontal scalability and flexibility typically found in NoSQL systems. Built on Lucene and PostgreSQL-compatible, CrateDB excels in environments requiring high-throughput data ingestion and complex ad-hoc queries across large clusters, making it ideal for containerized deployments and multi-cloud architectures.