Drizzle Queries

Write type-safe Postgres queries with Drizzle ORM.

Prerequisites

Complete these setup recipes first:

• Neon + Drizzle Setup

Selecting

Import db from @/lib/db/client and operators from drizzle-orm. For a single row, .limit(1) then take rows[0].

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