Use the CQL console to interact with the databases in your datacenter
Mission Control lets you use the CQL console in the UI to interact with the databases in your datacenter using the Cassandra Query Language (CQL). The CQL console is a web-based interface that provides a way to execute CQL commands and view the results.
You can use the CQL console to execute any supported CQL commands against your database, for example to create keyspaces or insert data. For a list of available commands, see the CQL shell commands reference in the Hyper-Converged Database (HCD), DataStax Enterprise (DSE), or Apache Cassandra® documentation.
Connect to the CQL console
-
In the Mission Control UI navigation menu, select your project, and then select your database cluster.
-
Click CQL Console.
-
Select your datacenter from the list of available datacenters.
-
Enter your username and password.
cqlsh-pod container
When you deploy a Mission Control cluster, a cqlsh-pod is automatically created.
This pod supports the CQL console in the Mission Control UI.
The cqlsh-pod is a container that runs the cqlsh utility, allowing you to interact with your database cluster using CQL commands.
The pod serves as the backend for the CQL console in the UI.
If needed, you can connect to the pod manually using kubectl exec.
The pod includes the following labels:
-
app.kubernetes.io/name=cqlsh
-
app.kubernetes.io/part-of=missioncontrol
-
cassandra.datastax.com/datacenter=DATACENTER_NAME
-
missioncontrol.datastax.com/cluster-name=CLUSTER_NAME
-
missioncontrol.datastax.com/cluster-namespace=PROJECT_SLUG
-
pod-template-hash=POD_HASH
The image is included in the airgap bundle for Mission Control.
For a list of available container images and versions, see the Mission Control release notes.
The cqlsh-pod image is not published on Docker Hub because the underlying code is proprietary.
Download the CQL command line shell
You can download the CQL command line shell (cqlsh) utility on your local machine to interact with your database cluster using CQL commands outside of the Mission Control UI.
To download the cqlsh utility from the Mission Control UI, do the following:
-
In the Mission Control UI navigation menu, select your project, and then select your database cluster.
-
Click CQL Console.
-
Click Download Command Line Shell. The DataStax downloads page opens in a new browser tab.
-
Select your database Version from the list of available versions, and then select the option to agree to the terms of the license agreement.
-
Click Download. The
cqlshpackage downloads to your local machine. -
Start the
cqlshtool. For more information, see Starting thecqlshtool in the HCD, DSE, or Cassandra documentation.
