70

I'm looking for some gui client for cassandra (like sqlDeveloper) to invoke some basic methods, and run cql queries

Julias
  • 5,752
  • 17
  • 59
  • 84
  • A JDBC driver for Cassandra exists. In principle you can use it with SQuirreL SQL to run CQL queries. I'm a big fan of SQuirreL... but I have never tried it with Cassandra. – mdahlman Aug 27 '12 at 22:16
  • https://javaresolutions.blogspot.com/2018/04/opensource-db-ui-tool-for-cassandra-db.html I followed this, and successfully connected to cassandra running on dockder – vu ledang Nov 22 '19 at 04:43

2 Answers2

65

Dbeaver in its free enterprise version (not open source) is good GUI client for Cassandra. No need of installation. Its portable. Also this client supports more than 20 databases.

Community Edition of Dbeaver doesn't have support for Cassandra, but we can use third party drivers for like Cdata to connect.

Try the following GUI client also

Up to date:

Paid tools

Development stopped

SANN3
  • 9,459
  • 6
  • 61
  • 97
  • 18
    At first time, When we launch the dbeaver then it shows that 'Select new connection type' option to choose, what should i choose for cassandra? – skmahawar Feb 17 '15 at 14:52
  • 22
    It seems that you need to download the free *Enterprise Edition* of *dbeaver* to open cassandra databases. – rekire Jun 17 '15 at 13:47
  • Export using Dbeaver doesn't work on Ubuntu. It always throws NullPointerException :( Has any body faced the same ? – Vinod Jayachandran Oct 30 '15 at 09:11
  • I'm also getting NullPointerException except on Windows and with trying to execute my own queries. I've been looking for GUI client but will likely go with a commercial product specifically for Cassandra. There are a couple inexpensive ones I've found (CassViewer and another one that was only $35 -- I forgot the name). – GregInWI2 Nov 16 '15 at 14:27
  • 2
    It doesn't support on free edition. There is no choice for Cassandra on Connection Type – firstthumb Feb 29 '16 at 09:12
  • Yup, we can't use dbeaver enterprise free version to connect to Cassandra, it is not listed in the list of database supported in new Connection Type. – Prasad Revanaki Dec 08 '16 at 11:08
  • @PrasadRevanaki Try old version – SANN3 Dec 12 '16 at 11:25
  • I confirm, tried free enterprise edition and it contains Cassandra CQL option(4.05 EE version vs 4.10 of CE). Link to it you may find on community edition page and it's said: _EE version is also free but it is not open-source._ – Bryn Jul 10 '17 at 14:03
  • 1
    DBeaver Enterprise version till 3.x.x supports Cassandra connection. You would need to configure the Driver for connection. Search for DBeaver Cassandra connection and should find few blogs From 4.x.x version, DBeaver Enterprise is limited to few days of free usage. – James Jithin Oct 19 '17 at 03:31
  • 3
    Go go https://www.dbschema.com/cassandra-jdbc-driver.html The driver is provided at https://www.dbschema.com/jdbc-drivers/CassandraJdbcDriver.zip – twindai Dec 07 '17 at 13:22
  • 1
    @twindai thanks for the dbschema.com driver link, it was useful. I documented the exact steps how to set it up with SQuirreL SQL: https://gist.github.com/attila123/d52d521a0f25fc912ec86a77c7c0a30d – Attila123 Nov 20 '19 at 17:58
  • @Attila123 Thank you, this was very helpful! One issue I had was I had to select all the files in the folder I extracted the driver files to, not just the folder they were in. Otherwise, this was perfect! – raphael75 Dec 19 '19 at 19:28
8

Check out Helenos - it's a simple web based tool. Cql is now supported (from Version 1.3).

Stuy1974
  • 120
  • 3
  • 7
tomekkup
  • 353
  • 2
  • 14