Skip to content

Connect to Postgres local vs Vercel Postgres with Kysely

New Courses Coming Soon

Join the waiting lists

I switched a codebase from local Postgres database to Vercel Postgres, which comes with its own optimized package.

I used this to set up Kysely:

import {
} from 'kysely'

import pg from 'pg'

const POSTGRES_URL = //...from env

const dialect = new PostgresDialect({
  pool: new pg.Pool({
    max: 10,

export const db = new Kysely({

With Vercel Postgres, I used:

import { createKysely } from '@vercel/postgres-kysely'

const POSTGRES_URL = //...from env

export const db = createKysely({
  connectionString: POSTGRES_URL

The db now already know how to look up the environment variable POSTGRES_URL

→ Read my SQL Tutorial on The Valley of Code

Here is how can I help you: