Stats
Actions
Tags
From sdd
Proposes a database schema (SQL or NoSQL) for a given domain. Use when the user asks to "design a database", "model data for X", "build an ER", pick SQL vs NoSQL, or invokes /sdd:design-database. Grounded in DDIA and Kimball.
How this skill is triggered — by the user, by Claude, or both
Slash command
/sdd:design-databaseThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Design a DB that survives real load and schema change. Opinionated, not a survey.
Design a DB that survives real load and schema change. Opinionated, not a survey.
sql-vs-nosql.md.kimball-dimensional.md). Mixed → CDC into a separate warehouse.indexing-tradeoffs.md), uniqueness + check constraints.normalization.md). Denormalize only the hot read path, with a documented plan to prevent drift.transactions.md). Cross-service → saga + outbox + idempotency keys (distributed-transactions.md).replication.md), sharding key + hot-partition mitigation (sharding-partitioning.md). Don't shard prematurely.schema-evolution.md). Never drop in a single deploy.sql-vs-nosql.md · kimball-dimensional.md · normalization.md · indexing-tradeoffs.md · transactions.md · distributed-transactions.md · replication.md · sharding-partitioning.md · schema-evolution.md
Load only the ones relevant to the current step.
# Database Design: <domain>
## 1. Workload (ratio, top queries, volume, consistency)
## 2. Store choice (engine, one-paragraph justification)
## 3. Schema (tables/collections, indexes)
## 4. Transactions & consistency (isolation per op)
## 5. Scale strategy (replication, sharding, hotspots)
## 6. Schema evolution (migration plan)
## 7. Operations (backup, DR, monitoring)
## 8. Trade-offs & alternatives considered
Offer to generate a DBML diagram via the diagram skill and save to ./designs/db-<kebab-name>.md.
npx claudepluginhub dinoquinten/claude-plugins --plugin sddSearches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.
Guides Payload CMS config (payload.config.ts), collections, fields, hooks, access control, APIs. Debugs validation errors, security, relationships, queries, transactions, hook behavior.