DataGrip

DataGrip is a cross-platform database IDE that is tailored to suit the specific needs of professional SQL developers.

It is available as a standalone application and is also included into other JetBrains products like IntelliJ IDEA and PyCharm.

Connecting DataGrip to CrateDB uses the [CrateDB JDBC Driver].

Install

For connecting to CrateDB, install the CrateDB JDBC Driver using the “Custom JARs” option when adding a database driver.

crate-jdbc-standalone is the right choice here. For example, download and use the crate-jdbc-standalone-latest.jar JAR file, and select the driver class io.crate.client.jdbc.CrateDriver.

Connect

Now, you can add a Data Source using the CrateDB database driver. Please specify database URL and credentials of your CrateDB cluster.

For connecting to CrateDB Self-Managed or CrateDB Cloud, use a connection URL like:

jdbc:crate://<host>:5432/

Usage

After refreshing, you can browse the data tree, and use the Query Console.

Learn

Tutorials

• Blog: Use CrateDB With DataGrip

Product

• CrateDB and DataGrip

Notes

Note

We are tracking interoperability issues per Tool: DataGrip, and appreciate any contributions and reports.