What is the main difference between SQL and NoSQL modeling?

Relational SQL models entities and relationships for any potential query, while distributed NoSQL requires modeling specific access patterns first to ensure efficient single-lookup performance at scale.

Can this skill help prevent 'hot partitions'?

Yes, it provides guidance on selecting high-cardinality partition keys to ensure that both data and traffic are distributed evenly across physical nodes in a cluster.

How does this skill help with DynamoDB specifically?

It provides specific patterns for single-table design, adjacency lists, and the effective use of Global Secondary Indexes (GSIs) and Time-To-Live (TTL) attributes to optimize costs and performance.

When is it best to use Cassandra vs. DynamoDB?

This skill helps evaluate trade-offs; Cassandra is ideal for high-write volume and on-prem or multi-cloud flexibility, while DynamoDB is preferred for serverless integration and managed scaling within the AWS ecosystem.

NoSQL Expert (Cassandra & DynamoDB)

Name: NoSQL Expert (Cassandra & DynamoDB)
Author: lingxling

bylingxling

•

数据库管理

Provides expert architectural guidance and design patterns for high-scale distributed databases like Cassandra, ScyllaDB, and DynamoDB.

This skill empowers developers to master the critical mental shift from relational SQL to distributed NoSQL architectures. It focuses on query-first data modeling, single-table design patterns, and strategies to prevent performance bottlenecks such as hot partitions. Whether you are building a new microservice from scratch, troubleshooting high latency in a production cluster, or optimizing for throughput, this skill provides actionable blueprints for building robust, low-latency distributed systems that handle massive scale.

主要功能

01Detailed guidance on eventual consistency and GSI/LSI usage

02Hot partition detection and avoidance techniques

03Advanced single-table design and adjacency list patterns

04Optimization of Partition Keys and Clustering/Sort Keys

05Query-first data modeling strategies for Cassandra and DynamoDB

0639 GitHub stars

使用场景

01Refactoring existing NoSQL tables to eliminate performance bottlenecks

02Migrating legacy relational database models to distributed NoSQL systems

03Designing highly scalable database schemas for high-traffic applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn nosql-expert

For use in Claude.ai and ChatGPT

主要功能

01Detailed guidance on eventual consistency and GSI/LSI usage

02Hot partition detection and avoidance techniques

03Advanced single-table design and adjacency list patterns

04Optimization of Partition Keys and Clustering/Sort Keys

05Query-first data modeling strategies for Cassandra and DynamoDB

0639 GitHub stars

使用场景

01Refactoring existing NoSQL tables to eliminate performance bottlenecks

02Migrating legacy relational database models to distributed NoSQL systems

03Designing highly scalable database schemas for high-traffic applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add lingxling/awesome-skills-cn nosql-expert

For use in Claude.ai and ChatGPT