libSQL driver for TypeScript and JavaScript
Npm Package Weekly Downloads Trend
Cumulative GitHub Star Trend
Stat Detail
Popular Comparisons
README for @libsql/client
libSQL TypeScript
Databases for all TypeScript and JS multi-tenant apps.
Turso ยท Docs ยท Quickstart ยท SDK Reference ยท Blog & Tutorials
Looking for the Turso serverless package? Check out
@tursodatabase/serverlessโ the lightest option with zero native dependencies, and will be the driver to later support concurrent writes. Use@libsql/clientif you need a battle-tested driver today with ORM integration.
Features
- ๐ Works offline with Embedded Replicas
- ๐ Works with remote Turso databases
- โจ Works with Turso AI & Vector Search
- ๐ Supports encryption at rest
Install
npm install @libsql/client
Quickstart
The example below uses Embedded Replicas and syncs every minute from Turso.
import { createClient } from "@libsql/client";
export const turso = createClient({
url: "file:local.db",
syncUrl: process.env.TURSO_DATABASE_URL,
authToken: process.env.TURSO_AUTH_TOKEN,
syncInterval: 60000,
});
await turso.batch(
[
"CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT)",
{
sql: "INSERT INTO users(name) VALUES (?)",
args: ["Iku"],
},
],
"write",
);
await turso.execute({
sql: "SELECT * FROM users WHERE id = ?",
args: [1],
});
Examples
| Example | Description |
|---|---|
| local | Uses libsql with a local SQLite file. Creates database, inserts data, and queries. |
| remote | Connects to a remote database. Requires environment variables for URL and auth token. |
| sync | Demonstrates synchronization between local and remote databases. |
| batch | Executes multiple SQL statements in a single batch operation. |
| transactions | Shows transaction usage: starting, performing operations, and committing/rolling back. |
| memory | Uses an in-memory SQLite database for temporary storage or fast access. |
| vector | Works with vector embeddings, storing and querying for similarity search. |
| encryption | Creates and uses an encrypted SQLite database, demonstrating setup and data operations. |
| ollama | Similarity search with Ollama and Mistral. |
Documentation
Visit our official documentation.
Support
Join us on Discord to get help using this SDK. Report security issues via email.
Contributors
See the contributing guide to learn how to get involved.
