Cassandra CQL shell or CQLsh is used to specify the way to use the Cassandra commands. Cassandra, when installed, provides a CQL shell prompt, to facilitate the users to communicate with it by executing the Cassandra commands on CQLsh.
CQLsh Options:
| Options | Uses |
| help | To show help topics about the options of CQLsh commands. |
| version | To see the version of the CQLsh. |
| color | For colored output. |
| debug | To show additional debugging information. |
| execute | To direct the shell to accept and execute a CQL command. |
| file= “file name” | To execute the command in the given file and to exit. |
| no-color | To direct the Cassandra not to use colored output. |
| u “username” | To authenticate a user. |
| p “password” | To authenticate a user with a password. |