How does this skill help with database performance?

It provides guidance on choosing high-cardinality partition keys to avoid hot partitions and utilizes clustering/sort keys for efficient range queries.

Can it help with DynamoDB Single-Table Design?

Absolutely. It provides patterns for adjacency lists and pre-joined reads, allowing you to fetch multiple entity types in a single network request.

Does it support SQL to NoSQL migrations?

Yes, it assists in the 'mental shift' required to move from relational entities to query-first modeling, ensuring data is structured for specific access patterns.

What databases does the NoSQL Expert skill support?

This skill specifically focuses on distributed wide-column and key-value stores, with deep expertise in Apache Cassandra, ScyllaDB, and Amazon DynamoDB.

NoSQL Design Expert

Name: NoSQL Design Expert
Author: claudiodearaujo

byclaudiodearaujo

•

Database Management

Architects highly scalable distributed NoSQL databases using query-first modeling and advanced single-table design patterns.

The NoSQL Expert skill equips Claude with professional mental models for designing and optimizing distributed wide-column and key-value stores like Apache Cassandra and Amazon DynamoDB. It facilitates the critical shift from relational SQL modeling to query-first NoSQL architecture, ensuring high performance at scale. This skill is indispensable when building microservices, troubleshooting hot partitions, or implementing complex single-table designs, providing specific guidance on partition keys, clustering columns, and denormalization strategies to minimize latency in high-traffic systems.

Key Features

01Single-table design patterns and adjacency lists

02DynamoDB GSI and LSI implementation strategies

03Partition key optimization to prevent hot partitions

041 GitHub stars

05Cassandra and ScyllaDB specific performance tuning

06Query-first data modeling for distributed systems

Use Cases

01Migrating legacy relational databases to high-scale NoSQL architectures

02Designing optimized data models for AWS DynamoDB or Apache Cassandra

03Auditing existing NoSQL schemas for scalability bottlenecks and latency issues

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill