Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

CrateDB

By CrateDB · cratedb.com

  • Free plan
  • Open source
  • Windows
  • macOS
  • Linux
  • Web
  • API
  • Self-hosted
8.7 Club score Visit cratedb.com

What CrateDB is

CrateDB is a database for real-time analytics on live operational data. It handles time-series, JSON, full-text, vector, geospatial and structured data in one engine. SQL support includes joins, aggregations and window functions over billions of rows without pre-aggregation or schema redesign. Applications can connect through the PostgreSQL wire protocol or a native HTTP endpoint. Listed integrations include Tableau, Power BI, Grafana, Apache Kafka, Apache Spark and dbt. For availability and growth, CrateDB offers replication, automatic failover and sharding, with horizontal scale-out by adding nodes. It can run as a managed service or on infrastructure a customer chooses; the open-source core is licensed under Apache 2.0. CrateDB Cloud includes authentication, role-based access control, TLS/SSL, encrypted storage and audit logging, and holds ISO 27001 and SOC 2 Type II certifications. Cloud enables encryption at rest, IP allowlists, MFA and isolated clusters by default. A free Cloud plan lists 2 vCPUs, 2 GB RAM and 8 GB storage. Cloud Shared is $0.07 a month and Cloud Dedicated is $0.25 a month, both billed hourly as displayed.

Who it suits

CrateDB may suit teams analyzing live operational data across several data types, especially where SQL, PostgreSQL connectivity or horizontal scaling matters. It offers both managed Cloud and self-managed deployment options.

Good to know, and what to watch

  • One engine handles six listed data types.
  • Supports SQL joins, aggregations and window functions.
  • Offers PostgreSQL wire protocol and native HTTP connectivity.
  • Can scale horizontally by adding nodes.
  • Cloud holds ISO 27001 and SOC 2 Type II certifications.
  • Cloud Shared is listed at $0.07 a month, billed hourly as displayed.
  • Cloud Dedicated is listed at $0.25 a month, billed hourly as displayed.
  • Cloud security defaults apply to CrateDB Cloud.

Shared Free

Free

Shared

—

Dedicated

—

CrateDB Cloud Custom

—

Free plan

Getting started

  1. Open https://cratedb.com/
  2. Choose CrateDB Cloud or download for Linux or macOS
  3. Follow the Docker or Kubernetes deployment guides when applicable
  4. Select the free, Shared, Dedicated, or Custom plan
  5. Connect through PostgreSQL wire protocol or the native HTTP endpoint
  6. Add listed integrations such as Tableau, Grafana, Kafka, Spark, or dbt

Limits to check

The free Cloud plan lists 2 vCPUs, 2 GB RAM, 8 GB storage, and daily backups. Shared provides up to 8 shared vCPUs, 12 GB RAM, and 1 TB storage; Dedicated provides up to 9 nodes, 144 vCPUs, 495 GB RAM, and 72 TB storage.

The Club's review

CrateDB is a real-time analytics database for teams working with live operational data and varied data shapes. It suits organizations that need SQL, PostgreSQL connectivity and flexible deployment without splitting time-series, JSON, vector and geospatial workloads across separate engines. Its strongest case is a scalable mixed-workload platform; smaller projects should weigh the modest free-tier resources and hourly cloud pricing.

Overview

CrateDB combines time-series, JSON, full-text, vector, geospatial and structured data in one database. SQL covers joins, aggregations and window functions, including queries across billions of rows without pre-aggregation or schema redesign. That breadth is useful when operational analytics spans several formats, but it also makes CrateDB a more specialized choice than a narrowly focused relational store.

The open-source core is licensed under Apache 2.0 and can run on-premises, at the edge, in the cloud or as a managed service. CrateDB was founded in 2013 and is headquartered in Redwood City, California. Its scope also places it among Distributed SQL Databases, Multimodel Databases, Spatial Databases, OLAP Databases, Columnar Databases and broader Database Software.

Key features

Mixed data and SQL

A single engine for six stated data categories can reduce the need to move data between specialist systems. SQL support for joins, aggregations and window functions is a practical fit for analytical applications that must work directly on changing operational records.

Scale and availability

Built-in replication and automatic failover address resilience, while automatic sharding and horizontal scale-out let capacity grow by adding nodes. These capabilities suit continuously growing workloads, although larger deployments bring more infrastructure and plan decisions than the free tier.

Connectivity and integrations

Applications can connect through the PostgreSQL wire protocol or a native HTTP endpoint, giving teams familiar and web-oriented access paths. Listed integrations include Tableau, Power BI, Grafana, Apache Kafka, Apache Spark and dbt, which makes CrateDB more practical in established analytics and streaming stacks.

Security and support

Authentication, role-based access control, TLS/SSL connections and encrypted storage volumes cover core controls. CrateDB Cloud adds audit logging and enables encryption at rest, IP allowlists, MFA and isolated clusters by default. Cloud compliance includes ISO 27001 and SOC 2 Type II certifications. A developer community, GitHub, documentation, ticket support and official support plans are available; basic support starts with Dedicated, while premium support is reserved for Custom.

Pricing

CrateDB uses a freemium model, with both self-managed and cloud plans.

  • Shared Free: free, with 2 vCPUs, 2 GiB RAM and 8 GiB storage. It is suitable for evaluation and small experiments, not demanding production analytics.
  • Shared: custom pricing for up to 8 shared vCPUs, 12 GB RAM and 1 TB storage. This is the lower-cost hosted step up, but shared resources may be less appropriate for predictable high-throughput workloads.
  • Dedicated: custom pricing for up to 9 nodes, 144 vCPUs, 495 GB RAM and 72 TB storage. It adds room for serious workloads and dedicated capacity.
  • Custom: custom pricing with unlimited nodes and storage for organizations needing bespoke scale.

Cloud pricing is displayed hourly: CrateDB Cloud Free Plan costs nothing, requires no credit card, provides 2 vCPUs, 2 GB RAM, 8 GB storage and daily backups. CrateDB Cloud Shared costs $0.07 a month, billed Hourly as displayed, and provides a single shared node, up to 8 shared vCPUs, 12 GB RAM, 1 TB storage and development support. CrateDB Cloud Dedicated costs $0.25 a month, billed Hourly as displayed, with up to 9 nodes, 144 vCPUs, 495 GB RAM, 72 TB storage, uptime SLAs, AWS/Azure Private Link, hourly backups and basic support. Cloud Custom is custom pricing with unlimited nodes and storage, custom compute and backups, dedicated master nodes, premium support, uptime SLAs and Private Link.

Platforms

CrateDB supports API, Linux, macOS, Windows, web and self-hosted use. Installation information covers Linux and macOS, with Docker and Kubernetes guides. You can choose managed hosting or deploy on preferred infrastructure, which is valuable for organizations balancing operational control with managed convenience.

Who it's for

CrateDB is a strong fit for teams building real-time analytics on operational data, especially when one workload mixes structured, semi-structured, text, vector or spatial records. PostgreSQL-compatible access and broad integrations help teams connect existing tools, while replication, failover and scale-out support growing deployments. It is less compelling for a tiny application that needs only a simple database and little capacity beyond the free plan.

Pros and cons

  • Pro: Six data types in one engine can simplify architectures that would otherwise use several databases.
  • Pro: SQL, PostgreSQL wire compatibility and HTTP access lower integration friction.
  • Pro: Replication, failover, sharding and node-based scale address availability and growth.
  • Pro: Cloud security defaults and ISO 27001 and SOC 2 Type II certifications support controlled deployments.
  • Con: The free plans provide only 2 vCPUs, about 2 GB RAM and 8 GB storage, limiting production use.
  • Con: Shared Cloud is a single-node environment, so teams needing dedicated capacity must move to the more expensive Dedicated tier.
  • Con: Cloud prices are shown as hourly-billed monthly rates, which requires careful cost monitoring as usage scales.

Alternatives

Choose Exasol instead when a freemium analytical database with pay-as-you-go XS and S plans is a better fit. QuestDB is preferable for a free, Apache 2.0 self-managed single-instance deployment. Teradata VantageCloud suits teams seeking Teradata Database and ClearScape Analytics. Oracle Autonomous AI Lakehouse offers an always-free option subject to capacity limits. Apache Druid is a free open-source analytics database for self-hosting. DuckDB UI fits local browser-based SQL notebook work. Databricks Notebooks is aimed at web-based notebook workflows with a free edition. MonetDB is a free, open-source database under the Mozilla Public License 2.0.

Verdict

Choose CrateDB when real-time operational analytics must combine many data types, SQL access and resilient horizontal scaling, with the option of managed or self-hosted deployment. Look elsewhere if your workload is small enough for a simple local database or if the free tier's limited compute and storage cannot support it; the paid cloud tiers then become the practical path.

The verdict

CrateDB combines broad data-type support with SQL, multiple connection methods and managed or self-managed deployment. The free Cloud plan provides a listed starting configuration; compare its limits with your workload before choosing a plan.

Questions people ask

Is CrateDB open source?

Its open-source core is licensed under Apache 2.0 and can run on-premises, at the edge, in the cloud, or as a managed service.

What does the free Cloud plan include?

CrateDB Cloud Free costs nothing, requires no credit card, and lists 2 vCPUs, 2 GB RAM, 8 GB storage, and daily backups.

How much do Cloud Shared and Dedicated cost?

Cloud Shared is listed at $0.07 a month billed hourly as displayed. Cloud Dedicated is listed at $0.25 a month billed hourly as displayed.

Can CrateDB run outside CrateDB Cloud?

Yes. It can be fully managed or deployed on preferred infrastructure, with Linux, macOS, Docker, and Kubernetes installation guidance.

Which security controls does CrateDB Cloud provide?

Listed controls include authentication, role-based access, TLS/SSL, encrypted storage, audit logging, encryption at rest, IP allowlists, MFA, and isolated clusters by default.

What the maker publishes

Batch ingestion
Batch loading is supported for historical backfills, scheduled updates and large imports. source
Cloud security defaults
The security page says CrateDB Cloud enables encryption at rest, IP allowlists, MFA, and isolated clusters by default. source
Company profile
LinkedIn lists CrateDB as a privately held software company founded in 2013 with 11–50 employees and headquarters in Vienna. source
Compliance
CrateDB Cloud holds ISO 27001 and SOC 2 Type II certifications, according to the security page. source
Connectivity
CrateDB supports the PostgreSQL wire protocol and a native HTTP endpoint. source
Connectivity and SDKs
Applications can connect through the PostgreSQL wire protocol, HTTP endpoints and native drivers or client libraries. source
Data types
It supports time-series, JSON, full-text, vector, geospatial, and structured data in one engine. source
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. source
Documentation depth
Official documentation includes connection guides, ingestion methods, integrations, administration, SQL syntax, functions and API reference material. source
Founded
2013 source
Free plan
Yes source
Full-text feature
Full-text search is provided inside the SQL engine for large unstructured text datasets. source
Funding
Crunchbase lists five funding rounds and 13 investors, including Zetta Venture Partners and Momenta Ventures. source
Geospatial feature
Geospatial types support distance calculations, spatial filtering and location analytics. source
Headquarters
Redwood City, California, United States source
High availability
Built-in replication and automatic failover are designed to keep clusters running through node failures. source
Horizontal scaling
Nodes can be added to increase throughput, with automatic sharding and replication. source
Installation
Installation documentation covers Docker, Kubernetes, Debian, Ubuntu, Red Hat packages and tarball archives; Linux and macOS are explicitly supported download targets. source
Integrations
The integrations page lists Tableau, Power BI, Grafana, Apache Kafka, Apache Spark, dbt, and many other tools and services. source
Integrations
Documented integrations include Tableau Cloud, Power BI, Kafka, StreamSets, DBeaver, Prometheus, Grafana, Airflow, Superset, Metabase, Excel and n8n. source
JSON feature
JSON objects are stored and queried natively with flexible schemas and real-time filtering. source
Legal name
Crunchbase identifies the legal entity as Crate.io Inc., also known as CrateDB, Crate.io and Crate. source
License
The homepage says the open source core is licensed under Apache 2.0 and can run on-premises, at the edge, in the cloud, or as a managed service. source
License
The open-source core is licensed under the Apache License 2.0. source

Checked against the maker's pages on 15 Oct 2026.