The Complete Production SOP: How to Deploy and Run ScyllaDB High-Throughput CQL Sharded NoSQL in Autonomous AI Agents

---
name: "scylladb-cql-sharded-nosql"
description: "Architect ultra-low latency, multi-million write workloads using C++ based ScyllaDB."
metadata:
  author: "ScyllaDB"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "design scylladb cql schema"
  - "configure twcs compaction scylladb"
  - "use shard-aware scylla driver"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# ScyllaDB High-Throughput CQL Sharded NoSQL

Enforces deterministic partition budgeting (<100MB per partition), TWCS window alignments, and direct-to-CPU-core shard pooling across Go, Rust, and Node.js.

import { Client, policies } from '@scylladb/cassandra-driver';

export const scyllaClient = new Client({
  contactPoints: process.env.SCYLLA_NODES ? process.env.SCYLLA_NODES.split(',') : ['127.0.0.1'],
  localDataCenter: process.env.SCYLLA_DC || 'datacenter1',
  keyspace: 'telemetry_stream',
  policies: {
    loadBalancing: new policies.loadBalancing.TokenAwarePolicy(new policies.loadBalancing.DCAwareRoundRobinPolicy())
  },
  pooling: {
    coreConnectionsPerHost: {
      [policies.defaultProtocolOptions.defaultPort]: 1 // Scylla shard-aware driver negotiates connection per core
    }
  }
});

CREATE KEYSPACE IF NOT EXISTS telemetry_stream
WITH replication = {'class': 'NetworkTopologyStrategy', 'datacenter1': 3}
AND durable_writes = true;

CREATE TABLE IF NOT EXISTS telemetry_stream.sensor_readings (
    device_id uuid,
    date_bucket date,          -- Format: YYYY-MM-DD to avoid unbounded partition growth
    event_timestamp timestamp,
    metric_name text,
    metric_value double,
    PRIMARY KEY ((device_id, date_bucket), event_timestamp, metric_name)
)
WITH CLUSTERING ORDER BY (event_timestamp DESC, metric_name ASC)
AND compaction = {
    'class': 'TimeWindowCompactionStrategy',
    'compaction_window_size': '1',
    'compaction_window_unit': 'DAYS',
    'timestamp_resolution': 'MILLISECONDS',
    'max_threshold': '32',
    'unchecked_tombstone_compaction': 'true'
}
AND default_time_to_live = 2592000; -- 30-day TTL matching SSTable drop boundaries