Drizzle ORM (2)

Last updated Oct 1, 2026 is a lightweight TypeScript ORM with a focus on type safety. This example demonstrates how to use Drizzle ORM with PostgreSQL via Cloudflare Hyperdrive in a Workers application.

Prerequisites

1. Install Drizzle

Install the Drizzle ORM and its dependencies such as the node-postgres ↗︎ (pg) driver:

npm i drizzle-orm pg dotenv
npm i -D drizzle-kit tsx @types/pg @types/node

Add the required Node.js compatibility flags and Hyperdrive binding to your wrangler.jsonc file:

{
    // required for database drivers to function
    "compatibility_flags": [
        "nodejs_compat"
    ],
    // Set this to today's date
    "compatibility_date": "2026-10-27",
    "hyperdrive": [
        {
            "binding": "HYPERDRIVE",
            "id": "<your-hyperdrive-id-here>"
        }
    ]
}

compatibility_flags = [ "nodejs_compat" ]
# Set this to today's date
compatibility_date = "2026-10-27"

[[hyperdrive]]
binding = "HYPERDRIVE"
id = "<your-hyperdrive-id-here>"

2. Configure Drizzle

2.1. Define a schema

With Drizzle ORM, we define the schema in TypeScript rather than writing raw SQL.

  1. Create a folder /db/ in /src/.
  2. Create a schema.ts file.
  3. In schema.ts, define a users table as shown below.

src/db/schema.tsts

```ts // src/db/schema.ts import { pgTable, serial, varchar, timestamp } from "drizzle-orm/pg-core";

export const users = pgTable("users", { id: serial("id").primaryKey(), name: varchar("name", { length: 255 }).notNull(), email: varchar("email", { length: 255 }).notNull().unique(), createdAt: timestamp("created_at").defaultNow(), }); ```

2.2. Connect Drizzle ORM to the database with Hyperdrive

Use your Hyperdrive configuration for your database when using the Drizzle ORM.

Populate your index.ts file as shown below.

src/index.tsts

// src/index.ts
import { Client } from "pg";
import { drizzle } from "drizzle-orm/node-postgres";
import { users } from "./db/schema";

export interface Env {
    HYPERDRIVE: Hyperdrive;
}

export default {
    async fetch(request, env, ctx): Promise<Response> {
        // Create a new client instance for each request.
        const client = new Client({
            connectionString: env.HYPERDRIVE.connectionString,
        });

        // Connect to the database
        await client.connect();

        // Create the Drizzle client with the node-postgres connection
        const db = drizzle(client);

        // Sample query to get all users
        const allUsers = await db.select().from(users);

        return Response.json(allUsers);
    },
} satisfies ExportedHandler<Env>;

Note

Use node-postgres ↗︎ with Drizzle ORM when connecting through Hyperdrive.

Known issue with Postgres.js

Pairing Drizzle ORM with the Postgres.js driver over Hyperdrive is not currently supported. Switch your driver to node-postgres ↗︎ (pg), the recommended driver for Drizzle ORM with Hyperdrive.

2.3. Configure Drizzle-Kit for migrations (optional)

Note

You need to set up the tables in your database so that Drizzle ORM can make queries that work.

If you have already set it up (for example, if another user has applied the schema to your database), or if you are starting to use Drizzle ORM and the schema matches what already exists in your database, then you do not need to run the migration.

You can generate and run SQL migrations on your database based on your schema using Drizzle Kit CLI. Refer to Drizzle ORM docs ↗︎ for additional guidance.

  1. Create a .env file the root folder of your project, and add your database connection string. The Drizzle Kit CLI will use this connection string to create and apply the migrations.

.envtoml

toml # .env # Replace with your direct database connection string DATABASE_URL='postgres://user:password@db-host.cloud/database-name'

  1. Create a drizzle.config.ts file in the root folder of your project to configure Drizzle Kit and add the following content:

drizzle.config.tsts

ts // drizzle.config.ts import "dotenv/config"; import { defineConfig } from "drizzle-kit"; export default defineConfig({ out: "./drizzle", schema: "./src/db/schema.ts", dialect: "postgresql", dbCredentials: { url: process.env.DATABASE_URL!, }, });

  1. Generate the migration file for your database according to your schema files and apply the migrations to your database.

Run the following two commands:

bash npx drizzle-kit generate

```bash No config path provided, using default 'drizzle.config.ts' Reading config file 'drizzle.config.ts' 1 tables users 4 columns 0 indexes 0 fks

[✓] Your SQL migration file ➜ drizzle/0000_mysterious_queen_noir.sql 🚀 ```

bash npx drizzle-kit migrate

bash No config path provided, using default 'drizzle.config.ts' Reading config file 'drizzle.config.ts' Using 'postgres' driver for database querying

3. Deploy your Worker

Deploy your Worker.

npx wrangler deploy

Next steps

Was this helpful?

YesNo

On this page

Drizzle ORM (2) - 图1Docs

{"@context":"https://schema.org","@type":"TechArticle","@id":"https://developers.cloudflare.com/hyperdrive/examples/connect-to-postgres/postgres-drivers-and-libraries/drizzle-orm/#page","headline":"Drizzle ORM","description":"Use Drizzle ORM with Hyperdrive to query PostgreSQL databases from Cloudflare Workers.","url":"https://developers.cloudflare.com/hyperdrive/examples/connect-to-postgres/postgres-drivers-and-libraries/drizzle-orm/","inLanguage":"en","image":"https://developers.cloudflare.com/hyperdrive/examples/connect-to-postgres/postgres-drivers-and-libraries/drizzle-orm/og.png?v=265a667aefedf292","dateModified":"2026-10-01","publisher":{"@type":"Organization","name":"Cloudflare","description":"One platform for your apps, agents, and workforce. Build, secure, and scale without managing infrastructure","url":"https://www.cloudflare.com/","sameAs":["https://github.com/cloudflare","https://www.linkedin.com/company/cloudflare","https://x.com/cloudflare"],"logo":{"@type":"ImageObject","url":"https://developers.cloudflare.com/logo.svg"},"address":{"@type":"PostalAddress","streetAddress":"101 Townsend St","addressLocality":"San Francisco","addressRegion":"CA","postalCode":"94107","addressCountry":"US"},"contactPoint":[{"@type":"ContactPoint","contactType":"Customer Support","url":"https://support.cloudflare.com/","availableLanguage":["English"]},{"@type":"ContactPoint","contactType":"Sales","url":"https://www.cloudflare.com/contact/","availableLanguage":["English"]}]},"isPartOf":{"@type":"WebSite","@id":"https://developers.cloudflare.com/#website","name":"Cloudflare Docs","url":"https://developers.cloudflare.com/"}}

description: Use node-postgres (pg) with Hyperdrive to query PostgreSQL databases from Cloudflare Workers. title: node-postgres (pg) image: https://developers.cloudflare.com/hyperdrive/examples/connect-to-postgres/postgres-drivers-and-libraries/node-postgres/og.png?v=93326be9d68f0fd9

Skip to content

Documentation Index
Fetch the complete documentation index at: https://developers.cloudflare.com/hyperdrive/llms.txt
Use this file to discover all available pages before exploring further.