SQLite Setup in Drizzle ORM

From the Drizzle ORM cheat sheet · Database Setup · verified Jul 2026

Connect to SQLite using better-sqlite3 or libsql drivers.

typescript

import { drizzle } from 'drizzle-orm/better-sqlite3';
import * as schema from './schema';

const db = drizzle('./sqlite.db', { schema });

💡 Install: npm i drizzle-orm better-sqlite3

⚡ SQLite is great for local dev and embedded apps

📌 Turso uses libSQL driver for edge deployments

🟢 SQLite uses sqliteTable instead of pgTable

setupsqliteconnectionturso

More Drizzle ORM tasks