Connect your framework

Works with the usual suspects

CapyDB is plain Postgres, so anything that speaks Postgres works. There are dedicated guides for:

• Next.js + Prisma
• Drizzle
• Node: pg and postgres.js
• Django
• Rails
• Laravel
• Go: pgx
• SQLAlchemy

psql, TablePlus, DataGrip, pgAdmin, and other SQL clients work with the direct URL as-is.

The one rule

Pooled URL for app traffic, direct URL for migrations. Every guide below is a variation of that sentence.

Recommended pattern

Store both URLs in environment variables and keep the rest of your framework configuration boring. That is the point.

DATABASE_URL=postgres://user:password@host:6432/db?sslmode=require       # pooled
DATABASE_DIRECT_URL=postgres://user:password@host:5432/db?sslmode=require # direct

The CapyDB CLI detects common framework profiles and writes the local env file for you, including framework-specific aliases like DIRECT_URL for Prisma:

capydb login
capydb link --project my-app