What databases does this skill specifically support?

It provides specialized guidance for distributed wide-column and key-value stores, specifically Amazon DynamoDB, Apache Cassandra, and ScyllaDB.

What is a 'hot partition' and can this skill fix it?

A hot partition occurs when data traffic is unevenly distributed across nodes; this skill provides strategies like using high-cardinality keys to prevent this.

How does this help with AWS DynamoDB optimization?

It helps implement advanced patterns like single-table design, effective use of GSIs/LSIs, and partition key selection to optimize throughput and costs.

Does it include best practices for Cassandra tombstones?

Yes, it includes specific warnings and patterns to avoid expensive delete markers (tombstones) in Cassandra and ScyllaDB environments.

Can this skill help migrate from SQL to NoSQL?

Yes, it provides a 'Mental Shift' framework to help you move from entity-relationship modeling to query-first modeling required for distributed systems.

NoSQL Expert Architect

Name: NoSQL Expert Architect
Author: claudiodearaujo

byclaudiodearaujo

•

Database Management

Provides expert guidance for designing and optimizing distributed NoSQL databases like Cassandra and DynamoDB using query-first modeling.

This skill empowers developers to master the mental shift from relational SQL to distributed NoSQL architectures, focusing on high-scale systems like Amazon DynamoDB and Apache Cassandra. It offers specialized guidance on single-table design, partition key optimization, and denormalization strategies to ensure high performance and avoid common pitfalls like hot partitions. Whether you are migrating from SQL or tuning an existing NoSQL implementation, this skill provides the patterns and checklists necessary to build horizontally scalable, efficient data models.

Key Features

01Technology-specific best practices for Cassandra, ScyllaDB, and DynamoDB

02Expert checklists for schema validation and anti-pattern detection

031 GitHub stars

04Query-first data modeling and access pattern mapping

05Single-table design and adjacency list implementation

06Partition and sort key optimization to prevent hot partitions

Use Cases

01Troubleshooting performance bottlenecks and high latency in NoSQL systems

02Designing highly scalable database schemas for distributed microservices

03Migrating relational workloads to distributed NoSQL clusters

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