database SKILL.md skillA
database from umararshad4/honey-stack is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add umararshad4/honey-stack/database@git:20261017.c52b424Pins git:20261017.c52b424 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- umararshad4/honey-stack
- Path
skills/database/SKILL.md- Versions recorded
- 2
- Latest version
- git:20261017.c52b424, committed Oct 17, 2026
- First version recorded
- Oct 17, 2026
- Size
- 4,527 bytes
- Repository stars
- 4
- License
- MIT
Design schemas, write safe/online migrations, add indexes, fix slow queries and N+1, get transactions and concurrency right. Postgres-first. Use when touching schema, migrations, indexing, query perf, or locking.
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 Model data, change it safely on a live system, and make queries fast. Default engine is **Postgres**; the method carries to others. Push invariants into the database (constraints) — it's the one layer nothing bypasses. ## Confirm before (never on your own) - Running **any migration against production**, especially one that locks, rewrites a table, or drops a column/table. - `EXPLAIN ANALYZE` or a backfill on prod that **mutates data** (wrap in a transaction and roll back, or use a prod-sized copy). - Dropping an index/column/table, or a destructive data fix. ## Schema design - Normalize to 3NF first; denormalize only with a measured read-pattern reason, recorded in the migration. - **Primary key:** `bigint GENERATED ALWAYS AS IDENTITY` for internal tables (smallest, best index locality); **UUIDv7** (`uuidv7()` on PG18, else app-generated) when IDs are exposed, client-generated, or merged across shards — time-ordered, so unlike UUIDv4 it keeps insert locality. Store as native `uuid`, never `varchar`. - Default `NOT NULL`; NULL means "unknown" and breaks `=`. Use it only when absence is meaningful. …
Read the whole file at its exact version.
How to install
mdr add umararshad4/honey-stack/database@sha256:8b4966f53b7c3b2cThe line at the top of this page pins the label git:20261017.c52b424, 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_u6d2vfa5yr2azzib)
2 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 2 versions of this file, all committed on Oct 17, 2026.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261017.c52b424 latest | 2026-10-17 | c52b424 | 4,527 B | A | view · diff |
| git:20261017.e40035b | 2026-10-17 | e40035b | 4,502 B | A | view |
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 (4527 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
umararshad4/honey-stack · 4 stars · license MIT · pushed 2026-11-01 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_u6d2vfa5yr2azzib GET https://markdownregistry.com/api/v1/resolve?ref=umararshad4/honey-stack/database GET https://markdownregistry.com/api/v1/blob/8b4966f53b7c3b2ca9601d160bc1009a336d56ebe5221072f456aaf691ab727d
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 umararshad4/honey-stack
Every file in umararshad4/honey-stack