Can it help me decide between SQL and NoSQL?

Yes, it includes a detailed comparison of relational vs. distributed NoSQL mental shifts to help determine if your use case warrants a distributed system.

What specific NoSQL databases does this skill support?

This skill is specialized for distributed wide-column and key-value stores, specifically focusing on Apache Cassandra, Amazon DynamoDB, and ScyllaDB.

Does it provide code for migrations?

While it focuses on modeling and design patterns, it can assist in generating the logic and schema definitions (CQL or DynamoDB API) needed for data migrations.

How does this skill help with DynamoDB performance?

It provides guidance on choosing high-cardinality partition keys to avoid hot partitions and implementing single-table design to minimize network requests.

NoSQL Database Architect

Name: NoSQL Database Architect
Author: claudiodearaujo

byclaudiodearaujo

0•

Database Management

Architects high-scale distributed database schemas for Cassandra and DynamoDB using query-first modeling and performance-optimized patterns.

The NoSQL Database Architect skill provides Claude with the specialized mental models required to design and optimize distributed wide-column and key-value stores. Unlike traditional relational databases, distributed NoSQL systems like Cassandra and DynamoDB require a 'query-first' approach. This skill guides developers through complex patterns such as single-table design, partition key optimization to avoid 'hot partitions,' and denormalization strategies. It is an essential companion for developers building high-throughput microservices, migrating from SQL to NoSQL, or troubleshooting performance bottlenecks in existing distributed clusters.

Key Features

01Denormalization and eventual consistency guidance

02Query-first access pattern modeling and schema design

03Single-table design patterns for Amazon DynamoDB

040 GitHub stars

05Hot partition detection and mitigation strategies

06Partition and clustering key optimization for Apache Cassandra

Use Cases

01Designing high-scale database architectures for real-time applications

02Troubleshooting high latency or throughput issues in existing clusters

03Migrating relational data models to distributed NoSQL systems

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