Configuring SQLite Locally and Turso in Production

9/5/2026
9 views

Dual Database Architecture

This platform leverages @libsql/client to provide the same database API across both local development and production.

Local Configuration

In your .env file:

DATABASE_URL="file:local.db"
DATABASE_AUTH_TOKEN=""

Production Configuration

On Vercel:

DATABASE_URL="libsql://your-database.turso.io"
DATABASE_AUTH_TOKEN="your-turso-token"

Both use the exact same SQLite dialect and Drizzle schema migrations.