libSQL

Free plan APILinuxMacSelf-hostedWebWindows

What libSQL is

libSQL is an open-source relational database fork of SQLite maintained by Turso. It aims to keep SQLite’s file format and API compatibility while adding APIs and extensions, and it can run inside an application without a network connection. Embedded replicas let an application keep a replicated database locally. For remote access, the libSQL server accepts SQL from clients over HTTP; Docker instructions cover primary and replica server instances. The repository lists official TypeScript/JavaScript, Rust, and Go drivers, along with experimental Python and C drivers and community drivers for PHP, D, and Ring. Listed extensions include changes to ALTER TABLE, randomized ROWID, WebAssembly user-defined functions, and a virtual write-ahead-log interface. GUI options include Beekeeper Studio, Outerbase, TablePlus, Dataflare, and libSQL Studio. The project retains SQLite’s single-writer limitation. Its documentation recommends Turso Database for new projects, where new features are being developed, while libSQL remains actively maintained. The project uses the MIT license.

Who it suits

libSQL suits developers who want a SQLite-compatible database that can run embedded or serve remote SQL requests. Its maintainers describe it as an option for mission-critical workloads that need a battle-tested foundation.

What it does well

Free plan and MIT license
Can run embedded without a network connection
Embedded replicas keep a database in the app
Official TypeScript/JavaScript, Rust, and Go drivers
Docker instructions cover primary and replica servers

What to know first

Retains SQLite’s single-writer limitation
New features are being developed in Turso Database

Verdict

libSQL combines SQLite compatibility with embedded replicas, remote access, and additional extensions. Its single-writer model remains a constraint, and the maintainers point new projects toward Turso Database for new features.

Facts from libSQL's own pages

Community support: The documentation directs libSQL users to Discord to discuss its development, and the repository accepts issues and pull requests. · docs.turso.tech, 30 Sept 2026
Compatibility: libSQL aims to preserve SQLite’s file format and API while adding additional APIs. · github.com, 30 Sept 2026
Deployment: The project provides Docker instructions for launching primary and replica server instances. · github.com, 30 Sept 2026
Drivers: The repository lists official TypeScript/JavaScript, Rust, and Go drivers, plus experimental Python and C drivers and community PHP, D, and Ring drivers. · github.com, 30 Sept 2026
Embedded replicas: libSQL supports embedded replicas that replicate a database inside an application. · github.com, 30 Sept 2026
Embedded use: libSQL is designed to run inside an application process without requiring a network connection. · github.com, 30 Sept 2026
Extensions: Listed SQLite extensions include ALTER TABLE changes to column types and constraints, randomized ROWID, WebAssembly user-defined functions, and a virtual write-ahead-log interface. · github.com, 30 Sept 2026
GUI tools: The repository lists Beekeeper Studio, TablePlus, Dataflare, Outerbase, and libSQL Studio as GUI options. · github.com, 30 Sept 2026
Integrations: The repository lists GUI support through Beekeeper Studio, Outerbase, TablePlus, Dataflare, and libSQL Studio. · github.com, 30 Sept 2026
Intended use: The documentation describes libSQL as a choice for mission-critical workloads needing a battle-tested foundation today. · docs.turso.tech, 30 Sept 2026
Intended users: The maintainers say people starting new projects should consider Turso, where new features are being developed, while libSQL remains actively maintained. · github.com, 30 Sept 2026
License: The repository identifies the project license as MIT. · github.com, 30 Sept 2026
Limit: The project says libSQL inherits SQLite’s single-writer model. · github.com, 30 Sept 2026
Maker: Turso describes itself as technically based in San Francisco and globally distributed across four continents. · turso.tech, 30 Sept 2026
Maker location: Turso describes itself as technically based in San Francisco and globally distributed. · turso.tech, 30 Sept 2026
Product: libSQL is an open-source, open-contribution fork of SQLite maintained by Turso. · github.com, 30 Sept 2026
Project distinction: The maintainers describe libSQL and Turso Database as separate projects and say libSQL retains SQLite’s single-writer limitation. · github.com, 30 Sept 2026
Project focus: The documentation says new features are being developed in Turso and recommends Turso Database for new projects. · docs.turso.tech, 30 Sept 2026
Remote access: The libSQL server provides remote SQLite access, and its user guide describes clients sending SQL over HTTP to sqld instances. · github.com, 30 Sept 2026
Replication: Embedded replicas let an application keep a replicated database inside the app. · github.com, 30 Sept 2026
Security: The sqld user guide says cluster nodes communicate over gRPC with TLS and describes certificate and private-key configuration for primary and replica servers. · github.com, 30 Sept 2026
SQLite compatibility: The project says it will retain SQLite file-format support, SQLite API compatibility, and the ability to run embedded without a network connection. · github.com, 30 Sept 2026
SQLite extensions: Listed extensions include ALTER TABLE changes to column types and constraints, randomized ROWID, WebAssembly user-defined functions, and a virtual write-ahead-log interface. · github.com, 30 Sept 2026
Support: The repository links to libSQL documentation, Discord, and Turso documentation for project resources and community. · github.com, 30 Sept 2026

Where libSQL stands on Freedom251

Embedded Databases#18 of 30