database-schema-design SKILL.md skillA

database-schema-design from akillness/jeo-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add akillness/jeo-skills/database-schema-design@v2.1.0

Pins v2.1.0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
akillness/jeo-skills
Path
.agent-skills/database-schema-design/SKILL.md
Versions recorded
5
Latest version
v2.1.0, committed Jul 27, 2026
First version recorded
Apr 14, 2026
Size
12,527 bytes
Repository stars
53
License
none declared

Design storage-model and migration-safety packets for relational, document-heavy, and hybrid data systems. Use when the user needs entity ownership, constraints, indexes, staged schema changes, or queryable-vs-flexible field decisions across backend/fullstack products, internal ops tools, marketing/customer-data workflows, or game/live-ops systems. Route API contracts to api-design, auth-owned identity/session modeling to authentication-setup, verification to backend-testing, and…

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 Schema Design

Use this skill when the main job is **choosing and evolving the storage model**, not dumping generic SQL or ORM snippets.

`database-schema-design` is the backend storage-design anchor for:
- choosing between relational-first, document-heavy, and hybrid models
- turning domain entities into tables, collections, ownership boundaries, and lifecycle rules
- justifying constraints, indexes, tenant scope, history/audit structures, and deletion/retention behavior
- planning staged schema evolution so migrations, backfills, and cleanup are believable
- handing downstream teams one compact storage-design packet before implementation, verification, reporting, or observability work branches out

Read these support docs before handling larger or riskier work:
- [references/storage-decision-matrix.md](references/storage-decision-matrix.md)
- [references/schema-review-checklist.md](references/schema-review-checklist.md)
- [references/intake-packets-and-route-outs.md](references/intake-packets-and-route-outs.md)

## When to use this skill
- Design a new schema for a product feature, internal tool, admin workflow, customer-data surface, or live-ops/game backend system.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add akillness/jeo-skills/database-schema-design@sha256:53c9066bd988d46b

The line at the top of this page pins the label v2.1.0, 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.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_rn5ou72jgwry3fyy.svg)](https://markdownregistry.com/a/art_rn5ou72jgwry3fyy)

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, between Apr 14, 2026 and Jul 27, 2026, about one every 26 days.

versioncommittedcommitsizeaudit
v2.1.0 latest2026-07-27 056e3f8 12,527 BA view · diff
v2.1.02026-06-26 48fd3af 11,958 BA view · diff
v2.1.02026-06-26 4f9b684 11,955 BA view · diff
v2.1.02026-04-18 87fbb12 12,800 BA view · diff
v2.0.02026-04-14 1dddf88 14,239 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (12527 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

akillness/jeo-skills · 53 stars · license none declared · pushed 2026-10-30 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_rn5ou72jgwry3fyy
GET https://markdownregistry.com/api/v1/resolve?ref=akillness/jeo-skills/database-schema-design
GET https://markdownregistry.com/api/v1/blob/53c9066bd988d46b3127a755bad40d27828994f1303a698e7a1353af3ce55b9a

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.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from akillness/jeo-skills

a2a-protocol SKILL.md skill
akillness/jeo-skills · .agent-skills/a2a-protocol/SKILL.md · Agent-to-Agent horizontal messaging — Linux Foundation AAIF 2026 standard. Use when multiple agents across…
git:20260920.2a2b733 · audit A · 53 stars
ab-test-analysis SKILL.md skill
akillness/jeo-skills · .agent-skills/ab-test-analysis/SKILL.md · Analyze A/B test results with statistical significance, sample size validation, confidence intervals, and…
git:20260919.9f2a908 · audit A · 53 stars
academic-research SKILL.md skill
akillness/jeo-skills · .agent-skills/academic-research/SKILL.md · Full academic research pipeline from discovery to publication — 4 reference pipelines, 27 modes, 39-agent ensemble…
v1.0.0 · audit A · 53 stars
agent-beacon SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-beacon/SKILL.md · Operate Asymptote-Labs/agent-beacon, the cross-harness coding-agent session history and self-improving memory layer…
v1.0.0 · audit A · 53 stars
agent-benchmarking SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-benchmarking/SKILL.md · Map agent capabilities to standard benchmarks (SWE-bench, WebArena, OSWorld, GAIA, TauBench) plus custom regression…
git:20260919.9f2a908 · audit A · 53 stars
agent-guardrails SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-guardrails/SKILL.md · Layered agent safety — prompt-injection defense, data exfiltration prevention, tool-misuse blocking via NeMo Guardrails…
git:20260919.9f2a908 · audit B · 53 stars
agent-manager SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-manager/SKILL.md · tmux + Python agent lifecycle manager — start, stop, monitor, and assign tasks to AI agents running in tmux sessions…
v1.0 · audit A · 53 stars
agent-memory-architecture SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-memory-architecture/SKILL.md · Design tiered agent memory — core / recall / archival — with backend selection (mem0, Letta, Zep/Graphiti, LangMem) and…
git:20260919.9f2a908 · audit A · 53 stars
agent-observability SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-observability/SKILL.md · Instrument LLM agents with traces, metrics, and replay. Use when an agent in production is silently failing…
git:20260919.9f2a908 · audit A · 53 stars
agent-principles SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-principles/SKILL.md · Core principles for collaborative development with AI agents. Defines divide-and-conquer, context management…
v2.0.0 · audit A · 53 stars
agent-pulse SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-pulse/SKILL.md · Operate and extend barretlee/agent-pulse, the evidence-backed AI industry intelligence system: inspect source catalog…
v1.0 · audit A · 53 stars
agent-reach SKILL.md skill
akillness/jeo-skills · .agent-skills/agent-reach/SKILL.md · Operate Panniantong/Agent-Reach, the MIT-licensed installer, doctor, and routing layer for platform-specific internet…
v1.0.0 · audit A · 53 stars

Every file in akillness/jeo-skills

Other files named database-schema-design

database-schema-design SKILL.md skill
timwukp/agent-skills-best-practice · skills/skills/database-schema-design/SKILL.md · Designs normalized database schemas with migration scripts, indexing strategies, and relationship handling. Supports…
v1.0.0 · audit A · 12 stars
database-schema-design SKILL.md skill
wst2002/claude-code-skills · skills/database-schema-design/SKILL.md · Use when designing a database from scratch, reviewing tables, an ERD, a Prisma/TypeORM/JPA/Django/SQLAlchemy schema or…
git:20261016.55bd98a · audit A · 3 stars

Browse by kind, by grade A, or by owner.