libSQL / SQLite

Embedded SQL Available Free tier

SQLite, served over the network

libSQL is an open-source fork of SQLite with a server mode. Keep SQLite's simplicity and file format, query it over HTTP from anywhere, and get continuous backups with point-in-time restore.

Edge and serverless apps
Per-tenant databases
Prototypes that outgrow a file

Create libSQL Pricing Docs

libsql · libsql-7f3k.us-east.databasezy.com

Sample

→ SELECT slug, title, views
  FROM pages
  ORDER BY views DESC
  LIMIT 3;

Sample result of the libSQL / SQLite query above
slug	title	views
pricing	Pricing	18,204
docs-quickstart	Quickstart	9,310
changelog	Changelog	4,127

3 rows · 2.1 ms Illustrative data and timing

Features

libSQL on Databasezy

SQLite you already know

Same SQL dialect and file format; import an existing .sqlite or .db file directly.
HTTP and Hrana

Query from serverless and edge runtimes over HTTPS with the libSQL client SDKs.
Point-in-time recovery

Bottomless replication copies the WAL to object storage continuously.
Scales to zero

Idle free instances sleep and wake on the next request.

Quick start

Connect to libSQL

Hosts, ports and the CA bundle come from the portal or the CLI after you create an instance. Credentials are shown once and never stored by our control plane.

From the CLI

1. Create the instance

zb instances create --engine libsql --name libsql-7f3k --wait

2. Download the CA bundle

zb ca > databasezy-ca.pem

3. Print the endpoint

zb connect libsql-7f3k --print

At a glance

Category: Embedded SQL
Versions: 0.24
Wire protocol: http · port 443
Runtime: Single-node adapter (ghcr.io/tursodatabase/libsql-server)
Backup: SQLite backup-API snapshot + WAL file to object storage
Pause: Scale to zero
Free tier: Yes
Licence: MIT

Connection strings and drivers

libSQL URL

libsql://libsql-7f3k.us-east.databasezy.com?authToken=<token>

Endpoint

https://libsql-7f3k.us-east.databasezy.com  (TLS; user app + password)

HTTP

curl -H "Authorization: Bearer <token>" https://libsql-7f3k.us-east.databasezy.com/v2/pipeline -d '{"requests":[{"type":"execute","stmt":{"sql":"SELECT 1"}},{"type":"close"}]}'

TypeScript (@libsql/client)

import { createClient } from "@libsql/client";

const db = createClient({
  url: "libsql://libsql-7f3k.us-east.databasezy.com",
  authToken: process.env.LIBSQL_TOKEN,
});
const rs = await db.execute("SELECT 1");

Deployment

Choose where it runs

Placement is chosen per database, so a regulated workload and a side project can live in the same organisation.

Standard hosting

Shared cells with namespace isolation, default-deny network policy and an IP allow-list. Available from the free plan up.
- Usage-based compute, billed per running hour
- Spend cap to stop surprises
Secure hosting (HIPAA)

This database runs on dedicated nodes in a separate HIPAA cell, under a signed Business Associate Agreement. Available on Team and Enterprise.
- $0.10 per instance-hour on top of compute
- How secure hosting works
From the CLI or API

Script instances in CI with the zb CLI or the REST API. Pick the placement per instance.
secure placement
```
zb instances create --engine libsql --placement secure --wait
```

Plans

libSQL on each plan

Usage-based pricing with a spend cap: you pay a plan fee plus what your instances use.

Free tier

Yes. One f0 instance with a shared vCPU (bursts to 1), 512 MiB of memory and a 500 MB database, no card required. It sleeps after 15 minutes idle and wakes on connect.

Sizes

From s0 (0.25 vCPU, 1 GiB) at $10/mo up to xl32 (32 vCPU, 128 GiB). Resize without changing the connection string.

All sizes and prices

Backups

SQLite backup-API snapshot + WAL file to object storage. Snapshots only: point-in-time recovery is not available for this engine.

Migrate

Migrate to libSQL from

Copy a database in with a connection string, a file upload or the CLI. Preflight checks the source first and verification compares the copy.

Documentation

libSQL docs

libSQL questions

Which libSQL versions can I run?

0.24 today. Minor and patch updates are applied in your maintenance window after a pre-change backup.

Which extensions, modules or plugins are available?

SQLite's built-in features, including the JSON functions, are available. Loading your own run-time extensions is not supported on the hosted server.

How are backups handled?

Backups use SQLite backup-API snapshot + WAL file to object storage. Paid plans run scheduled backups (Solo: daily, 7-day retention; Team: daily, 14-day retention); the free plan keeps one manual snapshot. libSQL / SQLite does not support point-in-time recovery; you restore from the most recent snapshot into a new instance.

Is the connection encrypted?

Always. The gateway terminates TLS (1.3 where your client supports it, 1.2 at minimum) and re-encrypts traffic to the database. Plain-text connections are refused. Verify the server with our CA bundle from the portal or zb ca, and restrict access further with the IP allow-list included on every plan.

Can I pause it when I'm not using it?

Yes. Free instances sleep after 15 minutes without connections and wake on the next one; after 7 idle days they are archived with the disk kept. On paid plans you pause on demand or on a schedule. A paused instance bills storage and backups but no compute, and wakes in 10 to 40 seconds.

What are the limits?

The free plan runs one f0 instance with a shared vCPU (bursts to 1), 512 MiB of memory, 20 connections and a 500 MB database. Paid sizes run from s0 (0.25 vCPU, 1 GiB, 60 connections, $10/mo) to xl32 (32 vCPU, 128 GiB, 5,000 connections), with up to 16 TB of disk.

What you get on each plan

Plan features as they apply to libSQL / SQLite.

libSQL / SQLite features by plan
Feature	Free	Solo	Team	Enterprise
libSQL on this plan	Yes	Yes	Yes	Yes
Plan fee	$0/mo	$25/mo	$599/mo	Custom
Largest size	f0	xl32	xl32	xl32
Included per instance	500 MB	8 GB	8 GB	Negotiated
Max disk per instance	1 GB	1 TB	16 TB	16 TB
Scheduled backups	1 manual snapshot	Daily, 7-day retention	Daily, 14-day retention	Hourly, 35-day retention · cross-region copy · immutable
Point-in-time recovery	Not available for this engine	Not available for this engine	Not available for this engine	Not available for this engine
Pause	Sleeps after 15 min idle, wakes on connect	On demand or on a schedule	On demand or on a schedule	On demand or on a schedule
Secure hosting (HIPAA)	—	—	Available with a BAA	Available with a BAA
Support	Community	Email	Priority	24x7 dedicated
Uptime SLA	—	—	99.9%	99.95%

Start with libSQL today

The free plan needs no card. Upgrade when you need more, and keep the same endpoint.

Create libSQL See pricing

libSQL / SQLite

Good for

Sample query

libSQL on Databasezy

SQLite you already know

HTTP and Hrana

Point-in-time recovery

Scales to zero