# Connect to Postgres local vs Vercel Postgres with Kysely

> Learn how to set up Kysely with a local Postgres database using pg Pool, then switch to Vercel Postgres with the @vercel/postgres-kysely package.

Author: [Flavio Copes](https://flaviocopes.com/about/) | Published: 2023-11-10 | Topics: [Database](https://flaviocopes.com/tags/database/) | Canonical: https://flaviocopes.com/connect-to-postgres-local-vs-vercel-postgres-with-kysely/

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:

```javascript
import {
  Kysely,
  PostgresDialect,
} from 'kysely'

import pg from 'pg'

const POSTGRES_URL = //...from env

const dialect = new PostgresDialect({
  pool: new pg.Pool({
    connectionString:
      POSTGRES_URL
    max: 10,
  }),
})

export const db = new Kysely({
  dialect
})
```

With Vercel Postgres, I used:

```javascript
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`