SQL

Choose a database

See Databases to compare engines and connection paths, with links directly to each database’s setup guide.

Choose a client

Client	Guides
Effect SQL	Postgres · MySQL · D1 · libSQL · Durable Objects
Drizzle	Postgres · MySQL · D1 · libSQL · Durable Objects
Prisma ORM v8	Contracts · Postgres · Migrations

Prisma ORM v8 requires PostgreSQL 17+ and is separate from the Prisma hosting provider.

Find an integration

Integration	Guide
Lambda + Aurora PostgreSQL + Drizzle	AWS
Lambda + Aurora DSQL + Drizzle	AWS
Workers + Neon or PlanetScale + Drizzle	Cloudflare
Workers + D1 + Drizzle	Cloudflare
Workers + Turso + Drizzle	Turso
Durable Objects + SQLite	Cloudflare
Fly Service + Postgres + Drizzle	Fly
Hetzner Service + external Postgres + Drizzle	Hetzner
Prisma Compute + Postgres + Drizzle	Prisma
Railway Service + Postgres + Drizzle	Railway
Railway Service + MySQL + Drizzle	Railway
Workers + Neon + Prisma ORM	Cloudflare

See runnable examples for complete projects.

Already have a database?

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

const