freshcrate
Skin:/
Language:English/įŽ€äŊ“中文
Home > Databases > crate

crate

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

analyticsbig-datacratedbdatabasedbmsdistributeddistributed-databasedistributed-sql-databasejavavector-database
Why this rank:Strong adoptionRecent releaseHealthy release cadence

Description

CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

README

CrateDB

Help us improve CrateDB by taking our User Survey!

About

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.

Features

  • 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, real-time full-text search, geospatial data types and search capabilities.
  • Horizontally scalable, highly available and fault-tolerant clusters that run very well in virtualized and containerized environments.
  • Extremely fast distributed query execution.
  • Auto-partitioning, auto-sharding, and auto-replication.
  • Self-healing and auto-rebalancing.
  • User-defined functions (UDFs) can be used to extend the functionality of CrateDB.

Screenshots

CrateDB provides an Admin UI:

Screenshots of the CrateDB Admin UI

Try CrateDB

Run CrateDB via the official Docker Image:

sh$ docker run --publish 4200:4200 --publish 5432:5432 --env CRATE_HEAP_SIZE=1g crate '-Cdiscovery.type=single-node'

Or 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.

Contributing

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

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

Security

The CrateDB team and community take security bugs seriously. We appreciate your efforts to responsibly disclose your findings, and will make every effort to acknowledge your contributions.

If you think you discovered a security flaw, please follow the guidelines at SECURITY.md.

Help

Looking for more help?

Release History

VersionChangesUrgencyDate
6.3.2Release notes: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.3.2.html Complete list of changes in 6.3: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.3.0.html Download on: - https://cratedb.com/downloadHigh5/13/2026
6.2.7Release notes: https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.7.html Complete list of changes in 6.2: https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: https://cratedb.com/downloadHigh4/27/2026
6.2.6Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.6.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: - https://cratedb.com/download High4/17/2026
6.1.4Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.1.4.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.1.0.html Download on: - https://cratedb.com/download High4/17/2026
6.0.6Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.0.6.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.0.0.html Download on: - https://cratedb.com/download High4/16/2026
6.3.1Release notes: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.3.1.html Complete list of changes in 6.3: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.3.0.html Download on: - https://cratedb.com/download Medium4/14/2026
6.2.5Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.5.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: - https://cratedb.com/download Medium4/14/2026
6.3.0Release notes: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.3.0.html Download on: - https://cratedb.com/download Medium3/31/2026
6.2.4Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.4.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: - https://cratedb.com/download Medium3/30/2026
6.2.3Release notes: https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.3.html Complete list of changes in 6.2: https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: https://cratedb.com/downloadLow3/17/2026
6.2.2Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.2.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.2.0.html Download on: - https://cratedb.com/download Low3/3/2026
6.2.1Release notes: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.2.1.html Complete list of changes in 6.2: - https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/6.2.0.html Download on: - https://cratedb.com/download Low2/3/2026
6.1.3Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.1.3.html Complete list of changes in 6.1: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/6.1.0.html Download on: - https://crate.io/download Low2/3/2026
6.2.0Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.2.0.html Download on: - https://crate.io/download Low1/14/2026
6.0.5Release notes: - https://crate.io/docs/crate/reference/en/6.0/appendices/release-notes/6.0.5.html Download on: - https://crate.io/downloadLow12/11/2025
6.1.2Release notes: - https://cratedb.com/docs/crate/reference/en/6.1/appendices/release-notes/6.1.2.html Download on: - https://crate.io/download Low12/10/2025
5.10.16Release notes: - https://cratedb.com/docs/crate/reference/en/5.10/appendices/release-notes/5.10.16.html Download on: - https://crate.io/downloadLow12/10/2025
6.1.1Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.1.1.html Download on: - https://crate.io/download Low11/19/2025
6.0.4Release notes: - https://crate.io/docs/crate/reference/en/6.0/appendices/release-notes/6.0.4.html Download on: - https://crate.io/downloadLow11/19/2025
5.10.15Release notes: - https://cratedb.com/docs/crate/reference/en/5.10/appendices/release-notes/5.10.15.html Download on: - https://crate.io/download Low11/19/2025
5.10.14Release notes: - https://cratedb.com/docs/crate/reference/en/5.10/appendices/release-notes/5.10.14.html Download on: - https://crate.io/download Low11/3/2025
6.1.0Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.1.0.html Download on: - https://crate.io/download Low10/21/2025
6.0.3Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.0.3.html Download on: - https://crate.io/download Low10/14/2025
5.10.13Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/5.10.13.html Download on: - https://crate.io/download Low10/14/2025
6.0.2Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.0.2.html Download on: - https://crate.io/download Low9/24/2025
6.0.1Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.0.1.html Download on: - https://crate.io/download Low9/23/2025
5.10.12Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.12.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/download Low9/23/2025
6.0.0Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/6.0.0.html Download on: - https://crate.io/download Low7/17/2025
5.10.11Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.11.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/download Low7/14/2025
5.10.10Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.10.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/download Low6/30/2025
5.10.9Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.9.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/download Low6/16/2025
5.10.8**NOTE** 5.10.8 will remain testing as it introduced a regression which is solved in 5.10.9 by: https://github.com/crate/crate/pull/18015 --------------------------------------------------------------- Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.8.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow6/10/2025
5.10.7Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.7.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow5/26/2025
5.10.6Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.6.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow5/12/2025
5.10.5Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.5.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow4/28/2025
5.10.4Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.4.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow4/7/2025
5.9.13Release notes: - https://crate.io/docs/crate/reference/en/5.9/appendices/release-notes/5.9.13.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/5.9/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow4/7/2025
5.10.3Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.3.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow3/18/2025
5.9.12Release notes: - https://crate.io/docs/crate/reference/en/5.9/appendices/release-notes/5.9.12.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/5.9/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow3/18/2025
5.10.2Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.2.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.10.0.html Download on: - https://crate.io/download Low2/28/2025
5.9.11Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.11.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow2/27/2025
5.8.7Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.8.7.html Complete list of changes in 5.8: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.8.0.html Download on: - https://crate.io/download Low2/27/2025
5.10.1Release notes: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/5.10.1.html Complete list of changes in 5.10: - https://crate.io/docs/crate/reference/en/master/appendices/release-notes/5.10.0.html Download on: - https://crate.io/downloadLow2/13/2025
5.9.10Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.10.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow2/13/2025
5.9.9Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.9.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow1/30/2025
5.8.6Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.8.6.html Complete list of changes in 5.8: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.8.0.html Download on: - https://crate.io/download Low1/30/2025
5.7.6Release notes: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/5.7.6.html Complete list of changes in 5.7: - https://cratedb.com/docs/crate/reference/en/latest/appendices/release-notes/5.7.0.html Download on: - https://cratedb.com/download Low1/30/2025
5.10.0Release notes: https://cratedb.com/docs/crate/reference/en/master/appendices/release-notes/5.10.0.html Download on: https://crate.io/downloadLow1/21/2025
5.9.8Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.8.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow1/21/2025
5.9.7Release notes: https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.7.html Complete list of changes in 5.9: https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: https://crate.io/download Low1/21/2025
5.9.6Release notes: https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.6.html Complete list of changes in 5.9: https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: https://crate.io/downloadLow1/8/2025
5.9.5Release notes: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.5.html Complete list of changes in 5.9: - https://crate.io/docs/crate/reference/en/latest/appendices/release-notes/5.9.0.html Download on: - https://crate.io/downloadLow12/10/2024

Dependencies & License Audit

Loading dependencies...

Similar Packages

arcadedbArcadeDB Multi-Model Database, one DBMS that supports SQL, Cypher, Gremlin, HTTP/JSON, MongoDB and Redis. ArcadeDB is a conceptual fork of OrientDB, the first Multi-Model DBMS. ArcadeDB supports Vecto26.6.1
vespaAI + Data, online. https://vespa.aiv8.699.8
search🔍 Implement hybrid search using Vespa and FastAPI, blending BM25 and dense semantic retrieval for efficient, accurate information retrieval.main@2026-06-05
pixeltableData Infrastructure providing a declarative, incremental approach for multimodal AI workloads.v0.6.4
meilisearchA lightning-fast search engine API bringing AI-powered hybrid search to your sites and applications.v1.45.2

More in Databases

milvusMilvus is a high-performance, cloud-native vector database built for scalable vector ANN search
WeKnoraLLM-powered framework for deep document understanding, semantic retrieval, and context-aware answers using RAG paradigm.
ai-real-estate-assistantAdvanced AI Real Estate Assistant using RAG, LLMs, and Python. Features market analysis, property valuation, and intelligent search.
alibabacloud-adb20211201Alibaba Cloud adb (20211201) SDK Library for Python