CrateDB Drivers and Integrations

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

Connect to CrateDB using a database IDE like DataGrip or DBeaver.

CLI

Connect to CrateDB using command-line based terminal programs.

Drivers

List of HTTP and PostgreSQL client drivers, and tutorials.

DataFrame Libraries

Connectivity with DataFrame libraries like pandas and Dask.

ORM Libraries

Connectivity with ORM libraries like SQLAlchemy.

Integrations

CrateDB integrates with a diverse set of applications and tools concerned with analytics, visualization, and data wrangling, in the areas of data loading and export (ETL), business intelligence (BI), metrics aggregation and monitoring, machine learning, and more.

Overview

Learn how to use CrateDB with popular applications, frameworks, and tools. All on one page.

ETL

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

System Metrics

Integrations and long-term storage for systems monitoring tools like Prometheus and Telegraf.

Data Visualization

Visualize information in your CrateDB cluster.

Business Intelligence

Analyze information in your CrateDB cluster.

Machine Learning

Adapters and integrations with machine learning frameworks.

Note

Contributions to the pages in this section and subsections are much 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.

See also

Looking for the previous content on this page? Visit [Legacy] CrateDB Clients and Tools.