@coderbuzz/sql

Runtime-agnostic TypeScript SQL toolkit for Bun, Node.js, and Deno. Schema-driven table definitions, fluent query builders, dialect-aware SQL compilation, engine adapters, safe raw SQL, transactions, streaming, prepared queries, high-throughput batch inserts, and schema migration utilities.

Installation

bun add @coderbuzz/sql
# or
npm install @coderbuzz/sql

Install the driver for your database (see Supported Databases):

bun add pg           # PostgreSQL
bun add mysql2       # MySQL / MariaDB
bun add mssql        # SQL Server
bun add better-sqlite3  # SQLite (Node.js)
bun add oracledb     # Oracle
bun add snowflake-sdk   # Snowflake
bun add @databricks/sql # Databricks

SQLite on Bun uses bun:sqlite (built-in, no extra driver needed). SQLite on Deno uses @db/sqlite.

Quick Start

import { sqlite } from "@coderbuzz/sql/sqlite";

const db = sqlite.connect({ path: ":memory:" });

const users = sqlite.table("users", {
  id: sqlite.integer().primaryKey(),
  email: sqlite.text().notNull().unique(),
  name: sqlite.text().notNull(),
  active: sqlite.boolean().default(true),
  created_at: sqlite.datetime().defaultNow(),
});

await db.migrate(users);

const rows = await users.from(db)
  .fields("id", "email", "name")
  .where(sqlite.eq("active", true))
  .order_by("id DESC")
  .limit(10)
  .execute();

db.close();

Documentation

Full API reference, examples, and migration guide: DOCS.md

License

MIT © 2026 Indra Gunawan