Nosql Expert

This is for anyone designing Cassandra or DynamoDB schemas who keeps running into hot partitions or wondering why their queries are slow. It walks through the core mental shift from relational modeling to query-first design, explaining partition keys, sort keys, single-table patterns, and when to denormalize. The comparison table between SQL and NoSQL mindsets is genuinely helpful, and the anti-pattern checklist (like avoiding ALLOW FILTERING in Cassandra) will save you from common mistakes. If you're moving from Postgres to a distributed system and still thinking in joins and normalization, this reorients you quickly.

skills.sh installs: 219
GitHub stars: 33.2K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add davila7/claude-code-templates --skill nosql-expert --agent claude-code

Installs into .claude/skills of the current project.

Files

NoSQL Expert Patterns (Cassandra & DynamoDB)

Overview

This skill provides professional mental models and design patterns for distributed wide-column and key-value stores (specifically Apache Cassandra and Amazon DynamoDB).

Unlike SQL (where you model data entities), or document stores (like MongoDB), these distributed systems require you to model your queries first.

When to Use

Designing for Scale: Moving beyond simple single-node databases to distributed clusters.
Technology Selection: Evaluating or using Cassandra, ScyllaDB, or DynamoDB.
Performance Tuning: Troubleshooting "hot partitions" or high latency in existing NoSQL systems.
Microservices: Implementing "database-per-service" patterns where highly optimized reads are required.