data-integrity SKILL.md skillA

This file is byte-identical to the first copy the registry indexed, one of 8 indexed copies. Same content hash, so the same checks give both the same grade.

data-integrity from globalmpc/backendskills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

mdr add globalmpc/backendskills/data-integrity@git:20261105.6131a31

Pins git:20261105.6131a31 in mdr.lock. Pin the fingerprint instead.

Audit grade

A, 17 of 17 checks passed

Kind

SKILL.md skill

Repository

globalmpc/backendskills

Path

bench/results/2026-11-04/checkout-with-1-20261105081443-28376/skills/data-integrity/SKILL.md

Versions recorded

1

Latest version

git:20261105.6131a31, committed Nov 5, 2026

Size

5,434 bytes

Repository stars

25

License

MIT

Rules for code that writes to the database where two requests, retries or jobs can run at once. Use for anything that changes money, stock, balances, counters or statuses, creates rows that must be unique, or calls a payment provider, email or other outside service. Applies in endpoints, webhooks and background jobs.

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

# Data integrity

Examples are TypeScript with `pg`. The rules apply to any stack. Assume every write can run twice at the
same time: two clicks, a client retry, two servers picking up the same job.

## 1. Read-then-write is one conditional statement, or one transaction with a lock

Why: two requests at once both read "1 seat left", both book it. Counts go negative and money gets created.

```ts
// Bad: check and write are separate; a concurrent request slips in between
const { rows: [e] } = await pool.query("select seats_left from events where id = $1", [id]);
if (e.seats_left < seats) return sendError(res, 409, "sold_out", "Not enough seats");
await pool.query("update events set seats_left = seats_left - $1 where id = $2", [seats, id]);

// Good: the check is part of the write
const { rowCount } = await client.query(
  "update events set seats_left = seats_left - $1 where id = $2 and seats_left >= $1", [seats, id]);
if (rowCount === 0) throw new HttpError(409, "sold_out", "Not enough seats");
```

When several rows must change together (every line of a booking, both accounts in a payment), do it in one
…

Read the whole file at its exact version.

How to install

mdr add globalmpc/backendskills/data-integrity@sha256:dc3cf0ab531b421d

[![mdr](https://markdownregistry.com/badge/art_dj5khshpbvribonb.svg)](https://markdownregistry.com/a/art_dj5khshpbvribonb)

Versions

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

Audit of the latest version

Source

API

GET https://markdownregistry.com/api/v1/artifacts/art_dj5khshpbvribonb
GET https://markdownregistry.com/api/v1/resolve?ref=globalmpc/backendskills/data-integrity
GET https://markdownregistry.com/api/v1/blob/dc3cf0ab531b421d93acd85441ddabc7f513e44dda34ce0b848c419099763e20

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 globalmpc/backendskills

Every file in globalmpc/backendskills

Other files named data-integrity

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