Clients Table¶

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

Viewing - List Active CQL connections¶

SELECT address, port FROM system.clients;

Example output:

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

Significant columns in the Client table:

Parameter	Description
address (PK)	Client’s IP address
port (CK)	Client’s outgoing port number
username	Username - when Authentication is used
shard_id	ScyllaDB node shard handing the connection