Scylladb Data Modeling

ScyllaDB CQL data modeling patterns and anti-patterns, including compaction strategy choice, TTL-based expiration, tombstone management, and lightweight transactions. Use when designing tables, reviewing schemas, migrating from SQL or MongoDB, setting data retention, or troubleshooting performance issues caused by schema problems or deletes, or writing conditional (LWT) statements. Vector and full-text indexes go to scylladb-vector-search; DynamoDB API tables go to scylladb-alternator. Triggers on "design schema", "ScyllaDB data model", "partition key", "clustering column", "primary key", "CQL

9 stars 6 forksAI, LLMs & Agents Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add scylladb/agent-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add scylladb/agent-skills --skill scylladb-data-modeling
Manual install
git clone --depth 1 https://github.com/scylladb/agent-skills.git /tmp/agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/agent-skills/skills/scylladb-data-modeling ~/.claude/skills/scylladb-data-modeling

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# ScyllaDB Data Modeling

If the task goes beyond this skill, use the parent `scylladb` skill for a ScyllaDB overview and the list of other ScyllaDB skills. If it is not installed, fetch it from `https://raw.githubusercontent.com/scylladb/agent-skills/main/skills/scylladb/SKILL.md`.

CQL data modeling patterns and anti-patterns for ScyllaDB. Bad schema is the root cause of most ScyllaDB performance issues — no amount of cluster scaling can fix a fundamentally wrong data model.

## When to Use This Skill

- Designing a new ScyllaDB schema from scratch
- Migrating from SQL/relational databases, MongoDB, or Cassandra to ScyllaDB
- Reviewing existing table designs for performance issues
- Troubleshooting slow queries, timeouts, or hot nodes
- Deciding how to structure primary keys (partition key + clustering columns)
- Modeling time-series, IoT, or event data
- Seeing large partition warnings in logs
- Encountering `ALLOW FILTERING` in queries or code reviews
- Adding secondary indexes or materialized views
- Choosing a compaction strategy, or setting TTLs and retention on a table
- Reads slowed by deletes, expired data, or tombstone warnings
- Writing conditional statements (`IF NOT EXISTS`, `IF EXISTS`, `IF <condition>`) or choosing serial consistency

For adjacent topics, use the sibling skill instead:

- Connecting a driver, choosing a driver, or preparing statements: `scylladb-cloud-setup`
- Vector columns, vector indexes, and ANN queries: `scylladb-vector-search`
Read the full skill on GitHub

Details

Skill name
scylladb-data-modeling
Path
skills/scylladb-data-modeling/SKILL.md
License
Apache-2.0
Repo updated
28 October 2026

FAQ

What does the Scylladb Data Modeling skill do?

ScyllaDB CQL data modeling patterns and anti-patterns, including compaction strategy choice, TTL-based expiration, tombstone management, and lightweight transactions. Use when designing tables, reviewing schemas, migrating from SQL or MongoDB, setting data retention, or troubleshooting performance issues caused by schema problems or deletes, or writing conditional (LWT) statements. Vector and full-text indexes go to scylladb-vector-search; DynamoDB API tables go to scylladb-alternator. Triggers on "design schema", "ScyllaDB data model", "partition key", "clustering column", "primary key", "CQL

How do I install the Scylladb Data Modeling skill?

Claude Code plugin: /plugin marketplace add scylladb/agent-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Scylladb Data Modeling popular?

It lives in scylladb/agent-skills, which has 9 GitHub stars and 6 forks.

Related skills

Scylladb

9

scylladb/agent-skills

Overview of ScyllaDB and a map of the ScyllaDB agent skills, with instructions to install or fetch a skill that is missing. Use this skill when starting a project on ScyllaDB or moving an existing project to ScyllaDB, when a task covers more than one ScyllaDB area, or when no more specific ScyllaDB skill matches. Child skill scylladb-data-modeling wins for CQL schemas, keys, indexes, TTL, and compaction. Child skill scylladb-cloud-setup wins for connections, drivers, and credentials. Also use to find the skill for vector, full-text, and hybrid search, the DynamoDB API (Alternator), Kubernetes

AI, LLMs & Agents

Scylladb Alternator

9

scylladb/agent-skills

Guide users building against ScyllaDB's DynamoDB-compatible API (Alternator). Use this skill when a user is porting a DynamoDB application to ScyllaDB, using boto3/AWS SDK clients against ScyllaDB, or asking about Alternator setup, write isolation, or load balancing. CQL schema design goes to scylladb-data-modeling. Triggers on "Alternator", "DynamoDB API", "DynamoDB compatible", "boto3 with ScyllaDB", "migrate from DynamoDB", "aws-sdk against ScyllaDB", "alternator_port", "alternator_write_isolation".

Software Development

Scylladb Benchmark

9

scylladb/agent-skills

Run a repeatable load test of a ScyllaDB Cloud cluster on AWS with cassandra-stress, from loader VMs in a peered VPC, and write a report with a fixed results table. The default fast path measures the maximum 50/50 read/write rate at p99 ≤ 10 ms on a pinned X Cloud cluster; a user profile tests the schema and queries of the user's application. Use this skill when a user asks to benchmark, load test, or stress test ScyllaDB Cloud, to measure p50, p90, and p99 latency at a target rate, to find the maximum throughput under a latency SLA, or to check if a cluster size is enough. It does not benchma

Testing & QA

Scylladb Vector Search

9

scylladb/agent-skills

Guides users through implementing and optimizing ScyllaDB Vector Search and full-text search for semantic similarity, keyword search, RAG, and similar use cases. Use this skill when users need to store and query embeddings, build vector indexes (HNSW), run approximate nearest neighbour (ANN) queries, apply filtering (global/local secondary indexes), configure quantization, integrate with LLM frameworks (e.g. LangChain), create full-text indexes and BM25 queries, combine full-text and vector results (hybrid search), or run Vector Search locally with Docker for testing. Schema design outside the

AI, LLMs & Agents

Scylladb Cloud Setup

9

scylladb/agent-skills

Guide users through connecting to a ScyllaDB Cloud cluster, choosing the correct driver and version, and configuring authentication. Use this skill when a user needs to connect to ScyllaDB Cloud, pick a CQL driver, check a driver version, configure credentials, set the default consistency level, size the connection pool, or troubleshoot connection issues. Cluster management through an AI agent goes to scylladb-cloud-mcp. Triggers on "connect to ScyllaDB Cloud", "ScyllaDB connection", "ScyllaDB driver setup", "which driver", "driver version", "Java driver", "Python driver", "CQL connection", "D

AI, LLMs & Agents

Agent Teams

5

AntonioGuadagnoAI/agent-teams

Playbook operativo per creare e orchestrare agent team in Claude Code (piu istanze di Claude Code che collaborano condividendo una task list e messaggiandosi tra loro). Usa questa skill ogni volta che l'utente chiede di lanciare un team di agenti, fare spawn di teammate, parallelizzare un lavoro su piu agenti, eseguire una review o un'indagine multi-agente, coordinare lavoro su frontend/backend/test con agenti separati, o menziona "agent team", "teammate", "team lead", "team di agenti" o "agenti in parallelo", anche senza nominare esplicitamente la funzione. Usala anche quando un task e abbast

AI, LLMs & Agents

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.