sota-databases SKILL.md skillA
sota-databases from martinholovsky/sota-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add martinholovsky/sota-skills/sota-databases@git:20261012.ae1b29bPins git:20261012.ae1b29b in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- martinholovsky/sota-skills
- Path
skills/sota-databases/SKILL.md- Versions recorded
- 6
- Latest version
- git:20261012.ae1b29b, committed Oct 12, 2026
- First version recorded
- Jun 17, 2026
- Size
- 9,097 bytes
- Repository stars
- 23
- License
- CC-BY-4.0
State-of-the-art database engineering rules (2026) for designing, building, and auditing data layers. Covers engine selection, schema modeling, migrations, query and index craft, transactions and concurrency, reliability and scale, security, and vector/AI workloads. Use when designing a new data layer, writing or reviewing schemas/migrations/queries, debugging slow or contended database workloads, or auditing an existing database for correctness, performance, and security. Not for ETL or…
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
# SOTA Databases Expert-level rules for the full lifecycle of a data layer: choosing an engine, modeling data, evolving schemas safely, writing efficient queries, handling concurrency, operating reliably at scale, securing data, and supporting vector/AI workloads. Postgres is the reference engine; rules call out where other systems (MySQL, Redis, document/columnar/vector stores) differ. This skill operates in two modes. Determine the mode from the user's intent, then load the relevant `rules/` files per the index below. Do not load all files preemptively — pick by task. ## BUILD mode Use when designing or implementing: new schemas, migrations, queries, ORM layers, caching, job queues, or database infrastructure. 1. **Engine and model first.** Read [`rules/01-choosing-and-modeling.md`](rules/01-choosing-and-modeling.md) before writing any DDL. Default to Postgres unless a rule there says otherwise. 2. **Every schema change is a migration.** Never hand the user raw DDL to run ad hoc; produce migration files following [`rules/02-schema-migrations.md`](rules/02-schema-migrations.md) (expand/contract, lock-aware, reversible-or-documented). …
Read the whole file at its exact version.
How to install
mdr add martinholovsky/sota-skills/sota-databases@sha256:ac43aa41ce041a7bThe line at the top of this page pins the label git:20261012.ae1b29b, 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_wvckjoci6myysjn7)
4 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 6 versions of this file, between Jun 17, 2026 and Oct 12, 2026, about one every 23 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261012.ae1b29b latest | 2026-10-12 | ae1b29b | 9,097 B | A | view · diff |
| git:20260926.3b81c65 | 2026-09-26 | 3b81c65 | 8,590 B | A | view · diff |
| git:20260820.7720f5a | 2026-08-20 | 7720f5a | 8,500 B | A | view · diff |
| git:20260817.2bd20ab | 2026-08-17 | 2bd20ab | 8,423 B | A | view · diff |
| git:20260716.e4afc80 | 2026-07-16 | e4afc80 | 8,393 B | A | view · diff |
| git:20260617.c5d2c7b | 2026-06-17 | c5d2c7b | 8,320 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 (9097 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
martinholovsky/sota-skills · 23 stars · license CC-BY-4.0 · pushed 2026-10-21 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_wvckjoci6myysjn7 GET https://markdownregistry.com/api/v1/resolve?ref=martinholovsky/sota-skills/sota-databases GET https://markdownregistry.com/api/v1/blob/ac43aa41ce041a7b14c0dd09ceb0b26ab989d3cbdd70035e986828467bce4c1c
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.