libSQL

Open-source fork of SQLite that accepts external contributions and community patches. Keeps full file-format and API compatibility with SQLite while adding embedded replication, remote server access, and extensions that evolve the engine for modern workloads.

Unlike SQLite, which does not accept third-party code, libsql is designed as an open-contribution project with a clear code of conduct. Maintained by Turso, it powers both embedded and edge deployments and is used by teams building local-first apps, AI agents, and serverless backends that need SQLite compatibility with replication or remote access.

Key capabilities:

• Embedded replicas that sync a read replica inside your application
• libsql server for remote SQLite access over the network, similar to PostgreSQL or MySQL
• SQLite C API compatibility plus extensions such as ALTER TABLE for column changes and randomized ROWID
• WebAssembly user-defined functions for custom logic in queries
• Official drivers for TypeScript, Rust, and Go, with experimental Python and C bindings

Use cases: embedded and edge databases where a single SQLite file is too limiting, local-first apps that need sync across devices, AI and agent workloads that benefit from per-agent databases, and applications migrating from SQLite that require replication or cloud deployment options.