Built-in Adapters

AuthHero ships with several adapter implementations for different databases and platforms.

Drizzle (SQL) — Recommended

The primary SQL adapter, built on Drizzle ORM:

• SQLite / Cloudflare D1 (primary targets), PostgreSQL, MySQL
• Schema-first approach with pre-generated migrations shipped in the package
• Used by all create-authhero templates

Drizzle adapter details →

Kysely (SQL)

A SQL adapter supporting any database Kysely supports, maintained for existing deployments (new projects should prefer Drizzle):

• PostgreSQL, MySQL, SQLite, Cloudflare D1, Turso
• Type-safe query builder
• ~39 entity modules covering all AuthHero entities

import { createKyselyAdapters } from "@authhero/kysely-adapter";
const adapters = createKyselyAdapters(kyselyInstance);

Kysely adapter details →

AWS

Optimized for AWS Lambda deployments:

• DynamoDB for session and code storage
• RDS/Aurora for relational data
• API Gateway integration

AWS adapter details →

Cloudflare

Optimized for Cloudflare Workers:

• D1 for relational data
• KV for caching
• R2 for asset storage
• Durable Objects for rate limiting
• Custom domain support

Cloudflare adapter details →