All Features

All features of CrateDB at a glance.

Functional

• SQL
• Document Store
• Relational / JOINs
• Search: FTS, Geo, Vector, Hybrid
• BLOB Store

CrateDB combines the power of Lucene with the advantages of industry-standard SQL.

Operational

• Clustering
• Snapshots
• Cloud Native
• Storage Layer
• Hybrid Index

CrateDB scales horizontally using a shared-nothing architecture, inherited from Elasticsearch.

Advanced

• Advanced Querying
• Generated Columns
• Server-Side Cursors
• Foreign data wrappers
• User-Defined Functions
• Cross-Cluster Replication

Advanced features supporting daily data operations, all based on standard SQL.

Related sections

Connect to CrateDB using traditional database drivers, and integrate CrateDB with popular 3rd-party applications in open-source and proprietary software landscapes.

Connectivity

Connect to your CrateDB cluster using drivers, connectors, adapters, and frameworks.

What’s inside: Connectivity and integration options with database drivers and applications, libraries, and frameworks.

About connectivity options with CrateDB

Import and Export

Import data into and export data from your CrateDB cluster.

What’s inside: A variety of options to connect and integrate with 3rd-party ETL applications.

About time series data import and export