Postgres

SQL.Postgres provides tagged-template queries over a Postgres connection. Queries are Effects with typed SqlError failures, interruption, and tracing.

Install @alchemy.run/sql and the Effect Postgres driver:

pnpm

pnpm add @alchemy.run/sql@latest @effect/sql-pg

bun

bun add @alchemy.run/sql@latest @effect/sql-pg

npm

npm install @alchemy.run/sql@latest @effect/sql-pg

yarn

yarn add @alchemy.run/sql@latest @effect/sql-pg

Connect

import * as SQL from "@alchemy.run/sql/Postgres";