CrateDB is a distributed SQL database for time series, IoT and analytics, with real time SQL and a built in Admin UI. This image runs CrateDB 6.3.5 on Ubuntu 24.04 LTS, with the Admin UI on port 80, the PostgreSQL wire on 5432, authentication enforced with a per VM password on first boot, and all data on a dedicated disk. By cloudimg.
## CrateDB 6 on Ubuntu 24.04 LTS
CrateDB is a distributed SQL database built on Lucene, with Elasticsearch lineage clustering, real time SQL and horizontal scaling. It is a natural fit for time series, IoT and analytics workloads where you want familiar SQL over very large, fast moving datasets. Built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base, this image ships CrateDB 6.3.5 with its bundled Java runtime, the built in Crate Admin UI served through nginx on port 80, and the PostgreSQL wire protocol on port 5432 for any SQL client.
Authentication is enforced out of the box. A unique admin user and password are generated on the first boot of every VM and written to /root/cratedb-credentials.txt, and no unauthenticated request is ever accepted on a network reachable surface. Sign in as admin in the Admin UI, or connect psql, JDBC or any PostgreSQL client on port 5432. All tables and cluster metadata live on a dedicated managed data disk.
The appliance ships as a single node cluster and scales out horizontally by adding more nodes. An unauthenticated /healthz endpoint is provided for load balancer probes. CrateDB is licensed under the Apache License 2.0.