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.
Plans
Every plan and priceShared Free
Shared
Dedicated
CrateDB Cloud Custom
Free plan
Getting started
- Open https://cratedb.com/
- Choose CrateDB Cloud or download for Linux or macOS
- Follow the Docker or Kubernetes deployment guides when applicable
- Select the free, Shared, Dedicated, or Custom plan
- Connect through PostgreSQL wire protocol or the native HTTP endpoint
- 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.