data-model SKILL.md skillA

data-model from rustyrazorblade/skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add rustyrazorblade/skills/data-model@git:20261031.8909b5e

Pins git:20261031.8909b5e in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
rustyrazorblade/skills
Path
plugins/cassandra-expert/skills/data-model/SKILL.md
Versions recorded
6
Latest version
git:20261031.8909b5e, committed Oct 31, 2026
First version recorded
Feb 22, 2026
Size
20,756 bytes
Repository stars
44
License
Apache-2.0

Data modeling and schema design for Apache Cassandra. Use when designing tables, choosing partition keys, modeling time-series data, or reviewing existing schemas.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Cassandra Data Modeling

You are an expert Cassandra data modeler focused on query-driven schema design.

## Version Identification

**IMPORTANT:** At the beginning of any data modeling discussion, immediately ask the user which Cassandra version they are using. Data modeling features and recommendations vary by version:

- **Cassandra 3.x**: Materialized views (discouraged), SASI indexes, legacy compaction strategies
- **Cassandra 4.0**: Improved LWT performance, virtual tables
- **Cassandra 4.1**: Paxos V2 for better LWT performance (start `concurrent_writes` at 64, and raise it when CPU is available and `MutationStage` `Pending` stays above 0)
- **Cassandra 5.0**: SAI (Storage-Attached Indexes) for flexible querying, UCS compaction strategy, Trie memtables

Knowing the version ensures schema recommendations leverage available features and avoid unsupported ones.

## Core Principles

### Query-First Design
- Start with the queries you need to support
- Design tables to satisfy each query pattern
- Denormalization is expected and necessary
- One table per query pattern is common

## Denormalization Strategy
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add rustyrazorblade/skills/data-model@sha256:2b5bf8979eb0ca6b

The line at the top of this page pins the label git:20261031.8909b5e, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_iwu6xx2jz2rv7nts.svg)](https://markdownregistry.com/a/art_iwu6xx2jz2rv7nts)

3 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 6 versions of this file, between Feb 22, 2026 and Oct 31, 2026, about one every 50 days.

versioncommittedcommitsizeaudit
git:20261031.8909b5e latest2026-10-31 8909b5e 20,756 BA view · diff
git:20260325.298c24e2026-03-25 298c24e 20,089 BA view · diff
git:20260324.70fc6f22026-03-24 70fc6f2 7,378 BA view · diff
git:20260306.34935632026-03-06 3493563 6,564 BA view · diff
git:20260222.ee880f62026-02-22 ee880f6 6,540 BA view · diff
git:20260222.a392c9a2026-02-22 a392c9a 6,519 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (20756 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

rustyrazorblade/skills · 44 stars · license Apache-2.0 · pushed 2026-10-31 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_iwu6xx2jz2rv7nts
GET https://markdownregistry.com/api/v1/resolve?ref=rustyrazorblade/skills/data-model
GET https://markdownregistry.com/api/v1/blob/2b5bf8979eb0ca6ba08815b2fa0b28750685437ce810e4cd7706e9ce4f09f359

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from rustyrazorblade/skills

openspec-apply-change SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-apply-change/SKILL.md · Implement tasks from an OpenSpec change. Use when the user wants to start implementing, continue implementation, or…
v1.0 · audit A · 44 stars
openspec-archive-change SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-archive-change/SKILL.md · Archive a completed change in the experimental workflow. Use when the user wants to finalize and archive a change after…
v1.0 · audit A · 44 stars
openspec-bulk-archive-change SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-bulk-archive-change/SKILL.md · Archive multiple completed changes at once. Use when archiving several parallel changes.
v1.0 · audit A · 44 stars
openspec-explore SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-explore/SKILL.md · Enter explore mode - a thinking partner for exploring ideas, investigating problems, and clarifying requirements. Use…
v1.0 · audit A · 44 stars
openspec-onboard SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-onboard/SKILL.md · Guided onboarding for OpenSpec - walk through a complete workflow cycle with narration and real codebase work.
v1.0 · audit A · 44 stars
openspec-propose SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-propose/SKILL.md · Propose a new change with all artifacts generated in one step. Use when the user wants to quickly describe what they…
v1.0 · audit A · 44 stars
openspec-sync-specs SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-sync-specs/SKILL.md · Sync delta specs from a change to main specs. Use when the user wants to update main specs with changes from a delta…
v1.0 · audit A · 44 stars
openspec-verify-change SKILL.md skill
rustyrazorblade/skills · .claude/skills/openspec-verify-change/SKILL.md · Verify implementation matches change artifacts. Use when the user wants to validate that implementation is complete…
v1.0 · audit A · 44 stars
CLAUDE.md CLAUDE.md file
rustyrazorblade/skills · CLAUDE.md
git:20260907.450260a · audit A · 44 stars
diagnose SKILL.md skill
rustyrazorblade/skills · plugins/cassandra-expert/skills/diagnose/SKILL.md · Systematic troubleshooting for Apache Cassandra clusters. Use when diagnosing performance issues, latency problems…
git:20261031.8909b5e · audit A · 44 stars
optimize SKILL.md skill
rustyrazorblade/skills · plugins/cassandra-expert/skills/optimize/SKILL.md · Performance optimization for Apache Cassandra clusters. Use when tuning configuration, improving throughput, reducing…
git:20261031.8909b5e · audit A · 44 stars
token-skew SKILL.md skill
rustyrazorblade/skills · plugins/cassandra-expert/skills/token-skew/SKILL.md · Analyze token distribution and data ownership skew across Cassandra nodes and racks. Separates token placement quality…
git:20260401.b1f62f5 · audit A · 44 stars

Every file in rustyrazorblade/skills

Other files named data-model

data-model SKILL.md skill
gonimar/claude-web-studio · skills/data-model/SKILL.md · Designs or extends the data model — entities and relations, PostgreSQL DDL with constraints and indexes justified by…
git:20260927.d019450 · audit A · 5 stars

Browse by kind, by grade A, or by owner.