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. observed · 2026-08-28
Health v2 · maintenance only
95/100
- Activity 99
- Release rhythm 86
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 12.0
- age_days: 4893
- days_rel: 14
- days_push: 7
- n_releases_24m: 65
Adoption not part of the score
4427 stars · 611 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
CrateDB is a distributed, horizontally scalable SQL database built on Lucene, designed for real-time analytics on massive datasets. It supports the PostgreSQL wire protocol, full-text and geospatial search, time-series data, and vector search.
Use cases
- ingesting tens of thousands of IoT sensor records per second
- running ad-hoc analytical SQL queries on large datasets in near real-time
- storing and querying time-series data from industrial equipment
- full-text search combined with relational SQL queries
- deploying a scalable database on Kubernetes or hybrid clouds
- querying semi-structured JSON documents with standard SQL
When to choose
- you need horizontal scalability with a shared-nothing SQL cluster
- your workload mixes analytics, time-series, and full-text search
- you want PostgreSQL wire-protocol compatibility with distributed query execution
- you run in containerized or multi-region cloud/edge environments
When to avoid
- you need strict ACID transactions with heavy OLTP write patterns
- you depend on advanced PostgreSQL features like stored procedures or full PL/pgSQL
- you want a simple single-node embedded database
- your dataset is small enough for a traditional RDBMS
Facets
service · maturity active
database search-engine vector-database analytics databases big-data analytics iot time-series jvm windows self-hosted cloud distributed-sql olap time-series lucene postgresql-compatible tsdb iot-analytics search docker kubernetes linux macos
2 sources
- readme: https://github.com/crate/crate · fetched 2026-08-28 · 602c6c13ec2e
- homepage: https://cratedb.com/database · fetched 2026-08-29 · 4b4e8fead74a
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| crate/crate | main | 95 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem