bun:sqlite in Bun

From the Bun cheat sheet · SQLite & Database · verified Jul 2026

bun:sqlite

Use the built-in SQLite database for fast local storage

typescript

import { Database } from "bun:sqlite";

const db = new Database("app.db");

db.exec(`CREATE TABLE IF NOT EXISTS users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  email TEXT UNIQUE
)`);

const insert = db.prepare("INSERT INTO users (name, email) VALUES (?, ?)");
insert.run("John", "john@test.com");

const users = db.query("SELECT * FROM users").all();

💡 bun:sqlite is built into Bun — no npm install needed, 3-6x faster than better-sqlite3

⚡ Use db.transaction() for batch inserts — wraps everything in a single atomic operation

📌 Always use prepared statements with ? or $name parameters to prevent SQL injection

🟢 Enable WAL mode for better performance with concurrent reads and writes

sqlitedatabasesql

Back to the full Bun cheat sheet