Overview

CrateDB executes complex SQL queries on large datasets in milliseconds, while supporting high-volume concurrent reads and writes. Its distributed execution engine ensures consistent performance under heavy load.

• Real-time ingestion
• Real-time query capabilities
  • Aggregations
  • Ad-hoc queries
  • Hybrid search
  • AI features
• Distributed SQL query engine

With native SQL support and compatibility via the PostgreSQL Wire Protocol, CrateDB is easy to adopt. It supports joins, aggregations, subqueries, user-defined functions and more, letting teams leverage existing skills and tools. 

• Native SQL Syntax
• Functions (built-in and UDF)
• Common Table Expressions (CTEs)
• PostgreSQL Wire Protocol

CrateDB manages all your data models in a single system. You can ingest high velocity time series, store large JSON documents, run vector search, or index geospatial shapes without building separate pipelines or services. Learn more >

• The multi-model approach
  • Time series data
  • JSON data
  • Relational data
  • Geospatial data
  • Full-text data
  • Vector data
  • BLOB data
• Dynamic schema
• Automatic indexing

CrateDB connects easily to your data ecosystem. You can integrate your applications, tools, and services through standard interfaces without lock in or custom integration layers. Learn more >

• PostgreSQL wire protocol
• HTTP endpoint
• Drivers & client libraries
• MCP server

CrateDB stores data in a way that optimizes both performance and efficiency. Tables are stored in shards that can be distributed across the cluster, while analytical workloads benefit from columnar storage that accelerates scans and aggregations. Learn more >

• Columnar & row-based storage
• Sharding
• Partitioning
• Replication
• Compression
• Consistency & durability
• Data tiering 
• Backup & restore

Built on a shared-nothing, self-balancing architecture, CrateDB provides high availability and horizontal scalability out of the box. Add or remove nodes on the fly, recover from hardware failures automatically, and scale without downtime. Learn more >

• Distributed database
• Shared-nothing architecture
• Node architecture
• Self-balancing cluster
• High availability
• Horizontal scalability

Use CrateDB Cloud to set up, operate and scale CrateDB with just a few clicks. Fully managed service. Operated by the CrateDB engineers.

• Multiple plans designed for a wide range of use-cases from small-scale applications to enterprise-level deployments.
• Payment via credit card, invoicing, or marketplace billing integration.

You can also deploy CrateDB on your own infrastructure. It is operated by your own team.

• Run CrateDB in Docker or Kubernetes as well as on Linux, Windows, and Mac.
• Install and run CrateDB wherever you need: on developer laptops, on Private or Public Cloud, On-Premises, or Edge to meet your organization's unique needs. It also supports Hybrid scenarios out of the box.
• Pick the support option that suits your operational needs.

CrateDB Cloud ensures secure data management with its encryption and authentication mechanisms. With its ISO 27001 certification, CrateDB Cloud meets international standards for information security management systems. CrateDB is also SOC 2 Type 2 compliant on Azure and AWS. Learn more >

• Authentication
• Authorization
• Encryption
• Audit logging
• Compliance & certification

• Select your preferred Standard or Premium support plan with contractual SLAs.
• Get access to technical expertise for optimization, risk mitigation and cost optimization.
• Get assigned a dedicated Customer Success Manager when dealing with critical workloads.

Learn more >