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