Provides concrete, version-aware advice for designing Apache Cassandra schemas using a query-first approach. Covers partition and clustering key selection, denormalization patterns, time-series bucketing, compaction strategy recommendations per Cassandra version, consistency trade-offs, and practical examples and SQL snippets. Includes checklists and anti-patterns to avoid.
Use this skill when designing new Cassandra tables, reviewing an existing schema, modeling time-series or high-write workloads, choosing compaction/TTL strategies, or preparing a migration between Cassandra versions. Start here before writing queries or building application-level joins.
Inferred: Claude-like or code-focused LLM agents (Claude Code, Codex-style, Gemini Code) best suited for technical schema guidance and code snippets.
Cassandra data modeling reference skill by rustyrazorblade. Pure documentation skill with no scripts — provides expert guidance on query-driven schema design, denormalization strategies, partition key selection, compaction strategy choices, and anti-patterns. Well-structured with version-specific recommendations (3.x through 5.0+), concrete SQL examples, and a schema review checklist. No security concerns as it contains no executable code.
High-quality reference skill from a known Cassandra expert (rustyrazorblade / Aaron Morton community). No scripts to test. Comprehensive coverage of Cassandra data modeling patterns with good version-awareness. Denormalization trade-off analysis is particularly well-done.