010117-drizzle-orm-patterns — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited 010117-drizzle-orm-patterns (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
When building PostgreSQL schemas with Drizzle ORM. Covers table conventions, constraints, vector search, and domain factories.
| Topic | File |
|---|---|
| Table naming, prefixes, timestamps | references/table-conventions.md |
| FK constraints and cascade rules | references/foreign-keys.md |
| Vector columns and HNSW indexes | references/vector-columns.md |
| JSONB columns and GIN indexes | references/jsonb-gin.md |
Raw SQL with sql\\`` | references/raw-sql.md |
| Domain factory pattern | references/domain-factories.md |
prd_ (prod), sys_ (system), tst_ (test)id() from _cuid.ts for UUID PKs.references(()=>Table.id, {onDelete: "cascade"|"set null"}) for FKsxxxId columns as .references() — never leave implicitcreateXxxRepo(table)as any to bridge Drizzle's complex types in factoriesvector({ dimensions: 384 }) + HNSW indexjsonb() + GIN @> indextimestamps spread (createdAt, updatedAt, deletedAt)~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.