@coderbuzz/sql

The un-opinionated SQL toolkit for TypeScript. Schema-driven, multi-dialect, runtime agnostic — no ORM lock-in.

8 databases — SQLite, PostgreSQL, MySQL, MSSQL, ClickHouse, Oracle, Snowflake, Databricks. One API. Full type safety.

Why @coderbuzz/sql?

• 8 dialects vs Drizzle/Kysely's 5–6 — includes ClickHouse, Snowflake, Databricks
• No ORM magic — you write SQL with type-safe builders, tagged templates, and full dialect awareness
• Built-in batcher — debounce, timeout, backpressure for high-throughput inserts
• Schema migration utilities — introspect live DBs, diff schemas, generate ALTER TABLE — no CLI
• Middleware pipeline — db.use() for logging, tracing, safety guards
• <30 KB gzip — tree-shakeable, zero runtime overhead vs hand-written SQL

Installation

npm install @coderbuzz/sql

Plus a driver for your database (pg, mysql2, mssql, better-sqlite3, oracledb, snowflake-sdk, @databricks/sql). SQLite on Bun is built-in.

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(),
});

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, dialect guides, and migration utilities: DOCS.md

License

MIT © 2026 Indra Gunawan