Skip to content

Native SQL

CrateDB is easily accessible for developers via the widely 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, 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 is compatible with most SQL tools, interfacing through the PostgreSQL wire protocol, JDBC, and REST.

"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

Product documentation

SQL Compatibility

SQL Standard Compliance

SQL Statements

General SQL

Additional resources

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


February 18, 2022
We’ve created many integration-focused tutorials to help you use CrateDB with other awesome tools and libraries.

Interested in learning more?