The Hoody SQLite service provides a unified data layer that combines a fully featured SQL engine with a key-value store, both backed by the same hardened SQLite runtime. Use these endpoints to execute SQL transactions, manage KV data, and observe service health.

Available sub-pages

SQL Operations

Execute SQL transactions, create databases, and run queries against the SQLite engine.

Open SQL Operations →

Key-Value Store

Overview of the KV Store and key listing capabilities.

Open Key-Value Store →

KV Basic Operations

Get, set, delete, increment, and decrement values stored in the KV store.

Open KV Basic Operations →

KV Batch Operations

Batch get, set, and delete multiple keys in a single request.

Open KV Batch Operations →

KV Atomic Operations

Push, pop, and remove array elements atomically inside the KV store.

Open KV Atomic Operations →

KV Time-Travel & History

Snapshots, diffs, and rollbacks for the KV store.

Open KV Time-Travel & History →

Health

Health endpoints expose liveness and observability signals for the SQLite service. The main health endpoint returns service identity, process-level resource counters, and hardening snapshots in a single response. The dedicated cache endpoint exposes only the cache sub-object for dashboards that need to poll cache pressure without re-reading process-level memory or file descriptors.

GET /api/v1/sqlite/health

Health check endpoint. One scrape covers both liveness and Phase G observability signals.

This endpoint takes no parameters.

cURL

curl -X GET "https://api.hoody.com/api/v1/sqlite/health" \
  -H "Authorization: Bearer <token>"

SDK

const result = await client.sqlite.health.getHealth();

Response 200

{
  "status": "ok",
  "service": "sqlite",
  "built": "2026-01-15T10:00:00Z",
  "started": "2026-01-20T12:34:56Z",
  "pid": 14253,
  "memory": {
    "rss_bytes": 134217728,
    "heap_used_bytes": 98566144,
    "heap_total_bytes": 125829120
  },
  "fds": {
    "open": 41,
    "limit": 65536
  },
  "cache": {
    "size_bytes": 67108864,
    "capacity_bytes": 268435456,
    "entries": 8421,
    "hit_ratio": 0.9732
  },
  "counters": {
    "requests_total": 1584231,
    "errors_total": 27,
    "kv_ops_total": 912488
  }
}

GET /api/v1/sqlite/health/cache

Returns only the cache sub-object from /health. Designed for dashboards that poll cache pressure without re-reading process-level memory or file descriptors.

This endpoint takes no parameters.

cURL

curl -X GET "https://api.hoody.com/api/v1/sqlite/health/cache" \
  -H "Authorization: Bearer <token>"

SDK

const result = await client.sqlite.health.getHealthCache();

Response 200

{
  "size_bytes": 67108864,
  "capacity_bytes": 268435456,
  "entries": 8421,
  "hit_ratio": 0.9732,
  "evictions_total": 1284,
  "last_evicted_at": "2026-01-20T12:31:02Z"
}