Drizzle ORM 查询教程：类型安全数据库操作指南（查询、插入、更新、删除、关系查询）

using-drizzle-queries by andrelandgraf/fullstackrecipes

86 周安装量

9 GitHub Stars

GitHub

安装命令

npx skills add https://github.com/andrelandgraf/fullstackrecipes --skill using-drizzle-queries

Node.js TypeScript 数据库

🇨🇳中文介绍

使用 Drizzle 进行开发

使用 Drizzle ORM 编写类型安全的数据库查询。涵盖查询、插入、更新、删除、关系查询以及添加新表。

实现使用 Drizzle 进行开发

使用 Drizzle ORM 编写类型安全的数据库查询。涵盖查询、插入、更新、删除、关系查询以及添加新表。

参见：

资源：Fullstack Recipes 中的 using-drizzle-queries
URL：https://fullstackrecipes.com/recipes/using-drizzle-queries

编写查询

使用 Drizzle 的查询 API 进行类型安全的数据库操作：

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";
import { eq, desc } from "drizzle-orm";

// 查询所有
const allChats = await db.select().from(chats);

// 带筛选条件的查询
const userChats = await db
  .select()
  .from(chats)
  .where(eq(chats.userId, userId))
  .orderBy(desc(chats.createdAt));

// 查询单条记录
const chat = await db
  .select()
  .from(chats)
  .where(eq(chats.id, chatId))
  .limit(1)
  .then((rows) => rows[0]);

插入数据

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";

// 插入单条记录
const [newChat] = await db
  .insert(chats)
  .values({
    userId,
    title: "New Chat",
  })
  .returning();

// 插入多条记录
await db.insert(messages).values([
  { chatId, role: "user", content: "Hello" },
  { chatId, role: "assistant", content: "Hi there!" },
]);

广告位招租

在这里展示您的产品或服务

触达数万 AI 开发者，精准高效

联系我们

🇺🇸English

Working with Drizzle

Write type-safe database queries with Drizzle ORM. Covers select, insert, update, delete, relational queries, and adding new tables.

Implement Working with Drizzle

Write type-safe database queries with Drizzle ORM. Covers select, insert, update, delete, relational queries, and adding new tables.

See:

Resource: using-drizzle-queries in Fullstack Recipes
URL: https://fullstackrecipes.com/recipes/using-drizzle-queries

Writing Queries

Use Drizzle's query API for type-safe database operations:

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";
import { eq, desc } from "drizzle-orm";

// Select all
const allChats = await db.select().from(chats);

// Select with filter
const userChats = await db
  .select()
  .from(chats)
  .where(eq(chats.userId, userId))
  .orderBy(desc(chats.createdAt));

// Select single record
const chat = await db
  .select()
  .from(chats)
  .where(eq(chats.id, chatId))
  .limit(1)
  .then((rows) => rows[0]);

Inserting Data

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";

// Insert single record
const [newChat] = await db
  .insert(chats)
  .values({
    userId,
    title: "New Chat",
  })
  .returning();

// Insert multiple records
await db.insert(messages).values([
  { chatId, role: "user", content: "Hello" },
  { chatId, role: "assistant", content: "Hi there!" },
]);

Updating Data

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";
import { eq } from "drizzle-orm";

await db
  .update(chats)
  .set({ title: "Updated Title" })
  .where(eq(chats.id, chatId));

Deleting Data

import { db } from "@/lib/db/client";
import { chats } from "@/lib/chat/schema";
import { eq } from "drizzle-orm";

await db.delete(chats).where(eq(chats.id, chatId));

Using Relational Queries

For queries with relations, use the query API:

import { db } from "@/lib/db/client";

const chatWithMessages = await db.query.chats.findFirst({
  where: eq(chats.id, chatId),
  with: {
    messages: {
      orderBy: (messages, { asc }) => [asc(messages.createdAt)],
    },
  },
});

Adding New Tables

Create the schema in the feature's library folder:

// src/lib/feature/schema.ts

import { pgTable, text, uuid, timestamp } from "drizzle-orm/pg-core";

export const items = pgTable("items", {
  id: uuid("id").primaryKey().defaultRandom(),
  name: text("name").notNull(),
  createdAt: timestamp("created_at").defaultNow().notNull(),
});

Import the schema in src/lib/db/client.ts:

import * as itemSchema from "@/lib/feature/schema";

const schema = {
  ...authSchema,
  ...chatSchema,
  ...itemSchema,
};

Generate and run migrations:

bun run db:generate

bun run db:migrate

References

Weekly Installs

Repository

andrelandgraf/f…krecipes

GitHub Stars

First Seen

Jan 20, 2026

Security Audits

Gen Agent Trust HubPass SocketPass SnykPass

Installed on

opencode65

claude-code54

gemini-cli53

cursor53

codex52

github-copilot47