Database Monsters of the World Connect! Virtual Conference | January 12-14
Register Now

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