CQLSH stands for Cassandra Query Language Shell. It is an environment through which the users can create schemas, insert data, and execute queries. Like Structured Query Language (SQL), it also has data definition, data manipulation commands, and clauses. The data definition commands are: create, alter, drop, etc. The data manipulation commands are: insert, update, delete, and batch. Clauses include select, where, and order by. It is implemented using Python native driver protocol. It has specialised commands for tracing queries, capture for writing out the output to a file, etc.