CrateDB is a distributed SQL database for storing and analyzing massive amounts of data in real-time. Built on top of Lucene.
Alternatives To Crate
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Awesome Elasticsearch4,408
9 months ago2unlicense
A curated list of the most important and useful resources about elasticsearch: articles, videos, blogs, tips and tricks, use cases. All about Elasticsearch!
Crate3,6924114 hours ago13October 25, 2016249apache-2.0Java
CrateDB is a distributed SQL database for storing and analyzing massive amounts of data in real-time. Built on top of Lucene.
7 years ago2Java
2 years ago3apache-2.0Scala
Natural Series Database
4 years ago1otherScala
GNAF geocoder and more
6 years ago11mitJava
Java and Lucene based tools for BitFunnel corpus preparation
12 days agogpl-2.0Java
Reactive Database engine for Java with RocksDB and Lucene Core
6 years ago21apache-2.0JavaScript
A material assay database
Gun Cassandra12
5 years ago4January 15, 2018mitJavaScript
Cassandra / Elassandra persistence layer for Gun DB :gun:
Emh Exist Glossary6
3 months ago8JavaScript
This is a sample search application with faceting for the eXist-db Open Source XML Database managing SKOS glossaries
Alternatives To Crate
Select To Compare

Alternative Project Comparisons

Help us improve CrateDB by taking our User Survey!


CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of data in real-time.

CrateDB offers the benefits of an SQL database and the scalability and flexibility typically associated with NoSQL databases. Modest CrateDB clusters can ingest tens of thousands of records per second without breaking a sweat. You can run ad-hoc queries using standard SQL. CrateDB's blazing-fast distributed query execution engine parallelizes query workloads across the whole cluster.

CrateDB is well suited to containerization, can be scaled horizontally using ephemeral virtual machines (e.g., Kubernetes, AWS, and Azure) with no shared state. You can deploy and run CrateDB on any sort of network

from personal computers to multi-region hybrid clouds and the edge.


  • Use standard SQL via the PostgreSQL wire protocol or an HTTP API.
  • Dynamic table schemas and queryable objects provide document-oriented features in addition to the relational features of SQL.
  • Support for time-series data, realtime full-text search, geospatial data types and search capabilities.
  • Horizontally scalable, highly available and fault tolerant clusters that run very well in virtualized and containerised environments.
  • Extremely fast distributed query execution.
  • Auto-partitioning, auto-sharding, and auto-replication.
  • Self-healing and auto-rebalancing.


CrateDB provides an Admin UI:

Screenshots of the CrateDB Admin UI

Try CrateDB

The fastest way to try CrateDB out is by running:

sh$ bash -c "$(curl -L"

Or spin up the official Docker image:

sh$ docker run --publish 4200:4200 --publish 5432:5432 crate -Cdiscovery.type=single-node

Visit the installation documentation to see all the available download and install options.

Once you're up and running, head over to the introductory docs. To interact with CrateDB, you can use the Admin UI sql console or the CrateDB shell CLI tool. Alternatively, review the list of recommended clients and tools that work with CrateDB.

For container-specific documentation, check out the CrateDB on Docker how-to guide or the CrateDB on Kubernetes how-to guide.


This project is primarily maintained by, but we welcome community contributions!

See the developer docs and the contribution docs for more information.


Looking for more help?

Popular Lucene Projects
Popular Database Projects
Popular Data Processing Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Internet Of Things
Time Series
Big Data
Timeseries Database
Distributed Database