Cassandra / ScyllaDB

​

Quick Setup

​

Connection Settings

​

Connection URLs

cassandra://user:password@host:9042/keyspace
scylladb://user:password@host:9042/keyspace

​

Example Configurations

​

Amazon Keyspaces (IAM)

​

SSL/TLS

​

Features

​

CQL Editor

SELECT * FROM users WHERE user_id = 123e4567-e89b-12d3-a456-426614174000;

INSERT INTO users (user_id, name, email, created_at)
VALUES (uuid(), 'Alice', 'alice@example.com', toTimestamp(now()));

UPDATE users USING TTL 86400
SET email = 'new@example.com'
WHERE user_id = 123e4567-e89b-12d3-a456-426614174000;

CREATE TABLE IF NOT EXISTS events (
    event_id timeuuid,
    user_id uuid,
    event_type text,
    payload text,
    PRIMARY KEY ((user_id), event_id)
) WITH CLUSTERING ORDER BY (event_id DESC);

CREATE INDEX ON users (email);

​

CQL Notes

• No JOINs or subqueries: denormalize, or run sequential statements.
• Every SELECT needs the full partition key in WHERE, or ALLOW FILTERING (a cluster scan, slow in production).
• Lightweight transactions: conditional writes with IF, e.g. INSERT INTO users (...) IF NOT EXISTS;.
• TTL and writetime: USING TTL 3600; SELECT TTL(value), WRITETIME(value) FROM cache WHERE key = 'k1';.

​

Troubleshooting

​

Limitations

• Materialized views, UDTs, UDFs, and UDAs do not appear in the sidebar. Query system_schema tables in the CQL editor instead.
• Table options (compaction, compression, gc_grace_seconds) and clustering order are not shown in the structure view.
• DataStax Astra DB is not supported: the driver cannot load a Secure Connect Bundle.
• Counter columns cannot be set with a plain UPDATE. The grid lets you edit one, but the statement it generates is rejected. Use UPDATE ... SET c = c + 1 in the CQL editor instead.
• Multi-DC settings are not configurable.