Awesome Open Source
Awesome Open Source

.. image:: docs/_static/crate-logo.png :alt: CrateDB :target:

.. image:: :target:

.. image:: :target:

.. image:: :target:



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

CrateDB offers the scalability and flexibility typically associated with a NoSQL database, is designed to run on inexpensive commodity servers and can be deployed and run on any sort of network - from personal computers to multi-region hybrid clouds.

The smallest CrateDB clusters can easily ingest tens of thousands of records per second. The data can be queried, ad-hoc, in parallel across the whole cluster in real time.


  • Standard SQL interface available via HTTP API and PostgreSQL wire protocol.

  • Dynamic schemas, queryable objects, geospatial features, time series data support, and realtime full-text search providing functionality for handling both relational and document oriented nested data structures.

  • 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_:

.. image:: crate-admin.gif :alt: Screenshots of the CrateDB admin UI

Try CrateDB

The fastest way to try CrateDB out is by running::

$ bash -c "$(curl -L"

Or spin up the official Docker image_::

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

Visit the getting started_ page 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 web 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 Crate.io_, but we welcome community contributions!

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


Looking for more help?

  • Try one of our beginner tutorials, how-to guides, or consult the reference manual_.

  • Check out our support channels_.

  • Crate.io_ also offers CrateDB Cloud, a fully-managed CrateDB Database as a Service (DBaaS). The CrateDB Cloud Tutorials will get you started

.. _Admin UI: .. _beginner tutorials: .. _clients and tools: .. _contribution docs: CONTRIBUTING.rst .. .. _CrateDB clients and tools: .. _CrateDB Cloud Tutorials: .. _CrateDB Cloud: .. _CrateDB Kubernetes Operator Documentation: .. _CrateDB Kubernetes Operator: .. _CrateDB on Docker how-to guide: .. _CrateDB on Kubernetes how-to guide: .. _CrateDB shell: .. _developer docs: devs/docs/index.rst .. _Docker image: .. _getting started: .. _how-to guides: .. _introductory docs: .. _reference manual: .. _support channels: .. _web console:

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
java (31,121
database (1,216
sql (699
iot (565
analytics (319
big-data (239
time-series (237
distributed (231
cluster (191
db (56
distributed-database (53
scada (28
olap (20
dbms (16