The Guide for Time Series Data Projects is out.

Download now
Skip to content

Native SQL

CrateDB offers a standards-based SQL implementation focused on achieving ANSI SQL compatibility, making it easily accessible for developers via the well-known and powerful SQL language.

CrateDB’s distributed SQL query engine combines inverted indexes and columnar data structures with a modern query planner, enabling CrateDB to perform aggregations, JOINs, sub-selects, common table expressions, and ad-hoc queries at in-memory speed. CrateDB implements Native SQL, including joins, aggregations, indexing, sub-queries, user-defined functions and views. It also offers rich support for full-text search, geospatial queries, and nested JSON object columns, all accessible with SQL.

A major advantage of SQL is its ease of integration. CrateDB implements the PostgreSQL Wire Protocol, ensuring compatibility with most SQL tools using the PostgreSQL drivers. It provides two primary client interfaces: one via the PostgreSQL Wire Protocol and another through an HTTP endpoint. Designed for SQL-enabled ETL, reporting, and development frameworks, CrateDB offers flexibility to integrate with various data stack tools, preventing vendor lock-in and promoting adaptability.

"CrateDB allows us to do real-time dashboards on very big streaming and historic datasets in a simple way. We can scale the system easily as we grow the load and customers and have it all done with SQL."
Christopher Müller
"Having a standardized SQL language is a big advantage with CrateDB. That makes it very easy for people to access this data and work with it in different tools like Grafana or Tableau."
Alexander Mann
Owner Connected
Warehouse Architecture
TGW Group

On-demand Workshop 2023

Introduction to CrateDB and its Architecture 

Timestamp:  11:40–12:43

CrateDB at Carnegie Mellon University CMU Database Group

CrateDB: Distributed SQL Database Built on Top of Lucene 

Timestamp:  3:30–5:10

Additional resources

Interested in learning more?