skills.rest
sitharaj88
sitharaj88COMMUNITY
Explore all skills by this author →
GitHub

db-cassandra

Generate Cassandra data models, CQL queries, and cluster configurations.

1|Updated Mar 2, 2026
Search Tags:#database#optimization#data modeling#nosql#cql#cassandra#scylladb
One-click install
npx skills add https://github.com/sitharaj88/claude-skills --skill db-cassandra
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-cassandra
Source: https://github.com/sitharaj88/claude-skills/tree/main/skills/db-cassandra
Command: npx skills add https://github.com/sitharaj88/claude-skills --skill db-cassandra

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users design, query, optimize, and set up Apache Cassandra or ScyllaDB databases, addressing the complexities of NoSQL data modeling and cluster management.

Core Features & Use Cases

  • Data Modeling: Generates query-first data models with appropriate partition and clustering keys.
  • Query Generation: Writes efficient CQL queries tailored to specific data access patterns.
  • Optimization: Provides guidance on compaction strategies, consistency levels, and partition size management.
  • Cluster Setup: Assists in configuring replication strategies and essential nodetool commands.
  • Use Case: A user needs to design a new Cassandra database for an e-commerce platform to store order history, ensuring fast retrieval of orders by user ID and date.

Quick Start

Use the db-cassandra skill to generate a data model for storing user orders, optimized for retrieving orders by user ID and sorted by date.

Frequently Asked Questions about db-cassandra

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a Cassandra data model optimized for fast retrieval by user ID?▼

To optimize Cassandra data models for fast retrieval, you use a query-first approach, setting the user ID as the partition key to ensure efficient data distribution and rapid lookups. This aligns the schema directly with specific data access patterns.

What is the best way to write efficient CQL queries for Apache Cassandra?▼

Efficient CQL queries in Apache Cassandra are written by tailoring them to your predefined data access patterns and leveraging appropriate partition and clustering keys. This prevents full table scans and ensures optimal query performance.

How do I configure replication strategies and nodetool commands for a ScyllaDB cluster?▼

Configuring a ScyllaDB cluster involves setting replication strategies for data redundancy and utilizing essential nodetool commands for cluster management. This ensures high availability and proper data distribution across your nodes.

When should I adjust compaction strategies and consistency levels in NoSQL databases?▼

Adjust compaction strategies and consistency levels in NoSQL databases like Cassandra when optimizing read/write performance or managing partition sizes. This directly impacts data availability and storage efficiency during cluster operations.

Can I use the cassandra-driver and DataStax drivers with my generated data models?▼

Yes, the generated Cassandra data models and CQL queries are designed to support drivers like cassandra-driver and DataStax. This ensures seamless integration when connecting your application to the database cluster.

Why does partition size management matter when setting up an Apache Cassandra database?▼

Partition size management matters in Apache Cassandra because oversized partitions cause memory issues and slow read operations. Proper partition key design prevents these bottlenecks and maintains cluster health.

Related Skills

Explore More Software Engineering Skills→
MassimilianoPiliMassimilianoPili

dba-cassandra

Design and administer Apache Cassandra and ScyllaDB 5.0+ databases with CQL schemas and performance tuning.

Community
Advanced
rustyrazorbladerustyrazorblade
41

data-model

Design Cassandra schemas with version-aware partition and clustering key guidance.

Community
Advanced
bcastelinobcastelino
2

nosql-expert

Guide distributed NoSQL database design for Cassandra and DynamoDB with query-first modeling.

Community
Advanced
tuyenhttuyenht

NoSQL Patterns

Provide expert patterns for optimizing MongoDB, Redis, and DynamoDB databases.

Community
Intermediate