nosql-expert
Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.
Best use case
nosql-expert is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.
Teams using nosql-expert should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/nosql-expert-ntuan2502/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How nosql-expert Compares
| Feature / Agent | nosql-expert | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Expert guidance for distributed NoSQL databases (Cassandra, DynamoDB). Focuses on mental models, query-first modeling, single-table design, and avoiding hot partitions in high-scale systems.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# NoSQL Expert Patterns (Cassandra & DynamoDB) ## Overview This skill provides professional mental models and design patterns for **distributed wide-column and key-value stores** (specifically Apache Cassandra and Amazon DynamoDB). Unlike SQL (where you model data entities), or document stores (like MongoDB), these distributed systems require you to **model your queries first**. ## When to Use - **Designing for Scale**: Moving beyond simple single-node databases to distributed clusters. - **Technology Selection**: Evaluating or using **Cassandra**, **ScyllaDB**, or **DynamoDB**. - **Performance Tuning**: Troubleshooting "hot partitions" or high latency in existing NoSQL systems. - **Microservices**: Implementing "database-per-service" patterns where highly optimized reads are required. ## The Mental Shift: SQL vs. Distributed NoSQL | Feature | SQL (Relational) | Distributed NoSQL (Cassandra/DynamoDB) | | :--- | :--- | :--- | | **Data modeling** | Model Entities + Relationships | Model **Queries** (Access Patterns) | | **Joins** | CPU-intensive, at read time | **Pre-computed** (Denormalized) at write time | | **Storage cost** | Expensive (minimize duplication) | Cheap (duplicate data for read speed) | | **Consistency** | ACID (Strong) | **BASE (Eventual)** / Tunable | | **Scalability** | Vertical (Bigger machine) | **Horizontal** (More nodes/shards) | > **The Golden Rule:** In SQL, you design the data model to answer *any* query. In NoSQL, you design the data model to answer *specific* queries efficiently. ## Core Design Patterns ## 🧠 Knowledge Modules (Fractal Skills) ### 1. [1. Query-First Modeling (Access Patterns)](./sub-skills/1-query-first-modeling-access-patterns.md) ### 2. [2. The Partition Key is King](./sub-skills/2-the-partition-key-is-king.md) ### 3. [3. Clustering / Sort Keys](./sub-skills/3-clustering-sort-keys.md) ### 4. [4. Single-Table Design (Adjacency Lists)](./sub-skills/4-single-table-design-adjacency-lists.md) ### 5. [5. Denormalization & Duplication](./sub-skills/5-denormalization-duplication.md) ### 6. [Apache Cassandra / ScyllaDB](./sub-skills/apache-cassandra-scylladb.md) ### 7. [AWS DynamoDB](./sub-skills/aws-dynamodb.md)
Related Skills
nosql-databases
Apply NoSQL best practices for MongoDB, Convex, and document databases. Use when designing schemas, writing queries, optimizing performance, or building applications with non-relational databases. Use with database-expert for query optimization and DBA-level tuning (20+ years experience).
nestjs-expert
Nest.js framework expert specializing in module architecture, dependency injection, middleware, guards, interceptors, testing with Jest/Supertest, TypeORM/Mongoose integration, and Passport.js authentication. Use PROACTIVELY for any Nest.js application issues including architecture decisions, testing strategies, performance optimization, or debugging complex dependency injection problems. If a specialized expert is a better fit, I will recommend switching and stop.
multi-platform-apps-flutter-expert
Master Flutter development with Dart 3, advanced widgets, and multi-platform deployment. Handles state management, animations, testing, and performance optimization for mobile, web, desktop, and embedded platforms. Use PROACTIVELY for Flutter architecture, UI implementation, or cross-platform features. Use when: the task directly matches flutter expert responsibilities within plugin multi-platform-apps. Do not use when: a more specific framework or task-focused skill is clearly a better match.
mongodb-expert
MongoDB document modeling, aggregation pipeline optimization, sharding strategies, replica set configuration, connection pool management, and indexing patterns. Use this skill for MongoDB-specific issues, NoSQL performance optimization, and schema design.
mobile-security-expert
移动安全漏洞挖掘知识库，基于HackerOne公开报告提供Android和iOS应用的漏洞挖掘手法、技术细节和代码模式分析；用于安全研究人员和漏洞挖掘者学习参考、代码审计和漏洞检测指导。
laravel-expert
Senior Laravel Engineer role for production-grade, maintainable, and idiomatic Laravel solutions. Focuses on clean architecture, security, performance, and modern standards (Laravel 10/11+).
kotlin-coroutines-expert
Expert patterns for Kotlin Coroutines and Flow, covering structured concurrency, error handling, and testing.
graphql-expert
GraphQL API design and implementation. Use when building GraphQL APIs, designing schemas, implementing resolvers, or optimizing GraphQL performance.
fullstack-expertise
Full-stack development expertise covering backend, frontend, database, DevOps, and testing domains
frontend-web-dev-expert
Advanced frontend web development expert system that provides comprehensive modern web development services including architecture design, UI/UX implementation, performance optimization, engineering setup, and cross-platform development through expert collaboration and intelligent tool integration.
framework-expert
Unified framework expertise bundle. Lazy-loads relevant framework patterns (React, Vue, Angular, Next.js, Node.js, Python, Laravel, Go, Flutter, Godot) based on detected tech stack.
flutter-expert
Master Flutter development with Dart 3, advanced widgets, and multi-platform deployment. Handles state management, animations, testing, and performance optimization for mobile, web, desktop, and embedded platforms. Use PROACTIVELY for Flutter architecture, UI implementation, or cross-platform features.