DBeaver¶

DBeaver is a multipurpose cross-platform database tool for developers, database administrators, analysts, and everyone working with data.

It is available as an open-source version DBeaver Community and as a commercial version DBeaver PRO.

Connect¶

Please specify database URL and credentials of your CrateDB cluster. For connecting to CrateDB, the standard PostgreSQL JDBC Driver will be used.

When connecting to CrateDB Self-Managed on localhost, for evaluation purposes, use:

jdbc:postgresql://localhost:5432/crate

When connecting to CrateDB Cloud, use:

jdbc:postgresql://<clustername>.cratedb.net:5432/crate

Usage¶

Use the tree menu on the left-hand pane to navigate to the doc schema and its tables. Navigate to the Data tab to browse your table data.

Learn¶

Guides

Blog: Use CrateDB With DBeaver

DBeaver is a multipurpose database tool for developers and database administrators. With the help of the CrateDB JDBC Standalone Driver, you can use DBeaver with CrateDB.

https://cratedb.com/blog/cratedb-dbeaver

Notes

Note

A few data types of CrateDB need special considerations.

ARRAY types are recognised as such in reads, also work for inserts through the GUI. They need to use curly brackets syntax {1,2} instead of [1,2].
OBJECT types are seen as string, and are ok to insert via GUI.
GEO_POINT types are seen as STRING, for insert through GUI, please use parentheses.
GEO_SHAPE types are seen as STRING, are ok to insert via GUI.
FLOAT_VECTOR types are seen as ARRAY on read, and can be inserted using the GUI with same considerations as ARRAYs.

Note

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