Scylla University Live | July 28 & 29 Free Virtual Training Event
Learn More >

Clients Table

New in version 3.3.

This document describes how to work with Scylla’s client table, which provides real-time information on CQL clients currently connected to the Scylla cluster.

Viewing - List Active CQL connections

SELECT address, port FROM system.clients;

Example output:

address    | port
------------+------- | 33296 | 33298

Significant columns in the Client table:



address (PK)

Client’s IP address

port (CK)

Client’s outgoing port number


Username - when Authentication is used


Scylla node shard handing the connection