@lucia-auth/adapter-postgresql

PostgreSQL adapter for Lucia.

Documentation

Lucia documentation

Changelog

Supported drivers

• node-postgres (pg)
• Postgres.js (postgres)
• Neon HTTP serverless driver

Installation

npm install @lucia-auth/adapter-postgresql
pnpm add @lucia-auth/adapter-postgresql
yarn add @lucia-auth/adapter-postgresql

Testing

node-postgres

Set PostgreSQL database connection url in .env:

POSTGRES_DATABASE_URL="postgresql://localhost/lucia"

pnpm test.node-postgres

Postgres.js

Set PostgreSQL database connection url in .env:

POSTGRES_DATABASE_URL="postgresql://localhost/lucia"

pnpm test.postgresjs

Neon HTTP

Set the connection URL in .env. Do not enable pooling.

NEON_CONNECTION_URL=""

pnpm test.neon-http