litestream

name	litestream
description	SQLite disaster recovery and streaming replication to cloud storage (S3, GCS, Azure, SFTP, NATS). Use this skill for configuring Litestream, deploying to cloud platforms, troubleshooting WAL replication issues, implementing point-in-time recovery, and setting up VFS read replicas.
version	0.5.5

Litestream

Litestream is a disaster recovery tool for SQLite that runs as a background process, continuously replicating database changes to cloud storage. It monitors the SQLite Write-Ahead Log (WAL), converts changes to immutable LTX files, and uploads them to your chosen storage backend.

Key Concepts

• WAL Monitoring: Watches SQLite Write-Ahead Log for changes at configurable intervals (default 1s)
• LTX Files: Immutable files containing database page changes, never modified after creation
• Level-Based Compaction: Multi-level system (L0-L9) that merges LTX files to reduce storage overhead
• Point-in-Time Recovery: Restore to any transaction using TXID or timestamp
• VFS Support: Read replicas directly from cloud storage without local database copy
• MCP Server: AI tool integration for automated database management

Quick Start

Installation

# macOS
brew install litestream

# Linux (Debian/Ubuntu)
wget https://github.com/benbjohnson/litestream/releases/download/v0.5.5/litestream-v0.5.5-linux-amd64.deb
sudo dpkg -i litestream-v0.5.5-linux-amd64.deb

# Docker
docker pull litestream/litestream:0.5