メニュー
Guidelines for developing with Drizzle ORM, a lightweight type-safe TypeScript ORM with SQL-like syntax
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Convert a portable QuerySchema to/from Drizzle, Kysely, TanStack DB, db0, or raw SQL. Tree-shakeable adapters — only import what you need. Covers toDrizzle, fromTanDb, fromKysely, toKysely, toDb0, and toSql.
Build a portable QuerySchema with the aq builder. Typesafe where/orderBy/limit/offset, logical nesting (and/or/not) via callbacks, standalone newWhere/newComparisonWhere builders, and Zod/Valibot runtime validation with createQuerySchema.
| name | drizzle-orm |
| description | Guidelines for developing with Drizzle ORM, a lightweight type-safe TypeScript ORM with SQL-like syntax |
// Single insert
const newUser = await db
.insert(users)
.values({
email: "user@example.com",
name: "John Doe",
})
.returning();
// Bulk insert
await db.insert(users).values([
{ email: "user1@example.com", name: "User 1" },
{ email: "user2@example.com", name: "User 2" },
]);
// Upsert (insert or update on conflict)
await db
.insert(users)
.values({ email: "user@example.com", name: "John" })
.onConflictDoUpdate({
target: users.email,
set: { name: "John Updated" },
});