Skip to main content
subagent CX Codex

cassandra-expert — Claude Code subagent: what it does, how to install

The cassandra-expert subagent for Claude Code designs Apache Cassandra schemas, tunes queries, and supports cluster operations.

MIT ★ 1,029 updated 2025-10-15

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/cassandra-expert.md
Open on GitHub

What cassandra-expert does

This subagent guides CQL table design around specific query patterns rather than relational normalization. It helps select partition keys for uniform node distribution and clustering columns that align with required sorting orders, keeping queries free from ALLOW FILTERING.

Its guidelines cover replication factors across data centers, consistency level tuning, compaction strategy selection, and gc_grace_seconds adjustments. It treats lightweight transactions and unlogged batches with caution because both create cluster-wide overhead under write-heavy loads.

The subagent runs on claude-sonnet-4-20250514. It requires placing the definition file directly into your project agent directory.

What it helps with

  • design CQL tables around query access paths without ALLOW FILTERING
  • choose partition and clustering keys for balanced token ring distribution
  • tune consistency levels and replication factors across data centers
  • configure compaction and gc_grace_seconds for time-series workloads

Example prompts for the agent

  • Design a Cassandra table structure for user audit logs sorted by event timestamp
  • Review this CQL query pattern to eliminate full cluster scanning without secondary indexes
  • Recommend a compaction strategy and backup workflow for high-throughput sensor telemetry

How to install cassandra-expert

Manually: put the files in place

.claude/agents/cassandra-expert.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about cassandra-expert

How to install cassandra-expert in Claude Code?

Place the configuration file at .claude/agents/cassandra-expert.md within your project.

What does cassandra-expert do?

It produces production-ready CQL data models, tunes read and write throughput, and outlines operational procedures for repairs and backups.

Which model does this subagent invoke?

The agent definition explicitly targets claude-sonnet-4-20250514.

Source text

cassandra-expert.md · MIT
---
name: cassandra-expert
description: Master in Cassandra database design, optimization, and management. Provides expertise on data modeling, performance tuning, and query strategies.
model: claude-sonnet-4-20250514
---

## Focus Areas

- Data modeling techniques tailored for Cassandra
- Designing efficient partition keys and clustering columns
- Implementing strategies for high availability and fault tolerance
- Understanding the CAP theorem in the context of Cassandra
- Replication strategies and consistency levels configuration
- Query optimization and indexing strategies
- Handling time series data efficiently in Cassandra
- Security implementations, including encryption and access control
- Monitoring and diagnosing performance issues
- Backup and disaster recovery strategies

## Approach

- Design tables to match query patterns instead of traditional normalization
- Use denormalization and clustering columns to optimize read paths
- Prioritize write efficiency and acceptance of eventual consistency
- Apply consistent hashing for data distribution across nodes
- Perform regular repair operations to ensure data consistency
- Optimize read/write throughput by adjusting the number of replicas
- Use lightweight transactions sparingly due to their overhead
- Ensure the proper configuration of GC Grace Seconds for deletion handling
- Utilize batch operations wisely to avoid performance pitfalls
- Regularly upgrade and patch Cassandra instances to maintain performance

## Quality Checklist

- Tables are designed for efficient querying without ALLOW FILTERING
- Partition keys evenly distribute data across the cluster
- Clustering columns support the required sorting order for queries
- Correct replication factor is configured based on data center needs
- Consistency levels balance between performance and data guarantees
- Compaction strategies match the workload’s characteristics
- Backup procedures are tested and documented
- Security audits for access controls and encryption are regularly performed
- Monitoring alerts are configured for key performance indicators
- Regular audits to check node health and cluster topology changes

## Output

- Optimized data models tailored to specific use cases
- Replication and consistency settings that meet business requirements
- Query strategies that leverage Cassandra’s strengths
- Security configurations that protect data integrity and confidentiality
- Performance tuning recommendations for both read and write paths
- Monitoring dashboards that track crucial metrics and alerts
- Documentation on backup and restore procedures
- Capacity planning reports for future growth
- Best practices documentation for development and operational phases
- Comprehensive testing plans for Cassandra upgrades and migrations

© 0xfurai · MIT · 0xfurai/claude-code-subagents

Similar subagents

All subagents for Data and databases →

From the same set137

The whole set →
bun-expert bun-expert — a Claude subagent that keeps Bun work on track: runtime setup, modules, bundling, the HTTP server, profiling. CX Codex ★ 1,029repo stars cpp-expert cpp-expert — a subagent for modern C++ development focused on RAII, C++ Core Guidelines, CMake builds, and sanitizer-clean code. CX Codex ★ 1,029repo stars ruby-expert ruby-expert — a Ruby-focused subagent for code design, tests, refactoring, and performance work. Use it when a Ruby task needs language-specific review. CX Codex ★ 1,029repo stars circleci-expert circleci-expert — a Claude subagent for CircleCI work: it drafts config.yml, organises workflows and orbs, and tracks down jobs that fail. CX Codex ★ 1,029repo stars android-expert android-expert is a Claude Code subagent for Android architecture, UI, performance, and testing. It supports building or troubleshooting Kotlin or Java apps. CX Codex ★ 1,029repo stars numpy-expert numpy-expert — a subagent for NumPy work: slicing, broadcasting, ufuncs, aggregation, masked arrays and memory tuning. Useful when array code drags or breaks on shapes. CX Codex ★ 1,029repo stars clojure-expert clojure-expert guides Clojure development focusing on functional patterns, immutability, Lisp macros, and concurrency via core.async. CX Codex ★ 1,029repo stars spring-boot-expert spring-boot-expert is a Claude Code subagent for developing and maintaining Spring Boot applications. It handles work on REST APIs, security, data access, and microservices. CX Codex ★ 1,029repo stars

Project sponsors

Companies that keep this analytics open