database-patterns SKILL.md skillA

database-patterns from yonatangross/orchestkit is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add yonatangross/orchestkit/database-patterns@v2.0.0

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

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
yonatangross/orchestkit
Path
src/skills/database-patterns/SKILL.md
Versions recorded
10
Latest version
v2.0.0, committed Oct 7, 2026
First version recorded
Jul 25, 2026
Size
10,121 bytes
Repository stars
299
License
MIT

Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning. Use when creating migrations, designing schemas, normalizing data, managing database versions, or handling schema drift.

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

<!-- directive-density: intentional (teaches migration anti-patterns; NEVER markers describe real production-break conditions, not aspirational guidance) -->

# Database Patterns

Comprehensive patterns for database migrations, schema design, and version management. Each category has individual rule files in `rules/` loaded on-demand.

## Quick Reference

| Category | Rules | Impact | When to Use |
|----------|-------|--------|-------------|
| [Alembic Migrations](#alembic-migrations) | 2 | CRITICAL | Data migrations, branch management |
| [Schema Design](#schema-design) | 3 | HIGH | Normalization, indexing strategies, NoSQL patterns |
| [Versioning](#versioning) | 2 | HIGH | Changelogs, schema drift detection |
| [Zero-Downtime Migration](#zero-downtime-migration) | 2 | CRITICAL | Expand-contract, pgroll, rollback monitoring |

| [Database Selection](#database-selection) | 1 | HIGH | Choosing the right database, PostgreSQL vs MongoDB, cost analysis |

**Total: 10 rules across 5 categories**

This skill is a wrap around Alembic and PostgreSQL, not a replacement for their
docs. Read `references/ork-delta.md` first: it holds the
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add yonatangross/orchestkit/database-patterns@sha256:6cfe60c121988825

The line at the top of this page pins the label v2.0.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_ml3vzvwdw6pnmyxu.svg)](https://markdownregistry.com/a/art_ml3vzvwdw6pnmyxu)

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

Versions

The registry has recorded 10 versions of this file, between Jul 25, 2026 and Oct 7, 2026, about one every 8 days.

versioncommittedcommitsizeaudit
v2.0.0 latest2026-10-07 480e358 10,121 BA view · diff
v2.0.02026-09-30 e533cd5 10,125 BA view · diff
v2.0.02026-09-29 105a980 10,125 BA view · diff
v2.0.02026-09-28 220adb4 10,143 BA view · diff
v2.0.02026-09-20 02cb935 10,156 BA view · diff
v2.0.02026-09-06 fc0b166 10,156 BA view · diff
v2.0.02026-08-29 2aed0b0 11,236 BA view · diff
v2.0.02026-08-05 1f4cf61 11,236 BA view · diff
v2.0.02026-07-31 0e6a3a8 10,616 BA view · diff
v2.0.02026-07-25 47b78fb 7,543 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 (10121 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

yonatangross/orchestkit · 299 stars · license MIT · pushed 2026-11-07 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ml3vzvwdw6pnmyxu
GET https://markdownregistry.com/api/v1/resolve?ref=yonatangross/orchestkit/database-patterns
GET https://markdownregistry.com/api/v1/blob/6cfe60c12198882570890b484d5711abd7951b9760bd090726c4879d5aa858d8

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 yonatangross/orchestkit

AGENTS.md AGENTS.md file
yonatangross/orchestkit · AGENTS.md
git:20261022.980c9bf · audit A · 299 stars
CLAUDE.md CLAUDE.md file
yonatangross/orchestkit · CLAUDE.md
git:20261029.22dfd98 · audit A · 299 stars
AGENTS.md@docs/site AGENTS.md file
yonatangross/orchestkit · docs/site/AGENTS.md
git:20260823.5e31893 · audit A · 299 stars
CLAUDE.md@docs/site CLAUDE.md file
yonatangross/orchestkit · docs/site/CLAUDE.md
git:20260823.5e31893 · audit B · 299 stars
ork-assess SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-assess/SKILL.md · Assess a code change, design, architecture, workflow, or competing options against explicit criteria and evidence. Use…
git:20260819.cf231c6 · audit A · 299 stars
ork-brainstorm SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-brainstorm/SKILL.md · Compare plausible implementation, architecture, product, or operational approaches before committing to one. Use when a…
git:20260819.cf231c6 · audit A · 299 stars
ork-explore SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-explore/SKILL.md · Map an unfamiliar codebase, feature, architecture, data flow, or operational path with file-backed evidence. Use when a…
git:20260819.cf231c6 · audit A · 299 stars
ork-glyph SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-glyph/SKILL.md · Render an answer inline as compact ASCII or box-drawing art with semantic status icons. Use for status, inventories…
git:20260919.ab8d756 · audit A · 299 stars
ork-implement SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-implement/SKILL.md · Make an approved, scoped change and prove the affected behavior. Use when a request asks to implement, build, add, or…
git:20260825.dc3bfe8 · audit A · 299 stars
ork-review-pr SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-review-pr/SKILL.md · Review a pull request or branch for correctness, regressions, security, operational risk, and missing evidence. Use…
git:20260819.cf231c6 · audit A · 299 stars
ork-verify SKILL.md skill
yonatangross/orchestkit · plugins/ork-codex/skills/ork-verify/SKILL.md · Verify that existing work is ready to merge, release, or hand off using an explicit evidence contract. Use when a…
git:20260819.cf231c6 · audit A · 299 stars
CLAUDE.md@plugins/ork CLAUDE.md file
yonatangross/orchestkit · plugins/ork/CLAUDE.md
git:20261011.1894035 · audit A · 299 stars

Every file in yonatangross/orchestkit

Other files named database-patterns

database-patterns SKILL.md skill
yonatangross/orchestkit · plugins/ork/skills/database-patterns/SKILL.md · Schema design, Alembic migrations and database versioning. Use when creating migrations, designing or normalizing…
v2.0.0 · audit A · 299 stars
database-patterns SKILL.md skill
majiayu000/spellbook · skills/database-patterns/SKILL.md · Use when designing PostgreSQL + Redis data models, indexes, caching strategies, JSONB usage, tiered storage, or cache…
git:20260605.a09e45c · audit A · 290 stars

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