Agent Skills: Drizzle ORM Knowledge Patch

Drizzle ORM Knowledge Patch

Claude Opus 4.6 knows Drizzle ORM through 0.30.x. This skill provides features from 1.0.0-beta.15 (2025-02-05) onwards.

Index

| Topic | Reference | Key features | |---|---|---| | Schema validation | references/schema-validation.md | Validator packages consolidated into drizzle-orm, Effect Schema support | | Drivers and queries | references/drivers-and-queries.md | node-sqlite driver, .comment() query tagging |

Quick Reference

Validator imports (consolidated)

Old standalone packages are now available as drizzle-orm subpath imports:

| Library | New import path | |---|---| | Zod | drizzle-orm/zod | | Valibot | drizzle-orm/valibot | | TypeBox | drizzle-orm/typebox | | TypeBox (legacy) | drizzle-orm/typebox-legacy | | ArkType | drizzle-orm/arktype | | Effect Schema | drizzle-orm/effect-schema |

// Old (still works)
import { createInsertSchema } from 'drizzle-zod';
// New (recommended)
import { createInsertSchema } from 'drizzle-orm/zod';

See references/schema-validation.md for all import paths.

node-sqlite driver

Use Node.js's built-in node:sqlite module:

import { drizzle } from 'drizzle-orm/node-sqlite';
const db = drizzle("sqlite.db");

// Or with existing DatabaseSync instance
import { DatabaseSync } from 'node:sqlite';
const sqlite = new DatabaseSync('sqlite.db');
const db = drizzle({ client: sqlite });

.comment() query tagging

Append SQL comments to queries (PostgreSQL and MySQL):

db.select().from(users).comment("my_tag");
db.select().from(users).comment({ priority: 'high', category: 'analytics' });
// → select ... from "users" /*priority='high',category='analytics'*/

Note: Cannot be used with prepared statements.

See references/drivers-and-queries.md for full details.

Reference Files

| File | Contents | |---|---| | schema-validation.md | Validator packages consolidated into drizzle-orm, supported libraries, Effect Schema integration | | drivers-and-queries.md | node-sqlite driver setup, .comment() query tagging with sqlcommenter |