whatisgithub

What is kysely-sqlite-tools?

subframe7536/kysely-sqlite-tools — explained in plain English

Analysis updated 2026-08-04 · repo last pushed 2026-07-21

104TypeScriptAudience · developerComplexity · 3/5ActiveSetup · moderate

In one sentence

A set of adapters that let you use SQLite with Kysely, a TypeScript query builder, across browsers, desktop apps, and server-side workers.

Mindmap

mindmap
  root((repo))
    What it does
      Connects Kysely to SQLite
      Multiple environment support
      Worker thread options
    Tech stack
      TypeScript
      Kysely query builder
      WebAssembly SQLite
    Use cases
      Browser local storage
      Tauri desktop apps
      Bun native SQLite
    Audience
      Kysely developers
      Cross-platform app builders
    Architecture
      Monorepo structure
      Base adapter pattern

Code map

Detail Auto

An interactive map of this repo's files and how they connect — its source is parsed live in your browser. Click Visualize to build it.

filefunction / class

What do people build with it?

USE CASE 1

Build a browser-based app that stores data locally using WebAssembly SQLite.

USE CASE 2

Create a Tauri desktop app that queries SQLite through Tauri's built-in SQL plugin.

USE CASE 3

Run SQLite in a web worker with OPFS or IndexedDB storage to avoid blocking the main thread.

USE CASE 4

Use Bun's native SQLite with Kysely in a server-side project.

What is it built with?

TypeScriptKyselySQLiteWebAssemblyTauriBun

How does it compare?

subframe7536/kysely-sqlite-toolspfwjrfp5hh-byte/workmeshworkbzw/ai-office-react
Stars104104104
LanguageTypeScriptTypeScriptTypeScript
Last pushed2026-07-21
MaintenanceActive
Setup difficultymoderatehardeasy
Complexity3/53/52/5
Audiencedeveloperpm founderdeveloper

Figures from each repo's GitHub metadata at analysis time.

How do you get it running?

Difficulty · moderate Time to first run · 30min

You need to already be using Kysely and pick the right adapter package for your target environment from the monorepo.

The license terms are not mentioned in the explanation, so what this project allows is unknown.

So what is it?

Kysely SQLite Utils is a collection of adapters that lets developers use SQLite with Kysely, a TypeScript query builder, across a wide range of JavaScript environments. The user-facing benefit is straightforward: if you're already writing database queries with Kysely, these packages let you run those same queries against SQLite whether your code is running in a browser, a desktop app, or a server-side worker thread. At a high level, the project provides a generic base adapter and then builds several specialized versions on top of it. The base adapter handles common SQLite interactions, and the specialized versions connect Kysely to different SQLite implementations, for instance, WebAssembly builds that run directly in the browser, or adapters that tap into Tauri's official SQL plugin for desktop applications. Some versions run SQLite in a worker thread, which keeps database operations from blocking the main thread of an application. The audience here is developers who are already working with Kysely and need SQLite support in environments beyond a standard Node.js server. Concrete examples include someone building a browser-based app that stores data locally using WebAssembly SQLite, or a developer packaging a desktop app with Tauri who wants to use Tauri's built-in SQL plugin. There are also adapters for Bun's native SQLite and for running SQLite in web workers with storage through browser-specific technologies like OPFS or IndexedDB. The project is organized as a monorepo, meaning multiple related packages live in one repository and share a common build and test setup. The README notes that some older utilities have been deprecated or moved to separate repositories, so the current focus is on the dialect packages themselves. The README doesn't go into much detail on performance characteristics or specific tradeoffs between the different SQLite backends.

Copy-paste prompts

Prompt 1
I'm using Kysely in a browser app and want to store data locally with WebAssembly SQLite. Show me how to set up the kysely-sqlite-tools adapter for this.
Prompt 2
I have a Tauri desktop app and want to use Kysely with Tauri's SQL plugin. Help me configure the right dialect adapter from kysely-sqlite-tools.
Prompt 3
I want to run SQLite in a web worker using OPFS storage with Kysely queries. Walk me through setting up the worker-thread adapter from kysely-sqlite-tools.
Prompt 4
I'm building a Bun project and want to use Kysely with Bun's native SQLite. Show me how to wire up the Bun adapter from this monorepo.

Frequently asked questions

What is kysely-sqlite-tools?

A set of adapters that let you use SQLite with Kysely, a TypeScript query builder, across browsers, desktop apps, and server-side workers.

What language is kysely-sqlite-tools written in?

Mainly TypeScript. The stack also includes TypeScript, Kysely, SQLite.

Is kysely-sqlite-tools actively maintained?

Active — commit in last 30 days (last push 2026-07-21).

What license does kysely-sqlite-tools use?

The license terms are not mentioned in the explanation, so what this project allows is unknown.

How hard is kysely-sqlite-tools to set up?

Setup difficulty is rated moderate, with roughly 30min to a first successful run.

Who is kysely-sqlite-tools for?

Mainly developer.

Open on GitHub → Ask about another repo

This repo across BitVibe Labs

Verify against the repo before relying on details.