database-engineering SKILL.md skillA

database-engineering from rogue-dev-studio/ai-agents-rogue is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add rogue-dev-studio/ai-agents-rogue/database-engineering@git:20260801.aa14763

Pins git:20260801.aa14763 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
rogue-dev-studio/ai-agents-rogue
Path
skills/database-engineering/SKILL.md
Versions recorded
1
Latest version
git:20260801.aa14763, committed Aug 1, 2026
Size
4,341 bytes
Repository stars
2
License
a license file GitHub does not identify

Expert database engineering for application data layers: schema and ERD design, relational modeling, indexing, query performance gates, views, triggers, functions, mapping/junction tables, versioned migrations, seeders, and PostgreSQL/MySQL operational practice. Use for Database Engineer delivery, migration work, integrity constraints, and measurable read/write performance.

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 Engineering (Canonical)

**Expertise: expert.** Aliases: `database`, `postgresql`, `sql`, `migrations`, `dba`, `schema-design`.

Data-layer playbook for the **Database Engineer** role. It does not replace `supabase-cli` (Supabase runtime) or the global `security` rule (auth/PII policy).

## When to use

- Desain/ubah schema, ERD, **relasi**, constraint, **index**
- Migration / seeder (Laravel `database/migrations`, SQL generik, dll.)
- **Performance**: pagination di DB, anti-N+1, EXPLAIN, index strategy, transaksi pendek
- Objek DB lanjutan: **VIEW**, **TRIGGER**, **FUNCTION** / procedure (bila stack mengizinkan)
- Tabel **mapping / junction / `_mp`** (N:M dan pemetaan referensi)
- Integritas data, unique/FK, cascade, soft-delete vs hard-delete
- PostgreSQL (default Phase 1 house) atau MySQL/MariaDB bila stack project memakai itu
- Review perubahan DB sebelum Backend mengikat API

## When not to use

- Hanya business logic / API contract → Backend / Tech Lead
- Hanya UI list/filter → Frontend
- Operasi container DB saja tanpa schema → `container-docker-ops`
- Edge functions / Supabase CLI spesifik → `supabase-cli`
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add rogue-dev-studio/ai-agents-rogue/database-engineering@sha256:5704c677e345a71b

The line at the top of this page pins the label git:20260801.aa14763, 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_4fnuwgac3chdjwjc.svg)](https://markdownregistry.com/a/art_4fnuwgac3chdjwjc)

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

Versions

The registry has recorded 1 version of this file, committed on Aug 1, 2026.

versioncommittedcommitsizeaudit
git:20260801.aa14763 latest2026-08-01 aa14763 4,341 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 (4341 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

rogue-dev-studio/ai-agents-rogue · 2 stars · license a license file GitHub does not identify · pushed 2026-10-17 · branch master

API

GET https://markdownregistry.com/api/v1/artifacts/art_4fnuwgac3chdjwjc
GET https://markdownregistry.com/api/v1/resolve?ref=rogue-dev-studio/ai-agents-rogue/database-engineering
GET https://markdownregistry.com/api/v1/blob/5704c677e345a71b421254c250ec703e4eb9a4dff5dab77b6cb4b944fe11ffe5

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 rogue-dev-studio/ai-agents-rogue

AGENTS.md AGENTS.md file
rogue-dev-studio/ai-agents-rogue · AGENTS.md
git:20261017.a316ad9 · audit A · 2 stars
agentic-flow SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/agentic-flow/SKILL.md · Canonical multi-agent orchestration: decompose work, dependency graphs, parallel tracks, handoffs, and merge. Absorbs…
git:20260731.ddb8838 · audit A · 2 stars
agentic-qe SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/agentic-qe/SKILL.md · Canonical quality engineering: test strategy, case generation, coverage gates, exploratory checks, and security-tinged…
git:20260731.ddb8838 · audit A · 2 stars
ai-coding-assistants SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/ai-coding-assistants/SKILL.md · Canonical playbook for AI coding assistants and CLI pair-programmers (Claude Code, Kilo, Goose, OpenCode, multi-CLI…
git:20260731.ddb8838 · audit A · 2 stars
algorithmic-art SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/algorithmic-art/SKILL.md · Generative algorithmic art. Use when the project needs this capability or the user / team manifest asks for it. Use for…
git:20260731.ddb8838 · audit A · 2 stars
api-engineering SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/api-engineering/SKILL.md · Expert API design and delivery: resource modeling, versioning, consistent error envelopes, pagination/filtering…
git:20260801.aa14763 · audit A · 2 stars
auth-access-control SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/auth-access-control/SKILL.md · Expert authentication and authorization engineering: identity lifecycle, session/token handling, password/OTP flows…
git:20260801.aa14763 · audit A · 2 stars
backend-engineering SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/backend-engineering/SKILL.md · Expert backend application engineering: layered architecture, domain services, validation, transactions, caching…
git:20260801.aa14763 · audit A · 2 stars
blender SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/blender/SKILL.md · Prefer this for any 3D modeling, mesh, scene, render, or Blender request (e.g. "buat model 3D ikan", character, prop)…
git:20260731.ee74c16 · audit A · 2 stars
browser-automation SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/browser-automation/SKILL.md · Canonical browser automation and web UI verification: Playwright, agent browser CLIs, and CDP-based tooling in one…
git:20260731.dea1934 · audit A · 2 stars
canvas-design SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/canvas-design/SKILL.md · Design system framework. Use when the project needs this capability or the user / team manifest asks for it. Use for…
git:20260731.ddb8838 · audit A · 2 stars
clarity SKILL.md skill
rogue-dev-studio/ai-agents-rogue · skills/clarity/SKILL.md · Canonical spec and requirements skill: 5-phase clarity workflow plus Spec-Kit / markdown-agent spec patterns. Use for…
git:20260731.ddb8838 · audit A · 2 stars

Every file in rogue-dev-studio/ai-agents-rogue

Other files named database-engineering

database-engineering SKILL.md skill
foreturn/product-studio · skills/database-engineering/SKILL.md · 用于数据库物理 Schema 设计、索引与查询优化、事务隔离与锁、迁移演进、备份恢复与高可用裁定。
git:20261014.9089425 · audit A · 3 stars

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