1. cassandra-cqlsh

Cqlsh - Cassandra Query Language Shell

Cqlsh (Cassandra Query Language Shell) is a command-line interface for interacting with Apache Cassandra. It allows users to explore, manage, and query Cassandra databases using the CQL (Cassandra Query Language).


The syntax for using cqlsh is as follows:

cqlsh [hostname] [-u username] [-p password]


To start a cqlsh session, simply enter the following command in your terminal:


This will start cqlsh with the default settings.


The output of the cqlsh command will show the cqlsh prompt, which indicates that you are connected to a Cassandra database.

Connected to Test Cluster at localhost:9042.
[cqlsh 5.0.1 | Cassandra 3.11.10 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.


When you start cqlsh, it connects to the specified Cassandra cluster or the default localhost:9042 if no hostname is provided. Once connected, you can use the CQL commands to interact with the database. The cqlsh prompt indicates that you are connected to a Cassandra database and allows you to enter CQL commands.


Cqlsh is used for managing and querying Cassandra databases from the command-line interface. It is a powerful tool that allows you to create, modify and delete keyspaces, tables, and indexes. You can also insert, update, and delete data from your databases.

Important Points

  • Cqlsh provides a convenient and powerful way to interact with Cassandra
  • Cqlsh is useful for exploring, managing, and querying Cassandra databases
  • The default port for cqlsh is 9042
  • You can connect to a remote Cassandra cluster by specifying the hostname
  • Cqlsh supports tab completion for CQL commands and keywords
  • Cqlsh supports executing scripts from a file using the SOURCE command


In this tutorial, we learned about cqlsh and how to use it to interact with a Cassandra database. We saw how to start a cqlsh session, the output and prompt, how it works, its uses, and important points to keep in mind. Cqlsh is an essential tool for any developer working with Cassandra, and mastering it can help streamline database operations.

Published on: