Design relational database schemas (and choose when to go NoSQL) that stay maintainable and fast. Use this skill whenever the user mentions tables, DDL, entities and relationships, normalization (1NF/2NF/3NF), primary and foreign keys, UUID vs bigint IDs, indexes (B-tree, composite, covering, partial), EXPLAIN, constraints (CHECK, UNIQUE, exclusion), transactions and isolation levels, migrations (Alembic, Prisma, Flyway, expand-contract, backfilling), or SQL vs NoSQL…
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# Database Design
Database design turns a domain into a schema that stays fast, correct, and easy to evolve for years. This skill covers the full pipeline — requirements analysis, entity modeling, normalization, keys, constraints, indexes, and safe migrations — plus deciding when a document, wide-column, or graph store beats a relational database.
## Quick Reference
| Topic | Reference |
|-------|-----------|
| Normalization worked examples, natural vs surrogate keys, UUID vs bigint | [normalization-and-keys.md](references/normalization-and-keys.md) |
| B-tree internals, composite/covering/partial indexes, reading EXPLAIN | [indexing-and-query-tuning.md](references/indexing-and-query-tuning.md) |
| Migration tools (Alembic, Prisma, Flyway), expand-contract, backfilling | [migrations-zero-downtime.md](references/migrations-zero-downtime.md) |
## Core Workflow
Work through these steps in order — each informs the next, and skipping requirements analysis is the most common source of bad schemas.
…
The line at the top of this page pins the label git:20260813.4b33420, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
GET https://markdownregistry.com/api/v1/artifacts/art_nch3yhlemt3lrlg4
GET https://markdownregistry.com/api/v1/resolve?ref=svngoku/coding-agents-skills/database-design
GET https://markdownregistry.com/api/v1/blob/ae57142b82eaa513fcf66430481f28243fac984956b58ac9751b65ef6e97dc46
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
svngoku/coding-agents-skills · skills/adaption-ai/SKILL.md · Adaption AI SDK for synthetic data augmentation and dataset adaptation. Use when building data pipelines with the…
svngoku/coding-agents-skills · skills/api-design/SKILL.md · Design and review intuitive, scalable, maintainable HTTP APIs. Use this skill whenever the user wants to design a new…
svngoku/coding-agents-skills · skills/ddd/SKILL.md · Domain-Driven Design system for software development. Use when designing new systems with DDD principles, refactoring…
svngoku/coding-agents-skills · skills/genai-tk/SKILL.md · Build GenAI and agentic apps with genai-tk (tclatos/genai-tk), a YAML-driven IoC toolkit over LangChain, DeepAgents…
svngoku/coding-agents-skills · skills/langchain/SKILL.md · Build AI agents with LangChain v1 and LangGraph in Python. Use this skill whenever the user mentions LangChain…
svngoku/coding-agents-skills · skills/microservices-patterns/SKILL.md · Decompose systems into microservices and apply canonical distributed-systems patterns. Use this skill whenever the user…
svngoku/coding-agents-skills · skills/performance-optimization/SKILL.md · Systematically find and fix performance problems in applications, frontend and backend, by measuring first. Use this…
svngoku/coding-agents-skills · skills/prime-rl/SKILL.md · Post-train LLMs with PrimeIntellect's prime-rl (async RL, SFT, distillation, evals). Use this skill whenever the user…
svngoku/coding-agents-skills · skills/scalingo/SKILL.md · Scalingo is a European (French) Platform-as-a-Service for deploying and operating web applications, background workers…
svngoku/coding-agents-skills · skills/security-best-practices/SKILL.md · Practical security review and hardening guidance for application code in Python, JavaScript/TypeScript, and Go. Use…
svngoku/coding-agents-skills · skills/smolagents/SKILL.md · Build AI agents with Hugging Face's SmolAgents framework. Use when creating code-executing agents, tool-calling agents…
