lh-data-modeling SKILL.md skillA
lh-data-modeling from jrodrigopuca/local-agents is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add jrodrigopuca/local-agents/lh-data-modeling@v1.1Pins v1.1 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- jrodrigopuca/local-agents
- Path
dba/skills/lh-data-modeling/SKILL.md- Versions recorded
- 1
- Latest version
- v1.1, committed Oct 14, 2026
- Size
- 4,047 bytes
- Repository stars
- 2
- License
- Apache-2.0
Designing schemas that survive real data: entities, keys, constraints, normalization and when to break it, and modelling access alongside structure. Trigger: load when designing a new schema, reviewing a proposed table or ORM model, or when an existing model keeps producing awkward queries.
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
## Critical Patterns ### 1. Model the questions, not just the nouns Entities tell you what exists; the queries tell you what the model has to make cheap. Before drawing tables, write down the handful of questions the system will ask constantly — "the last 20 orders for this user, newest first", "every unpaid invoice past due" — because those determine keys, sort order, and which columns need to live together. A model designed from the entity diagram alone is a model whose access paths are an accident. ### 2. Constraints are documentation the database enforces A foreign key says "this cannot point at nothing" in a way that survives a migration script, a second service, and a manual fix at 2am. NOT NULL, UNIQUE and CHECK say what is true about the domain — and unlike a comment or a validation in one codebase, they stay true. Push every rule you can into the schema: what you leave in application code only holds while that code is the only writer, which is never permanently true. ### 3. Normalize until it hurts, denormalize until it works Start normalized: one fact in one place, so an update is one write and cannot …
Read the whole file at its exact version.
How to install
mdr add jrodrigopuca/local-agents/lh-data-modeling@sha256:3e6dc97a33d21b70The line at the top of this page pins the label v1.1, 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.
[](https://markdownregistry.com/a/art_7dhbz5xcvcasi7qs)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 1 version of this file, committed on Oct 14, 2026.
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (4047 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
jrodrigopuca/local-agents · 2 stars · license Apache-2.0 · pushed 2026-10-23 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_7dhbz5xcvcasi7qs GET https://markdownregistry.com/api/v1/resolve?ref=jrodrigopuca/local-agents/lh-data-modeling GET https://markdownregistry.com/api/v1/blob/3e6dc97a33d21b70e9d45c5f3b42b22fb98fe73196df1854cb8ad9ff8c89e96d
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.