Drizzle <> Netlify Database

Drizzle has native support for Netlify Database connections, that intelligently selects the optimal underlying Postgres driver based on the runtime environment.

Netlify Database is a managed Postgres database. On Netlify’s platform, the same application code runs in two very different contexts:

• Serverless functions: no persistent connections, best served by HTTP-based queries
• Server mode: persistent connections via node-postgres

This adapter abstracts that decision away so consumers can write drizzle() once and get the right driver automatically.

Step 1 - Install packages

npm i drizzle-orm @netlify/database
npm i -D drizzle-kit

yarn add drizzle-orm @netlify/database
yarn add -D drizzle-kit

pnpm add drizzle-orm @netlify/database
pnpm add -D drizzle-kit

bun add drizzle-orm @netlify/database
bun add -D drizzle-kit

Step 2 - Initialize the driver and make a query

import { drizzle } from 'drizzle-orm/netlify-db';

// Connection string is set automatically by the platform
const db = drizzle();

const result = await db.execute('select 1');

import { drizzle } from 'drizzle-orm/netlify-db';

const db = drizzle(process.env.DATABASE_URL);

const result = await db.execute('select 1');

import { drizzle } from 'drizzle-orm/netlify-db';

// Explicit client — consumer controls the driver
const db = drizzle({ client: netlifyDbClient });

const result = await db.execute('select 1');

What’s next?