Overview

CrateDB offers support for multiple data formats within a single database and even within a single table, thanks to its dynamic data schema.

• The Multi-model Approach
• Time Series Data
• JSON Data
• Vector Data
• Full-Text Data
• BLOB Data
• Relational Data

CrateDB provides native SQL support, ensuring ease of use, flexibility, and seamless data integration across diverse ecosystems. It supports a broad spectrum of operations, including joins, aggregations, indexes, subqueries, and more, all accessible through SQL. CrateDB's implementation of the PostgreSQL Wire Protocol ensures compatibility with many other solutions.

• Native SQL Syntax
• PostgreSQL Wire Protocol

CrateDB employs a distributed shared-nothing architecture, allowing seamless scalability up to hundreds of nodes with minimal operational effort. Each node in the cluster is capable of executing every operation, ensuring equality across all nodes. This promotes high availability, even during data center outages or upgrades.

• Distributed Database
• Node Architecture
• Cluster State Management
• Horizontal Scalability
• High Availability

CrateDB optimizes data storage by partitioning and sharding large tables, ensuring balanced data distribution and improved query performance. It also combines the Lucene Engine and columnar storage to facilitate instant aggregations, advanced indexing strategies, and data replication at the table level for enhanced fault tolerance and read performance.

• Data Storage
• Partitioning
• Sharding
• Replication
• Atomicity, Durability, and Consistency
• Advanced Indexing and Columnar Storage
• Data Tiering: Hot, Warm, and Cold Data 

CrateDB delivers superior performance by executing complex SQL queries on large datasets in milliseconds. Its distributed execution engine supports high-volume concurrent reads and writes, ensuring robust performance even under heavy loads.

• Query performance
• Distributed Query Engine
• Distributed Reads and Writes

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

• Deploy your cluster seamlessly on AWS, Microsoft Azure, or Google Cloud.
• 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.
• Available through Marketplaces:
  • AWS Marketplace
  • Azure Marketplace
  • GCP Marketplace

CrateDB Self-Managed allows you to 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 offers many benefits to scale your analytical workloads:

• Flexible Deployment Options: Choose between fully managed or hybrid deployments to suit your infrastructure needs and operational preferences.
• Instant Deployment: Simply press a button to have your cluster deployed within seconds, allowing you to start leveraging CrateDB’s power immediately.
• Zero Downtime Upgrades: Seamlessly upgrade your systems without any disruption, ensuring continuous availability and smooth performance.
• Competitive Pricing: Benefit from a cost-effective solution designed to deliver high value without compromising on performance or features. View our pricing plans ›

CrateDB Cloud offers enhanced productivity with some advanced tools, including:

• Automation: SQL Scheduler, table policies and logging.
• Embedded query console.
• Connectors to import data on demand or in real-time.
• CrateDB Cloud CLI to programmatically create and manage CrateDB deployments from your local development environment all the way to the cloud.
• Automatic backup.

CrateDB offers a wide range of integrations:

• Data Ingestion: S3, Azure Storage Container, Debezium, and more.
• Data Visualization: Grafana, Tableau, PowerBI ...

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.

• • Security
  • Data encryption
  • Authorization
  • Auditing
  • ISO 27001 Certification
  • SOC 2 Type 2 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.

Training: The CrateDB Academy provides a comprehensive range of free courses, equipping you with the knowledge to maximize CrateDB’s potential. Additionally, we offer certification exams to validate your expertise and ensure your team is proficient in leveraging CrateDB.

Expertise: Our experienced Solution Engineering team is available to provide personalized assistance, ensuring that your project succeeds at every stage. Whether it's strategic advice or technical troubleshooting, we’re here to support your unique needs.