This tool defines architecture and coding rules for handling SQLite WAL operations, LTX files, and storage backends in Litestream.

Install

mkdir -p .claude/skills/litestream && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/9023" && unzip -o skill.zip -d .claude/skills/litestream && rm skill.zip

Installs to .claude/skills/litestream

Activation

This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.

Expert knowledge for contributing to Litestream, a standalone disaster recovery tool for SQLite. Provides architectural understanding, code patterns, critical rules, and debugging procedures for WAL monitoring, LTX replication format, storage backend implementation, multi-level compaction, and SQLite page management. Use when working with Litestream source code, writing storage backends, debugging replication issues, implementing compaction logic, or handling SQLite WAL operations.
486 chars · catalog description✓ has a “when” triggerlonger than Claude Code's old 250-char listing cap (fine on current versions)
Advanced

Key capabilities

  • →Monitor SQLite WAL
  • →Convert changes to immutable LTX files
  • →Replicate to cloud storage
  • →Perform multi-level compaction
  • →Manage SQLite page locks

How it works

The agent monitors the SQLite WAL, converts changes into immutable LTX files, and replicates them to cloud storage using a defined interface.

Inputs & outputs

You give it
SQLite WAL changes
You get back
Replicated LTX files

When to use litestream

  • →Debugging replication issues
  • →Implementing storage backends
  • →Contributing to Litestream source code

About litestream

Provides architecture details and coding rules for the Litestream project. It handles complex SQLite WAL operations, LTX file formats, and storage backend implementation.

Expert knowledge for contributing to Litestream, a standalone disaster recovery tool for SQLite. Provides architectural understanding, code patterns, critical rules, and debugging procedures for WAL monitoring, LTX replication format, storage backend implementation, multi-level compaction, and SQLite page management. Use when working with Litestream source code, writing storage backends, debugging replication issues, implementing compaction logic, or handling SQLite WAL operations.

When not to use it

  • →Modifying existing LTX files
  • →Writing directly to final storage paths

Prerequisites

Go toolchainpre-commit

Limitations

  • →Single replica per database
  • →Requires atomic file operations

How it compares

It provides expert architectural rules and invariants for disaster recovery that generic SQLite backup tools lack.

Compared to similar skills

litestream side by side with the closest alternatives in the catalog.

SkillInstallsUpdatedSafetyDifficulty
litestream (this skill)09moReviewAdvanced
run-tests18moReviewIntermediate
dbx-regenerate110moReviewIntermediate
advanced-lokstra-validate-consistency09moReviewAdvanced

Try saying

Example prompts that trigger this skill in your AI assistant.

You might also like

run-tests

pgschema

Run pgschema automated tests (go test) to validate diff logic, plan generation, and dump functionality using test fixtures

13

dbx-regenerate

storj

Regenerate DBX code after making changes to .dbx schema files. Runs code generation, shows diff summary, validates compilation, and reports any errors.

12

advanced-lokstra-validate-consistency

primadi

Validate application consistency - circular dependencies, schema validation, config checks, annotation validation, and service registration. Use after all code is implemented to identify issues before deployment.

00

passion-dev

awalvie

Passion climbing training app development. Use for: adding handlers, modifying DB models, creating templates, understanding project architecture, running/testing the app, YAML import features.

00

startup

matlockx

Use this skill for Go service bootstrapping with flachnetz/startup library. Covers options composition, auto-initialization, Postgres, Kafka, HTTP server, tracing, and environment patterns.

00

opentelemetry-instrumentation-extension

docker

Extend OpenTelemetry instrumentation when new functionality is added to the MCP Gateway. Use when (1) new operations/functions are added, (2) reviewing code for missing instrumentation, (3) user requests otel/telemetry additions, or (4) working with state-changing operations. Analyzes git diff, suggests instrumentation points following project standards in docs/telemetry/README.md, implements with approval, writes tests, updates documentation, and verifies with debug logging and docker logs.

326

Search skills

Search the agent skills registry