CQL Reference
===============

.. toctree::
   :maxdepth: 2
   :hidden:

   cqlsh
   appendices
   compaction
   consistency
   consistency-calculator
   ddl
   dml
   types
   definitions
   secondary-indexes
   time-to-live
   functions
   wasm
   json
   mv
   describe-schema
   service-levels
   cql-extensions.md

cqlsh - The CQL Shell
-----------------------
``cqlsh`` is a command line shell for interacting with ScyllaDB through CQL.

* :doc:`CQLSh: the CQL shell </cql/cqlsh>`


CQL - Apache Cassandra Query Language
----------------------------------------

The Apache Cassandra Query Language (CQL) is the primary language for communicating with the ScyllaDB database. 
It allows you to create keyspaces and tables, insert and query tables, and more.

  * :doc:`Reserved CQL Keywords and Types (Appendices) </cql/appendices>`
  * :doc:`Compaction </cql/compaction>`
  * :doc:`Consistency Levels </cql/consistency>`
  * :doc:`Consistency Levels Calculator</cql/consistency-calculator>`
  * :doc:`Data Definition </cql/ddl>`
  * :doc:`Data Manipulation </cql/dml>`
  * :doc:`Data Types </cql/types>`
  * :doc:`Definitions </cql/definitions>`
  * :doc:`Global Secondary Indexes </cql/secondary-indexes>`
  * :doc:`Expiring Data with Time to Live (TTL) </cql/time-to-live>`
  * :doc:`Functions </cql/functions>`
  * :doc:`JSON Support </cql/json>`
  * :doc:`Materialized Views </cql/mv>`

ScyllaDB CQL Extensions - CQL Extensions Provided by ScyllaDB
--------------------------------------------------------------

ScyllaDB provides additional features that extend the Apache CQL.

* :doc:`ScyllaDB CQL Extensions </cql/cql-extensions>`