Overview
DBeaver EE supports Cassandra schema browser, data viewer and CQL queries execution.
Also it supports various administrative tools.
You can connect directly to a server or use SSH tunneling or SOCKS proxy.
DBeaver uses DataStax Java driver 3.5.1 to operate with server. It supports Cassandra servers 2.x, 3.x or higher.
Connecting to Cassandra cluster
Browsing Cassandra tables
You can browse, view, edit and filter Cassandra tables the same way as with regular (relational) tables. However, being a distributed key-value database, Cassandra doesn’t support any kind of referential integrity. There are no foreign keys, references, etc. Note that Cassandra has very advanced (comparing to relational databases) data type system.
Each column may be a collection, map or set of values (with very big number of values). In some cases this makes browsing data in the “Grid” mode inconvenient.
Executing CQL
CQL (Cassandra Query Language) is a kind of very simple SQL language dialect.
It supports simple SELECT queries, DDL statements (like CREATE TABLE) and some other. You can use standard DBeaver SQL editor to execute CQL queries.
DBeaver EE supports Cassandra query execution, results scrolling, data export/import, mock data generation and other features.
Data viewer (of individual tables or custom CQL query results) query tracing is supported.