Home / canonry / canonry · GitHub

AGENTS.md@packages/dbA

AGENTS.md@packages/db from canonry/canonry is an AGENTS.md file: the standing instructions coding agents read in that repo.

Install it, pinned

mdr add canonry/canonry/packages/db/AGENTS.md@git:20261022.8a7aeb5

Pins git:20261022.8a7aeb5 in mdr.lock. Pin the fingerprint instead.

Audit grade: A, 14 of 14 checks passed
Kind: AGENTS.md file
Repository: canonry/canonry
Path: packages/db/AGENTS.md
Versions recorded: 31
Latest version: git:20261022.8a7aeb5, committed Oct 22, 2026
First version recorded: May 17, 2026
Size: 22,695 bytes
Repository stars: 193
License: MIT

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

# db

## Purpose

Drizzle ORM schema, migrations, and database client. SQLite locally (via better-sqlite3), Postgres for cloud. Auto-migrates on startup. Tables cover projects, runs, snapshots, integrations, and system tracking.

## Key Files

| File | Role |
|------|------|
| `src/schema.ts` | All table definitions (`sqliteTable`) with indexes and constraints |
| `src/migrate.ts` | Migration runner — `MIGRATION_SQL` (initial bootstrap) + `MIGRATION_VERSIONS` array (versioned, incremental) plus the `_migrations` tracking table |
| `src/client.ts` | `createClient()` factory — WAL journal, foreign keys, 5s busy timeout |
| `src/sentiment-repository.ts` | Transactional sentiment definitions, enablement epochs, completion receipts, job admission, leases, attempt and result storage |
| `src/json.ts` | `parseJsonColumn<T>(value, fallback)` — safe JSON deserialization for DB columns |
| `src/index.ts` | Re-exports all public API |
| `src/operational-logs.ts` | Bounded durable runtime diagnostics; sanitized, cursor-bound reads. Diagnostic writes/pruning use zero lock-wait and synchronously restore the application's busy timeout; failed capture falls back to an in-memory error counter. |
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint

mdr add canonry/canonry/packages/db/AGENTS.md@sha256:486b1fcc04ee6ac9

The line at the top of this page pins the label git:20261022.8a7aeb5, 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](https://markdownregistry.com/badge/art_vtxh6zarlduhocv5.svg)](https://markdownregistry.com/a/art_vtxh6zarlduhocv5)

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

Versions

The registry has recorded 31 versions of this file, between May 17, 2026 and Oct 22, 2026, about one every 5 days.

version	committed	commit	size	audit
git:20261022.8a7aeb5 latest	2026-10-22	8a7aeb5	22,695 B	A	view · diff
git:20261022.e27d5bf	2026-10-22	e27d5bf	22,048 B	A	view · diff
git:20261022.a0cad23	2026-10-22	a0cad23	21,965 B	A	view · diff
git:20261021.84cfd30	2026-10-21	84cfd30	21,339 B	A	view · diff
git:20261015.c8ecbd8	2026-10-15	c8ecbd8	21,034 B	A	view · diff
git:20261013.1c90811	2026-10-13	1c90811	21,032 B	A	view · diff
git:20261012.89a7b4b	2026-10-12	89a7b4b	20,539 B	A	view · diff
git:20261011.041436a	2026-10-11	041436a	20,125 B	A	view · diff
git:20261009.292663b	2026-10-09	292663b	18,871 B	A	view · diff
git:20261008.0c7138f	2026-10-08	0c7138f	18,521 B	A	view · diff
git:20261008.df2022e	2026-10-08	df2022e	18,018 B	A	view · diff
git:20261007.ecdc505	2026-10-07	ecdc505	15,881 B	A	view · diff
git:20261007.254a7fb	2026-10-07	254a7fb	15,650 B	A	view · diff
git:20261004.07710f0	2026-10-04	07710f0	15,204 B	A	view · diff
git:20261001.408113d	2026-10-01	408113d	14,844 B	A	view · diff
git:20260929.0417a85	2026-09-29	0417a85	14,755 B	A	view · diff
git:20260928.b528a18	2026-09-28	b528a18	14,317 B	A	view · diff
git:20260928.927559d	2026-09-28	927559d	14,381 B	A	view · diff
git:20260928.a39f687	2026-09-28	a39f687	11,411 B	A	view · diff
git:20260928.6369ada	2026-09-28	6369ada	11,082 B	A	view · diff
git:20260922.d237087	2026-09-22	d237087	10,220 B	A	view · diff
git:20260921.1697bee	2026-09-21	1697bee	10,012 B	A	view · diff
git:20260919.46b60a6	2026-09-19	46b60a6	9,776 B	A	view · diff
git:20260912.9cc37ab	2026-09-12	9cc37ab	7,913 B	A	view · diff
git:20260910.2bcbc86	2026-09-10	2bcbc86	7,497 B	A	view · diff
git:20260908.a797639	2026-09-08	a797639	7,193 B	A	view · diff
git:20260810.f1a6879	2026-08-10	f1a6879	6,864 B	A	view · diff
git:20260721.645f5cc	2026-07-21	645f5cc	6,470 B	A	view · diff
git:20260721.9aaff8b	2026-07-21	9aaff8b	6,369 B	A	view · diff
git:20260629.4992f29	2026-06-29	4992f29	6,268 B	A	view · diff
git:20260517.62e01b5	2026-05-17	62e01b5	6,196 B	A	view

Audit of the latest version

A 14 of 14 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.

pass: Size between 200 bytes and 200 KB (22695 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

canonry/canonry · 193 stars · license MIT · pushed 2026-10-23 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_vtxh6zarlduhocv5
GET https://markdownregistry.com/api/v1/resolve?ref=canonry/canonry/packages/db/AGENTS.md
GET https://markdownregistry.com/api/v1/blob/486b1fcc04ee6ac9e8becab00bbfa7a5d0e339b665ac4b6e646c570767c142e2

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: how to write a good AGENTS.md · AGENTS.md vs CLAUDE.md · which agent file does what.

More from canonry/canonry

test-audit SKILL.md skill

canonry/canonry · .agents/skills/test-audit/SKILL.md · Invoke whenever writing, changing, reviewing, running, or sweeping Canonry tests. Authoring gate for new tests plus…

git:20261015.3a14a05 · audit A · 193 stars

AGENTS.md AGENTS.md file

canonry/canonry · AGENTS.md

git:20261020.3ca6ab5 · audit A · 193 stars

DESIGN.md DESIGN.md file

canonry/canonry · DESIGN.md

git:20261010.862ea14 · audit A · 193 stars

AGENTS.md@apps/api AGENTS.md file

canonry/canonry · apps/api/AGENTS.md

git:20261007.254a7fb · audit A · 193 stars

AGENTS.md@apps/vals/ai-visibility-check AGENTS.md file

canonry/canonry · apps/vals/ai-visibility-check/AGENTS.md