[Legacy] CrateDB Clients and Tools

CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.

See also

We are also maintaining a more up-to-date list of CrateDB integration tutorials.

Tip

CrateDB supports the PostgreSQL wire protocol. Accordingly, many clients that work with PostgreSQL also work with CrateDB.

You can try this out for yourself:

• Configure a PostgreSQL connection, but point your client to a CrateDB server instead of a PostgreSQL server

• Authenticate as the crate superuser with no password

• Specify the doc schema, if you are asked for a database name

• For example, your connection string to a local database might look like postgresql://crate@localhost:5432/doc

Check out the client compatibility notes and implementation differences for information about known limitations.

If you run into issues, please let us know using the Feedback section at the bottom of this page. We regularly update CrateDB to accomodate new PostgreSQL clients.

Clients

Below is a selection of CrateDB client libraries.

Pick your library, and start building!

Language	Name	Maintainer	Official support
C# (.NET)	Npgsql	Community	✔️ (>= CrateDB 4.2.0)
C# (.NET)	CrateDB Npgsql fork	Crate.IO	✔️
Erlang	craterl	Crate.IO
Go	pgx	Community	✔️
Java	PostgreSQL JDBC	Community	✔️ (>= CrateDB 4.2, with known issues)
Java	crate-jdbc	Crate.IO	✔️
Node.JS	node-postgres	Community	✔️
Node.JS	crate-connect	Community
Node.JS	cratejs	Community
Node.JS	node-crate	Community
Perl	DBD::Crate	Community
PHP	CrateDB PDO	Crate.IO	✔️
PHP	CrateDB DBAL	Crate.IO	✔️
PHP	CrateDB driver for Laravel	Community
Python	crate-python	Crate.IO	✔️
Python	asyncpg	Community	✔️
Ruby	crate_ruby	Crate.IO
Ruby	activerecord-crate-adaptor	Crate.IO
Scala	crate-scala	Community
Scala	crate-connector	Community

Tools

CrateDB integrates with many different tools. Some of these are:

• Azure Functions

  An Azure Function is a short-lived, serverless computation that is triggered by external events. Learn how to create a data enrichment pipeline in our tutorial.

• Grafana

  Grafana allows you to query, visualize, alert on and understand your metrics and time series data. Read our tutorial on how to pair CrateDB with Grafana.

• Pentaho

  Pentaho prepares and blends data, delivering business analytics from any source. You can connect to CrateDB clusters by using Pentaho Kettle and the standalone version of our JDBC driver.

• R

  R is a programming language and software environment geared towards statistical computing. Read our guide on how to create a Machine Learning pipeline.

• SQLPad

  SQLPad is a web app for writing, running, and visualizing queries. Read our tutorial on how to set up CrateDB with SQLPad.

• StreamSets Data Collector

  The StreamSets Data Collector is a lightweight and powerful engine that streams data in real time. Read our guide on building data stream pipelines.

See also

For more tools and tutorials on how to use CrateDB with them, refer to the integrations category on our blog or the integrations section in our documentation.

Note

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