Drizzle <> Prisma Postgres

This guide assumes familiarity with:

Database connection basics with Drizzle
Prisma Postgres serverless database - website
Prisma Postgres direct connections - docs
Drizzle PostgreSQL drivers - docs

Prisma Postgres is a serverless database built on unikernels. It has a large free tier, operation-based pricing and no cold starts.

You can connect to it using either the node-postgres or postgres.js drivers for PostgreSQL.

Prisma Postgres also has a serverless driver that will be supported with Drizzle ORM in the future.

Step 1 - Install packages

node-postgres (pg)

postgres.js

npm

yarn

pnpm

bun

npm i drizzle-orm pg npm i -D drizzle-kit

yarn add drizzle-orm pg yarn add -D drizzle-kit

pnpm add drizzle-orm pg pnpm add -D drizzle-kit

bun add drizzle-orm pg bun add -D drizzle-kit

npm

yarn

pnpm

bun

npm i drizzle-orm postres npm i -D drizzle-kit

yarn add drizzle-orm postres yarn add -D drizzle-kit

pnpm add drizzle-orm postres pnpm add -D drizzle-kit

bun add drizzle-orm postres bun add -D drizzle-kit

Step 2 - Initialize the driver and make a query

node-postgres (pg)

postgres.js

// Make sure to install the 'pg' package  import { drizzle } from "drizzle-orm/node-postgres"; import { Pool } from "pg";  const pool = new Pool({  connectionString: process.env.DATABASE_URL, }); const db = drizzle({ client: pool });   const result = await db.execute('select 1');

// Make sure to install the 'postgres' package import { drizzle } from 'drizzle-orm/postgres-js'; import postgres from 'postgres';  const queryClient = postgres(process.env.DATABASE_URL); const db = drizzle({ client: queryClient });  const result = await db.execute('select 1');

What’s next?

Manage schema

Drizzle Schema PostgreSQL data types Indexes and Constraints Database Views Database Schemas Sequences Extensions

Query data

Relational Queries Select Insert Update Delete Filters Joins sql`` operator