Skip to content
SPECIFICTION
Get listed

CrateDB

cratedb.com

Free plan Open source WebWindowsmacOSLinuxAPISelf-hosted
Visit cratedb.com
Spec score 9.3 #1 of 40 in Spatial Databases

Spec sheet

What it does
CrateDB is a distributed SQL database for real-time analytics, search and AI workloads on high-volume operational data.Read 15 Oct 2026 · cratedb.com
Purpose
CrateDB is a real-time analytics database for live operational data.Read 2 Oct 2026 · cratedb.com
Deployment
CrateDB can be used as a fully managed service or deployed on preferred infrastructure, and its download page provides Linux and macOS installation information plus Docker and Kubernetes guides.Read 2 Oct 2026 · cratedb.com
Free plan
YesRead 20 Sep 2026 · cratedb.com
Integrations
Documented integrations include Tableau Cloud, Power BI, Kafka, StreamSets, DBeaver, Prometheus, Grafana, Airflow, Superset, Metabase, Excel and n8n.Read 15 Oct 2026 · trustradius.com
Security
CrateDB describes authentication, authorization, encryption, audit logging and compliance certifications across managed and self-managed deployments.Read 15 Oct 2026 · cratedb.com
Compliance
CrateDB Cloud holds ISO 27001 and SOC 2 Type II certifications, according to the security page.Read 2 Oct 2026 · cratedb.com
Support
Support options include a Discourse community, GitHub issues and feature requests, documentation and paid support plans.Read 15 Oct 2026 · cratedb.com
License
The open-source core is licensed under the Apache License 2.0.Read 15 Oct 2026 · cratedb.com
Headquarters
Redwood City, California, United StatesRead 28 Sep 2026 · cratedb.com
Founded
2013Read 28 Sep 2026 · cratedb.com
Batch ingestion
Batch loading is supported for historical backfills, scheduled updates and large imports.Read 15 Oct 2026 · cratedb.com
Cloud security defaults
The security page says CrateDB Cloud enables encryption at rest, IP allowlists, MFA, and isolated clusters by default.Read 2 Oct 2026 · cratedb.com
Company profile
LinkedIn lists CrateDB as a privately held software company founded in 2013 with 11–50 employees and headquarters in Vienna.Read 15 Oct 2026 · linkedin.com
Connectivity
CrateDB supports the PostgreSQL wire protocol and a native HTTP endpoint.Read 2 Oct 2026 · cratedb.com
Connectivity and SDKs
Applications can connect through the PostgreSQL wire protocol, HTTP endpoints and native drivers or client libraries.Read 15 Oct 2026 · cratedb.com
Data types
It supports time-series, JSON, full-text, vector, geospatial, and structured data in one engine.Read 2 Oct 2026 · cratedb.com
Documentation depth
Official documentation includes connection guides, ingestion methods, integrations, administration, SQL syntax, functions and API reference material.Read 15 Oct 2026 · cratedb.com
Full-text feature
Full-text search is provided inside the SQL engine for large unstructured text datasets.Read 15 Oct 2026 · cratedb.com
Funding
Crunchbase lists five funding rounds and 13 investors, including Zetta Venture Partners and Momenta Ventures.Read 15 Oct 2026 · crunchbase.com
Geospatial feature
Geospatial types support distance calculations, spatial filtering and location analytics.Read 15 Oct 2026 · cratedb.com
High availability
Built-in replication and automatic failover are designed to keep clusters running through node failures.Read 15 Oct 2026 · cratedb.com
Horizontal scaling
Nodes can be added to increase throughput, with automatic sharding and replication.Read 15 Oct 2026 · cratedb.com
Installation
Installation documentation covers Docker, Kubernetes, Debian, Ubuntu, Red Hat packages and tarball archives; Linux and macOS are explicitly supported download targets.Read 15 Oct 2026 · cratedb.com
JSON feature
JSON objects are stored and queried natively with flexible schemas and real-time filtering.Read 15 Oct 2026 · cratedb.com
Legal name
Crunchbase identifies the legal entity as Crate.io Inc., also known as CrateDB, Crate.io and Crate.Read 15 Oct 2026 · crunchbase.com
Limit: administration and extensibility
G2 complaints include an improvable admin dashboard, inability to control sharding, limited ORM support and missing extension mechanisms.Read 15 Oct 2026 · g2.com
Limit: ecosystem and tooling
G2 feedback mentions a limited ecosystem of ready-made connectors and administration tools.Read 15 Oct 2026 · g2.com
Limit: product maturity and guidance
G2 reviewers request more production-scale benchmarks and clearer architecture guidance for large observability deployments.Read 15 Oct 2026 · g2.com
Notable news
CrateDB announced on LinkedIn in September 2026 that it was included in Big Data Quarterly’s 2026 Data & AI 75 list.Read 15 Oct 2026 · linkedin.com
Praise: multi-model support
G2 reviewers value querying structured, semi-structured, document, time-series and vector data together.Read 15 Oct 2026 · g2.com
Praise: performance and scale
G2 reviewers praise fast queries, streaming ingestion, horizontal scalability and handling of high-volume telemetry.Read 15 Oct 2026 · g2.com
Praise: usability and setup
G2 reviewers repeatedly describe setup as fast or easy, with familiar SQL and quick cloud onboarding.Read 15 Oct 2026 · g2.com
Public API
The HTTP API accepts SQL statements at the /_sql endpoint using JSON requests and returns columns, rows, row counts and duration.Read 15 Oct 2026 · cratedb.com
Rating on G2
4.4 out of 5 from 85 reviewsRead 15 Oct 2026 · g2.com
Rating on Gartner Peer Insights
4.8 out of 5 from 3 reviewsRead 15 Oct 2026 · gartner.com
Rating on Microsoft Marketplace
4.5 out of 5 from 84 reviewsRead 15 Oct 2026 · marketplace.microsoft.com
Relational SQL
CrateDB supports standard SQL including joins, aggregations, window functions and common table expressions.Read 15 Oct 2026 · cratedb.com
Scale and availability
The product page describes built-in replication, automatic failover, automatic sharding, and horizontal scale-out by adding nodes.Read 2 Oct 2026 · cratedb.com
Self-hosting
CrateDB can run on premises, at the edge, in public or private clouds, or as managed CrateDB Cloud.Read 15 Oct 2026 · cratedb.com
SQL
CrateDB supports SQL, including joins, aggregations, and window functions over billions of rows without pre-aggregation or schema redesign.Read 2 Oct 2026 · cratedb.com
Streaming ingestion
The product continuously ingests streaming events and makes them queryable without batch delay.Read 15 Oct 2026 · cratedb.com
Time-series feature
The database stores and analyzes high-volume time-series data for trend analysis, monitoring and real-time insights.Read 15 Oct 2026 · cratedb.com
Vector feature
Vector embeddings and similarity search run in the same engine as analytics queries.Read 15 Oct 2026 · cratedb.com
Windows limitation
The project documentation says Windows is not officially supported for production use.Read 15 Oct 2026 · github.com

Plans and prices

Shared Free Free 2 vCPUs · 2 GiB RAM · 8 GiB storage Read 20 Sep 2026 · cratedb.com
Shared Price not published Up to 8 shared vCPUs · Up to 12 GB RAM · Up to 1 TB storage Read 20 Sep 2026 · cratedb.com
Dedicated Price not published Up to 9 nodes · Up to 144 vCPUs · Up to 495 GB RAM · Up to 72 TB storage Read 20 Sep 2026 · cratedb.com
CrateDB Cloud Free Plan Free 2 vCPUs · 2 GB RAM · 8 GB storage · no credit card required · backups once per day Read 2 Oct 2026 · cratedb.com
Open Source Free Free for Self-Hosting On Premise Read 15 Oct 2026 · trustradius.com
CrateDB Cloud Shared $0.07 a month Hourly, as displayed Shared environment · single node · up to 8 shared vCPUs and 12 GB RAM · up to 1 TB storage · development support Read 2 Oct 2026 · cratedb.com
CrateDB Cloud Dedicated $0.25 a month Hourly, as displayed; includes basic support Dedicated environment · up to 9 nodes · up to 144 vCPUs and 495 GB RAM · up to 72 TB storage · uptime SLAs · AWS/Azure Private Link · backups once per hour Read 2 Oct 2026 · cratedb.com
Shared S2 $53 a month per month Cloud Read 15 Oct 2026 · trustradius.com
Shared S4 $103 a month per month Cloud Read 15 Oct 2026 · trustradius.com
Shared S6 $153 a month per month Cloud Read 15 Oct 2026 · trustradius.com
Dedicated CR1 $187.25 a month per month Cloud Read 15 Oct 2026 · trustradius.com
Shared S12 $303 a month per month Cloud Read 15 Oct 2026 · trustradius.com

Every CrateDB plan and price →

Where Specifiction places it

Alternatives to CrateDBAll alternatives →