Cassandra Data Modeling Tools
There are several tools available to help you design and manage your Cassandra schema and build queries.
-
Hackolade is a data modeling tool that supports schema design for Cassandra and many other NoSQL databases. Hackolade supports the unique concepts of CQL such as partition keys and clustering columns, as well as data types including collections and UDTs. It also provides the ability to create Chebotko diagrams.
-
Kashlev Data Modeler is a Cassandra data modeling tool that automates the data modeling methodology described in this documentation, including identifying access patterns, conceptual, logical, and physical data modeling, and schema generation. It also includes model patterns that you can optionally leverage as a starting point for your designs.
-
IDE Plugins - There are CQL plugins available for several Integrated Development Environments (IDEs), such as IntelliJ IDEA and Apache NetBeans. These plugins typically provide features such as schema management and query execution.
Some IDEs and tools that claim to support Cassandra do not actually support CQL natively, but instead access Cassandra using a JDBC/ODBC driver and interact with Cassandra as if it were a relational database with SQL support. Wnen selecting tools for working with Cassandra you’ll want to make sure they support CQL and reinforce Cassandra best practices for data modeling as presented in this documentation.
Material adapted from Cassandra, The Definitive Guide. Published by O’Reilly Media, Inc. Copyright © 2020 Jeff Carpenter, Eben Hewitt. All rights reserved. Used with permission.
