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 in 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¶

Guides

Blog: Use CrateDB With DataGrip

DataGrip is a cross-platform database IDE (Integrated Development Environment) that is tailored to suit the specific needs of professional SQL developers. With the help of the CrateDB JDBC Standalone Driver, you can use DataGrip with CrateDB.

https://cratedb.com/blog/use-cratedb-with-datagrip-an-advanced-database-ide

Notes

Note

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