Using database IDEs with CrateDB

Mostly through its PostgreSQL interface, CrateDB supports working with popular database IDE (Integrated Development Environment) applications.

DataGrip

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

Connecting DataGrip to CrateDB uses the vanilla PostgreSQL JDBC Driver, the blog article Blog: Use CrateDB With DataGrip explains how it works.

image image

Caution

Please note while the query console works well, you will notice that many UI actions do not work yet. We are tracking corresponding gaps at Tool: DataGrip, and appreciate any contributions to improve the situation.

DBeaver

DBeaver is a multipurpose database tool for developers and database administrators. Because CrateDB provides a JDBC driver, you can access CrateDB with any client tool that supports JDBC drivers.

Connecting DBeaver to CrateDB uses the legacy PostgreSQL JDBC Driver, the blog article Blog: Use CrateDB With DBeaver explains how it works.

image image