How does it help prevent performance bottlenecks?

It provides a checklist for partition key cardinality to ensure data is distributed evenly across a cluster, preventing 'hot partitions' that limit throughput.

Does it help with DynamoDB's single-table design?

Yes, it provides patterns for using adjacency lists and composite keys to store multiple entity types in one table, reducing network round-trips.

Which databases does this skill focus on?

It is specifically designed for distributed wide-column and key-value stores, with a primary focus on Amazon DynamoDB, Apache Cassandra, and ScyllaDB.

Can I use this for MongoDB?

While some concepts like denormalization overlap, this skill is specifically tuned for distributed systems like Cassandra and DynamoDB which have different scaling and consistency behaviors than document stores.

What is 'query-first modeling'?

In NoSQL, you model data based on how it will be read. This skill helps you define your access patterns first and then design tables to serve those queries with minimal latency.

NoSQL Expert Design Patterns

Name: NoSQL Expert Design Patterns
Author: claudiodearaujo

byclaudiodearaujo

0•

Database Management

Architects high-performance distributed database schemas using query-first modeling and single-table design patterns for Cassandra and DynamoDB.

The NoSQL Expert skill equips Claude with professional mental models and design patterns specifically for distributed wide-column and key-value stores such as Apache Cassandra, ScyllaDB, and AWS DynamoDB. It facilitates the critical mental shift from relational (SQL) modeling to query-first NoSQL modeling, ensuring that data structures are optimized for specific access patterns rather than general relationships. This skill is indispensable for developers building high-scale systems where performance, horizontal scalability, and the avoidance of common pitfalls like hot partitions and expensive 'scatter-gather' scans are paramount.

Key Features

01Guidance on clustering keys for efficient range queries

02Query-first data modeling strategies for distributed systems

03Single-table design implementation for DynamoDB optimization

04Advanced denormalization and data duplication patterns

050 GitHub stars

06High-cardinality partition key selection to avoid hot partitions

Use Cases

01Migrating complex relational schemas to scalable NoSQL architectures

02Optimizing AWS DynamoDB tables to minimize RCU/WCU consumption

03Designing a high-throughput user activity feed using Cassandra or ScyllaDB

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add claudiodearaujo/sistema-de-narra-o-de-livro-front nosql-expert

For use in Claude.ai and ChatGPT

Download Skill