awesome-database-audit SKILL.md skillA

awesome-database-audit from khasky/awesome-agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add khasky/awesome-agent-skills/awesome-database-audit@git:20261019.a19c2a5

Pins git:20261019.a19c2a5 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
khasky/awesome-agent-skills
Path
skills/awesome-database-audit/SKILL.md
Versions recorded
8
Latest version
git:20261019.a19c2a5, committed Oct 19, 2026
First version recorded
Sep 3, 2026
Size
14,125 bytes
Repository stars
30
License
MIT

Read-only audit of a database layer: schema anti-patterns, query and index fit, integrity, concurrency, migrations, tenancy, with a verdict. Use when asked to review a schema, migrations or data model.

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 Audit

Audit a database layer — schema, queries, migrations, and the operational habits around them — for the design defects that surface as slow queries, silent data corruption, and unrunnable migrations in production. Read-only: it reports findings and a verdict; it never edits schema, data, or code. Works from the repo's schema files, migrations, and query sites; a live connection is optional and read-only when present. An executing plan (`EXPLAIN ANALYZE` and its equivalents) runs the statement it measures, so on a live database it is used for reads only; a write gets the estimated plan, or its executing plan is prescribed for a disposable copy.

Evidence, not taste. Every finding cites its artifact — a `file:line` in a migration or model, a query site, a schema definition, an `EXPLAIN` output if a connection exists. A "smelly" table name is a lead; confirm the defect (the missing constraint, the unindexable predicate) before flagging.

Four audit tracks — run the ones in scope:
- A. Schema design — types, keys, and the anti-pattern catalog.
- B. Query patterns and indexes — what the code asks, and whether an index can answer it.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add khasky/awesome-agent-skills/awesome-database-audit@sha256:a75c8f9742812492

The line at the top of this page pins the label git:20261019.a19c2a5, 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_utidqy3qzasxfwup.svg)](https://markdownregistry.com/a/art_utidqy3qzasxfwup)

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

Versions

The registry has recorded 8 versions of this file, between Sep 3, 2026 and Oct 19, 2026, about one every 7 days.

versioncommittedcommitsizeaudit
git:20261019.a19c2a5 latest2026-10-19 a19c2a5 14,125 BA view · diff
git:20261010.3b37a6b2026-10-10 3b37a6b 14,130 BA view · diff
git:20261010.d6650102026-10-10 d665010 12,311 BA view · diff
git:20260925.eca990b2026-09-25 eca990b 10,522 BA view · diff
git:20260925.d8504402026-09-25 d850440 10,625 BA view · diff
git:20260910.ad72ad42026-09-10 ad72ad4 10,910 BA view · diff
git:20260905.498c6052026-09-05 498c605 11,114 BA view · diff
git:20260903.308080e2026-09-03 308080e 10,806 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 (14125 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

khasky/awesome-agent-skills · 30 stars · license MIT · pushed 2026-10-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_utidqy3qzasxfwup
GET https://markdownregistry.com/api/v1/resolve?ref=khasky/awesome-agent-skills/awesome-database-audit
GET https://markdownregistry.com/api/v1/blob/a75c8f9742812492e4052905df78b1181ed1162488ab058dc02b8ad9e9e62822

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 khasky/awesome-agent-skills

AGENTS.md AGENTS.md file
khasky/awesome-agent-skills · AGENTS.md
git:20261018.a4259a5 · audit A · 30 stars
CLAUDE.md CLAUDE.md file
khasky/awesome-agent-skills · CLAUDE.md
git:20260912.c0b82df · audit B · 30 stars
llms.txt llms.txt file
khasky/awesome-agent-skills · llms.txt
git:20261010.3b37a6b · audit A · 30 stars
awesome-accessibility-audit SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-accessibility-audit/SKILL.md · Read-only WCAG audit of UI and markup with a concrete fix per finding. Use when asked to check accessibility, a11y…
git:20261020.58ea4e8 · audit A · 30 stars
awesome-agents-md-generator SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-agents-md-generator/SKILL.md · Mines a codebase's real commands, conventions and boundaries into an agent-agnostic AGENTS.md, nested per package in…
git:20261018.a4259a5 · audit A · 30 stars
awesome-api-design SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-api-design/SKILL.md · Designs or reviews an HTTP API's shape before code: resources, versioning, pagination, idempotency, filtering. Use when…
git:20261018.a4259a5 · audit A · 30 stars
awesome-architecture-audit SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-architecture-audit/SKILL.md · Read-only audit of a whole codebase's design: module boundaries, dependency direction, docs-vs-code drift…
git:20261019.a19c2a5 · audit B · 30 stars
awesome-bug-fix SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-bug-fix/SKILL.md · Fixes a bug through a runnable reproduction and its root cause. Use for errors, crashes, failing tests or builds, flaky…
git:20261020.58ea4e8 · audit A · 30 stars
awesome-claims-audit SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-claims-audit/SKILL.md · Checks public claims (site, README, store listing, privacy policy, structured data) against the code and config that…
git:20261019.a19c2a5 · audit A · 30 stars
awesome-code-cleanup SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-code-cleanup/SKILL.md · Behavior-preserving cleanup of AI-like code noise: narrating comments, dead code, vague names, over-abstraction. Use…
git:20261020.58ea4e8 · audit A · 30 stars
awesome-code-docs SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-code-docs/SKILL.md · Generates a full, cited technical documentation set for a codebase, local or from any git URL: architecture, module and…
git:20261018.a4259a5 · audit A · 30 stars
awesome-code-explainer SKILL.md skill
khasky/awesome-agent-skills · skills/awesome-code-explainer/SKILL.md · Explains how a codebase works, local or from any git URL, as one illustrated page: purpose, stack, structure, entry…
git:20261018.a4259a5 · audit A · 30 stars

Every file in khasky/awesome-agent-skills

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