database-review SKILL.md skillA

database-review from frnkgns/gentjinskills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add frnkgns/gentjinskills/database-review@git:20260928.a142223

Pins git:20260928.a142223 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
frnkgns/gentjinskills
Path
skills/database-review/SKILL.md
Versions recorded
5
Latest version
git:20260928.a142223, committed Sep 28, 2026
First version recorded
Sep 24, 2026
Size
3,362 bytes
Repository stars
7
License
none declared

Review database, query, schema, migration, and data-layer changes for correctness, query-level performance, authorization, data integrity, and connection failures. MUST be used before creating or modifying schema or migrations, before any database write, and whenever queries or data access change, including during cleanup. Not for handler, service, job, retry, or idempotency concerns; use `backend-review` for those.

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 Review

## Safety Default

The global `## Safety` rules in AGENTS.md govern database access: read-only SELECT against clone or dev databases by default, and no write, DDL, migration, or destructive operation without explicit authorization. Schema or migration work requires an explicit request, and production credentials and secrets are never touched.

Prefer small, reviewable, reversible migrations, prepared in code rather than applied to a live database unless explicitly requested.

## Query and Data-Layer Review

For changed queries, loaders, actions, or the data-access portion of a fetching path:

- Avoid N+1 queries and duplicate requests.
- Avoid unnecessary columns/records.
- Use appropriate filtering, pagination, joins, indexes, caching, batching, or parallelization when justified.
- Reuse data already available in the request/component flow.
- Avoid unnecessary sequential blocking.
- Verify query correctness, ownership, and authorization constraints.
- Do not prematurely optimize unaffected code.

## Data Integrity

- Validate inputs.
- Ensure mutations cannot create duplicate/inconsistent records.
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add frnkgns/gentjinskills/database-review@sha256:b7a6b0114694f7f7

The line at the top of this page pins the label git:20260928.a142223, 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_kr67tcs5j4w5nywb.svg)](https://markdownregistry.com/a/art_kr67tcs5j4w5nywb)

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

Versions

The registry has recorded 5 versions of this file, between Sep 24, 2026 and Sep 28, 2026, more than one a day.

versioncommittedcommitsizeaudit
git:20260928.a142223 latest2026-09-28 a142223 3,362 BA view · diff
git:20260927.23e825b2026-09-27 23e825b 3,358 BA view · diff
git:20260926.3185b842026-09-26 3185b84 3,271 BA view · diff
git:20260924.23cbe4b2026-09-24 23cbe4b 2,897 BA view · diff
git:20260924.99874662026-09-24 9987466 2,172 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 (3362 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

frnkgns/gentjinskills · 7 stars · license none declared · pushed 2026-10-21 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_kr67tcs5j4w5nywb
GET https://markdownregistry.com/api/v1/resolve?ref=frnkgns/gentjinskills/database-review
GET https://markdownregistry.com/api/v1/blob/b7a6b0114694f7f7f1027520f9c0c639dd27ccc43ea77125a098508b0bbf2bb7

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 frnkgns/gentjinskills

gentjin Cursor rule
frnkgns/gentjinskills · .cursor/rules/gentjin.mdc · Overgeared Skills orchestration, skills, and memory rules
git:20261021.7da3b89 · audit A · 7 stars
AGENTS.md AGENTS.md file
frnkgns/gentjinskills · AGENTS.md
git:20261021.7da3b89 · audit A · 7 stars
CLAUDE.md CLAUDE.md file
frnkgns/gentjinskills · CLAUDE.md
git:20261021.7da3b89 · audit B · 7 stars
api-design SKILL.md skill
frnkgns/gentjinskills · skills/api-design/SKILL.md · Review or design stable API contracts. Use when creating a new API, changing an existing contract, designing…
git:20260926.3185b84 · audit A · 7 stars
architecture-review SKILL.md skill
frnkgns/gentjinskills · skills/architecture-review/SKILL.md · Analyze significant cross-module or process-level structural changes before implementing them. Use when adding a…
git:20260928.a142223 · audit A · 7 stars
backend-review SKILL.md skill
frnkgns/gentjinskills · skills/backend-review/SKILL.md · Review server-side logic that is not purely database or security work. Use for API handlers, server functions…
git:20260926.3185b84 · audit A · 7 stars
cleanup SKILL.md skill
frnkgns/gentjinskills · skills/cleanup/SKILL.md · Finish and QA current implementation work before handoff, review, or merge. Use when the user asks to clean up, and…
git:20260928.a142223 · audit A · 7 stars
compaction SKILL.md skill
frnkgns/gentjinskills · skills/compaction/SKILL.md · Condense older conversation and work context into a small, accurate working summary when context grows large. MUST be…
git:20260928.a142223 · audit A · 7 stars
dependency-review SKILL.md skill
frnkgns/gentjinskills · skills/dependency-review/SKILL.md · Safely evaluate dependency additions, upgrades, and replacements. Use when adding a package, upgrading dependencies…
git:20260926.3185b84 · audit A · 7 stars
deployment-readiness SKILL.md skill
frnkgns/gentjinskills · skills/deployment-readiness/SKILL.md · Assess whether a project is safe to ship to production. Use when the user asks about deployment, release, production…
git:20260928.a142223 · audit A · 7 stars
frontend-review SKILL.md skill
frnkgns/gentjinskills · skills/frontend-review/SKILL.md · Review changed frontend/UI code for responsive design, UX consistency, accessibility, optimistic interactions…
git:20261017.0ccca93 · audit A · 7 stars
git-workflow SKILL.md skill
frnkgns/gentjinskills · skills/git-workflow/SKILL.md · Handle guarded Git and source-control workflows. MUST be used before any commit, branch creation, push, merge, rebase…
git:20261008.c3a4e2a · audit A · 7 stars

Every file in frnkgns/gentjinskills

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