drizzle-orm

drizzle-orm is a skill for Claude Code, Codex from hoangatg/ai-agent-toolkit. It costs 39 tokens per session (407 once invoked), scanned A, original, MIT.

Drizzle ORM patterns for TypeScript. Type-safe SQL queries, schema definitions, migrations, and relational queries. Use when building type-safe database layers in TypeScript projects.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/hoangatg/ai-agent-toolkit/drizzle-orm
Any agent
npx skills add hoangatg/ai-agent-toolkit --skill drizzle-orm
Clone the repo
git clone --depth 1 https://github.com/hoangatg/ai-agent-toolkit

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for drizzle-orm

README.md
[![agentmods](https://agentmods.dev/badge/skills/hoangatg/ai-agent-toolkit/drizzle-orm.svg)](https://agentmods.dev/skills/hoangatg/ai-agent-toolkit/drizzle-orm)
Your own site
<a href="https://agentmods.dev/skills/hoangatg/ai-agent-toolkit/drizzle-orm"><img src="https://agentmods.dev/badge/skills/hoangatg/ai-agent-toolkit/drizzle-orm.svg" alt="Measured on agentmods" height="20"></a>
Per session 39 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 407 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin unknown No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00039 $0.00407
Opus 5 $0.00019 $0.00204
Sonnet 5 $0.00008 $0.00081
Haiku 4.5 $0.00004 $0.00041

Measured today against content hash 8b898166b0b9, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

drizzle-orm scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured today.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.agent/skills/drizzle-orm/SKILL.md · 52 lines

What it actually says

Drizzle ORM

Type-safe SQL in TypeScript. If you know SQL, you know Drizzle.

Why Drizzle?

Feature Prisma Drizzle
Approach Schema-first, client gen SQL-like API
Bundle size Heavy (engine) Lightweight (~30kb)
SQL control Abstracted Full SQL access
Edge compatible Limited Full support
Type safety Schema-derived Inferred from schema

Schema Definition

import { pgTable, serial, text, timestamp } from 'drizzle-orm/pg-core'

export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  email: text('email').notNull().unique(),
  createdAt: timestamp('created_at').defaultNow(),
})

Query Patterns

  • Select: db.select().from(users).where(eq(users.id, 1))
  • Insert: db.insert(users).values({ name, email })
  • Relations: db.query.users.findMany({ with: { posts: true } })
  • Raw SQL: sql\SELECT * FROM users WHERE id = ${id}``

Best Practices

Practice Why
Use drizzle-kit for migrations Type-safe schema evolution
Infer types from schema typeof users.$inferSelect
Use transactions db.transaction(async (tx) => { ... })
Edge-ready Works with D1, PlanetScale, Neon, Turso
Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. today First seen · 52 lines · 39 tokens per session scan A 8b898166b0b9

Subscribe to this mod's changes

drizzle-orm is a skill published in the GitHub repository hoangatg/ai-agent-toolkit (1 stars, last pushed 5mo ago), licensed MIT. It adds 39 tokens to every session and 407 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.