KV Store: Time-Travel & History

The KV Store keeps a complete operation log for every key and table, enabling point-in-time reconstruction, change inspection, and rollback. Use these endpoints to audit query and key history, take snapshots at specific operation numbers or Unix timestamps, diff states across windows, and restore previous values. All endpoints require a database path via the db query parameter; custom tables are selected with table (default kv_store).

Query History

`GET /api/v1/sqlite/history`

Retrieve query execution history for a database with an optional entry limit.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path
`limit`	query	integer	No	Maximum number of entries to return. Default: `100`

Response

{
  "history": [
    {
      "id": 42,
      "db": "app.db",
      "query": "SELECT id, name FROM users WHERE active = 1",
      "timestamp": 1700000000,
      "duration_ms": 12,
      "rows_affected": 17,
      "status": "ok"
    },
    {
      "id": 41,
      "db": "app.db",
      "query": "UPDATE users SET last_seen = 1700000000",
      "timestamp": 1699999990,
      "duration_ms": 8,
      "rows_affected": 1024,
      "status": "ok"
    }
  ],
  "count": 2,
  "has_more": true
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_DB_PATH",
  "message": "Database path 'app.db' could not be resolved"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.history.list({ db: 'app.db', limit: 100 });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/history?db=app.db&limit=100' \
  -H 'Authorization: Bearer <token>'

`GET /api/v1/sqlite/history/stats`

Retrieve aggregated statistics about query execution history for a database.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path

Response

{
  "db": "app.db",
  "total_queries": 1542,
  "total_duration_ms": 84320,
  "avg_duration_ms": 54.7,
  "errors": 23,
  "first_query_at": 1699000000,
  "last_query_at": 1700000500
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "Missing required parameter: db"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.history.getStats({ db: 'app.db' });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/history/stats?db=app.db' \
  -H 'Authorization: Bearer <token>'

`DELETE /api/v1/sqlite/history`

Delete all query history entries for a database.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path

Response

{
  "db": "app.db",
  "cleared": true,
  "deleted_count": 1542
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_DB_PATH",
  "message": "Database path 'app.db' could not be resolved"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.history.clear({ db: 'app.db' });

curl -X DELETE 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/history?db=app.db' \
  -H 'Authorization: Bearer <token>'

`DELETE /api/v1/sqlite/history/{index}`

Delete a specific query history entry by its numeric ID.

Parameters

Name	In	Type	Required	Description
`index`	path	integer	Yes	History entry ID
`db`	query	string	Yes	Database file path

Response

{
  "db": "app.db",
  "deleted": true,
  "index": 42
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "index must be a positive integer"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 404,
  "error": "Not Found",
  "code": "KEY_NOT_FOUND",
  "message": "History entry not found"
}

Error Code	Title	Description	Resolution
`KEY_NOT_FOUND`	Key not found	The requested key does not exist in the KV store	Verify the key name and database/table parameters
`DATABASE_NOT_FOUND`	Database file does not exist	The specified database file was not found	Check the file path or use create_db_if_missing=true to create it
`KEY_EXPIRED`	Key expired	The key existed but has expired due to TTL	The key was automatically deleted. Store a new value if needed.

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.history.deleteEntry(42, { db: 'app.db' });

curl -X DELETE 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/history/42?db=app.db' \
  -H 'Authorization: Bearer <token>'

Key History & Snapshots

`GET /api/v1/sqlite/kv/{key}/history`

Retrieve the operation history for a specific key, showing every change over time.

Parameters

Name	In	Type	Required	Description
`key`	path	string	Yes	Key name
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`limit`	query	integer	No	Maximum number of operations to return (0 → default 50, clamped to maximum 1000). Default: `50`

Response

{
  "key": "user:42",
  "table": "kv_store",
  "operations": [
    {
      "op_number": 7,
      "op_type": "SET",
      "value": "alice",
      "timestamp": 1700000120,
      "ttl": null
    },
    {
      "op_number": 4,
      "op_type": "SET",
      "value": "{\"name\":\"alice\"}",
      "timestamp": 1699999000,
      "ttl": null
    },
    {
      "op_number": 1,
      "op_type": "SET",
      "value": "{\"name\":\"bob\"}",
      "timestamp": 1699995000,
      "ttl": null
    }
  ],
  "count": 3,
  "has_more": false
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "limit must be a non-negative integer"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.getHistory('user:42', { db: 'app.db', limit: 50 });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/user:42/history?db=app.db&limit=50' \
  -H 'Authorization: Bearer <token>'

`GET /api/v1/sqlite/kv/{key}/snapshot`

Reconstruct the value of a key as it existed at a specific operation number.

Parameters

Name	In	Type	Required	Description
`key`	path	string	Yes	Key name
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`op_number`	query	integer	Yes	Operation number to reconstruct from

Response

{
  "key": "user:42",
  "table": "kv_store",
  "op_number": 4,
  "value": "{\"name\":\"alice\"}",
  "reconstructed_at": 1700000500
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "op_number must be a positive integer"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 404,
  "error": "Not Found",
  "code": "KEY_NOT_FOUND",
  "message": "Key 'user:42' has no operation 4"
}

Error Code	Title	Description	Resolution
`KEY_NOT_FOUND`	Key not found	The requested key does not exist in the KV store	Verify the key name and database/table parameters
`DATABASE_NOT_FOUND`	Database file does not exist	The specified database file was not found	Check the file path or use create_db_if_missing=true to create it
`KEY_EXPIRED`	Key expired	The key existed but has expired due to TTL	The key was automatically deleted. Store a new value if needed.

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.getSnapshot('user:42', { db: 'app.db', op_number: 4 });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/user:42/snapshot?db=app.db&op_number=4' \
  -H 'Authorization: Bearer <token>'

Table Snapshots & Diffs

`GET /api/v1/sqlite/kv/snapshot`

Reconstruct the entire KV table state as it was at a specific Unix timestamp.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`timestamp`	query	integer	Yes	Unix timestamp to reconstruct from
`limit`	query	integer	No	Maximum number of keys to return. Default: `100`
`prefix`	query	string	No	Filter keys by prefix

Response

{
  "table": "kv_store",
  "timestamp": 1700000000,
  "keys": {
    "user:42": "alice",
    "user:43": "carol",
    "session:abc": "{\"token\":\"xyz\"}"
  },
  "count": 3,
  "has_gaps": false,
  "gap_keys": [],
  "candidate_truncated": false
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "timestamp must be a positive Unix timestamp"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

{
  "statusCode": 503,
  "error": "Service Unavailable",
  "message": "Request deadline exceeded before commit"
}

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.getTableSnapshot({ db: 'app.db', timestamp: 1700000000, limit: 100, prefix: 'user:' });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/snapshot?db=app.db&timestamp=1700000000&limit=100&prefix=user:' \
  -H 'Authorization: Bearer <token>'

`GET /api/v1/sqlite/kv/diff`

Compare the KV table state between two Unix timestamps, surfacing created, modified, and deleted keys.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`from`	query	integer	Yes	Starting timestamp (Unix)
`to`	query	integer	Yes	Ending timestamp (Unix)
`keys`	query	string	No	Comma-separated list of keys to compare (optional)

Response

{
  "table": "kv_store",
  "from": 1699999000,
  "to": 1700000000,
  "created": ["user:43"],
  "modified": ["user:42"],
  "deleted": ["session:old"],
  "has_gaps": false,
  "gap_keys": [],
  "candidate_truncated": false
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "from must be <= to"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

{
  "statusCode": 503,
  "error": "Service Unavailable",
  "message": "Request deadline exceeded before commit (large candidate set or heavy maintenance contention)"
}

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.compareSnapshots({ db: 'app.db', from: 1699999000, to: 1700000000, keys: 'user:42,user:43' });

curl -X GET 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/diff?db=app.db&from=1699999000&to=1700000000&keys=user:42,user:43' \
  -H 'Authorization: Bearer <token>'

Rollback

`POST /api/v1/sqlite/kv/{key}/rollback`

Roll a key back to a previous state by undoing the last N operations.

Parameters

Name	In	Type	Required	Description
`key`	path	string	Yes	Key name
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`steps`	query	integer	No	Number of operations to rollback. Default: `1`

Response

{
  "key": "user:42",
  "table": "kv_store",
  "rolled_back_steps": 1,
  "current_value": "alice",
  "current_op_number": 4
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "steps must be a positive integer"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 404,
  "error": "Not Found",
  "code": "KEY_NOT_FOUND",
  "message": "Key 'user:42' has no history to rollback"
}

Error Code	Title	Description	Resolution
`KEY_NOT_FOUND`	Key not found	The requested key does not exist in the KV store	Verify the key name and database/table parameters
`DATABASE_NOT_FOUND`	Database file does not exist	The specified database file was not found	Check the file path or use create_db_if_missing=true to create it
`KEY_EXPIRED`	Key expired	The key existed but has expired due to TTL	The key was automatically deleted. Store a new value if needed.

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.rollback('user:42', { db: 'app.db', steps: 1 });

curl -X POST 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/user:42/rollback?db=app.db&steps=1' \
  -H 'Authorization: Bearer <token>'

`POST /api/v1/sqlite/kv/rollback`

Roll the entire KV table back to a specific Unix timestamp. The endpoint requires confirm=yes and an explicit to_timestamp to execute; use dry_run=true to preview the affected keys without applying changes.

Parameters

Name	In	Type	Required	Description
`db`	query	string	Yes	Database file path
`table`	query	string	No	Custom table name. Default: `kv_store`
`to_timestamp`	query	integer	Yes	Target timestamp to rollback to (Unix)
`dry_run`	query	boolean	No	Preview changes without applying. Default: `false`
`confirm`	query	string	No	Must be `yes` to execute actual rollback

Request Body

Optional filters that limit the rollback to a subset of keys. The body schema is empty; no body fields are required.

{}

Response

{
  "table": "kv_store",
  "to_timestamp": 1700000000,
  "dry_run": false,
  "rolled_back": true,
  "affected_keys": ["user:42", "user:43"]
}

{
  "statusCode": 400,
  "error": "Bad Request",
  "code": "INVALID_PARAMETERS",
  "message": "confirm=yes is required to execute the rollback"
}

Error Code	Title	Description	Resolution
`INVALID_DB_PATH`	Invalid database path	The provided database path is invalid or inaccessible	Provide a valid absolute path, or use bare name / ./name shorthand (resolved to /hoody/databases/*.db)
`INVALID_PARAMETERS`	Invalid request parameters	One or more request parameters are invalid or malformed	Check parameter types and values against the API specification
`INVALID_SQLITE_HEADER`	Not a valid SQLite database	The file exists but is not a valid SQLite database	Ensure the file is a valid SQLite database with proper header
`PATH_IS_DIRECTORY`	Path is a directory	Expected a.db file but got a directory (use table parameter for directory mode)	Use a .db file path or add table parameter for directory mode KV store

{
  "statusCode": 409,
  "error": "Conflict",
  "message": "Time-travel chain gap (cannot rollback deterministically)"
}

{
  "statusCode": 413,
  "error": "Payload Too Large",
  "message": "keys or exclude_keys array exceeds the 10000-entry cap"
}

{
  "statusCode": 500,
  "error": "Internal Server Error",
  "code": "DATABASE_ERROR",
  "message": "An internal database error occurred"
}

Error Code	Title	Description	Resolution
`DATABASE_ERROR`	Database operation failed	An internal database error occurred	Check server logs for details. Database may be corrupted or locked.
`FILE_SYSTEM_ERROR`	File system error	Failed to read or write filesystem in directory mode	Check file permissions and disk space

SDK Usage

TypeScript SDK
cURL

import { HoodyClient } from 'hoody-sdk';

const client = new HoodyClient({ baseURL: 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com', token: process.env.HOODY_TOKEN });

await client.sqlite.kvStore.rollbackTable(
  {},
  { db: 'app.db', to_timestamp: 1700000000, dry_run: false, confirm: 'yes' }
);

curl -X POST 'https://{projectId}-{containerId}-sqlite-1.{server}.containers.hoody.com/api/v1/sqlite/kv/rollback?db=app.db&to_timestamp=1700000000&confirm=yes' \
  -H 'Authorization: Bearer <token>' \
  -H 'Content-Type: application/json' \
  -d '{}'