CrateDB Clients and Tools¶

About CrateDB¶

CrateDB is a distributed and scalable open-source SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.

Users are operating CrateDB clusters that store information in the range of billions of records, and terabytes of data, equally accessible without any retrieval penalty on data point age.

Connectivity¶

This section introduces you to the canonical set of database drivers, client- and developer-applications, and how to configure them to connect to CrateDB. Just to name a few, it is about the CrateDB Admin UI, crash, psql, DataGrip, and DBeaver applications, the Java/JDBC/Python drivers, the SQLAlchemy and Flink dialects, and more.

IDE

Learn how to connect to CrateDB using a database IDE like DataGrip or DBeaver.

CLI

Learn how to connect to a CrateDB cluster using command-line based terminal programs.

Driver

Learn how to configure your favorite client driver library to connect to a CrateDB cluster.

Integrations¶

CrateDB integrates well with a diverse set of applications and tools concerned with analytics, visualization, and data wrangling, in the areas of ETL, BI, metrics aggregation and monitoring, and more.

Overview

Use CrateDB with popular applications, frameworks, and tools.

ETL

Use ETL applications and frameworks for transferring data in and out of CrateDB.

Analytics

Analyze information in your CrateDB cluster.

Visualization

Visualize information in your CrateDB cluster.

Note

Contributions are welcome.

If you would like to add items about integrations with other tools to this documentation section, please get in touch, or directly edit this page on GitHub. You will find corresponding links within the topmost right navigation element.