Nosql Database Design

This handles the design patterns you need when you're building schemas for MongoDB or DynamoDB instead of relational databases. It covers the classic embedding versus referencing decisions, how to denormalize data without shooting yourself in the foot, and query optimization for document stores. You get reference guides on document structure, MongoDB indexing, schema validation, DynamoDB table design with GSIs, and item operations. The quick start shows a basic user document with embedded address and orders array, which is the bread and butter pattern. Honest take: NoSQL gives you flexibility but you can still make a mess of it. The structured guidance here keeps you from reinventing wheels or falling into common traps around data modeling.

skills.sh installs: 492
GitHub stars: 379
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add aj-geddes/useful-ai-prompts --skill nosql-database-design --agent claude-code

Installs into .claude/skills of the current project.

Files

Overview

Design scalable NoSQL schemas for MongoDB (document) and DynamoDB (key-value). Covers data modeling patterns, denormalization strategies, and query optimization for NoSQL systems.

When to Use

MongoDB collection design
DynamoDB table and index design
Document structure modeling
Embedding vs. referencing decisions
Query pattern optimization
NoSQL indexing strategies
Data denormalization planning

Quick Start

Minimal working example:

// Single document with embedded arrays
db.createCollection("users");

db.users.insertOne({
  _id: ObjectId("..."),
  email: "john@example.com",
  name: "John Doe",
  createdAt: new Date(),

  // Embedded address
  address: {
    street: "123 Main St",
    city: "New York",
    state: "NY",
    zipCode: "10001",
  },

SKILL.md on GitHub