@vox-ai-app/storage

@vox-ai-app/storage

Local persistence for Vox: conversations, messages, tasks, settings, tool registry, MCP servers, schedules, secrets, patterns, and vector embeddings. Built on SQLite via better-sqlite3 with WAL mode and automatic migrations.

Install

npm install @vox-ai-app/storage

Exports

Export	Contents
@vox-ai-app/storage	All exports
@vox-ai-app/storage/db	Database lifecycle (open/close)
@vox-ai-app/storage/messages	Conversations and messages
@vox-ai-app/storage/tasks	Task and task activity storage
@vox-ai-app/storage/tools	Custom tool definitions
@vox-ai-app/storage/settings	Key-value settings persistence
@vox-ai-app/storage/mcp-servers	MCP server configurations
@vox-ai-app/storage/schedules	Scheduled job persistence
@vox-ai-app/storage/tool-secrets	Encrypted tool secret storage
@vox-ai-app/storage/patterns	Conversation pattern storage
@vox-ai-app/storage/vectors	Vector embedding storage

Database

import { openDb, closeDb } from '@vox-ai-app/storage/db'

const db = openDb('/path/to/storage.db')
closeDb('/path/to/storage.db')

The database uses WAL journal mode and foreign keys. Schema is managed via migrations in src/migrations/.

Messages

import {
  ensureConversation,
  appendMessage,
  getMessages,
  getMessagesBeforeId,
  clearMessages,
  saveSummaryCheckpoint,
  loadSummaryCheckpoint
} from '@vox-ai-app/storage/messages'

ensureConversation(db, 'main')
appendMessage(db, 'user', 'Hello', 'main')
appendMessage(db, 'assistant', 'Hi there!', 'main')

const messages = getMessages(db, 'main', 50)
const older = getMessagesBeforeId(db, messages[0].id, 'main', 20)

saveSummaryCheckpoint(db, 'summary text', 42, 'main')
const { summary, checkpointId } = loadSummaryCheckpoint(db, 'main')

clearMessages(db, 'main')

Tasks

import {
  upsertTask,
  getTask,
  loadTasks,
  appendTaskActivity,
  loadTaskActivity
} from '@vox-ai-app/storage/tasks'

upsertTask(db, {
  taskId: 'abc-123',
  instructions: 'Summarize the document',
  status: 'running'
})

const task = getTask(db, 'abc-123')
const allTasks = loadTasks(db)

appendTaskActivity(db, {
  id: 'act-1',
  taskId: 'abc-123',
  type: 'tool_call',
  name: 'read_local_file',
  timestamp: new Date().toISOString(),
  data: { path: '~/doc.md' }
})

const activity = loadTaskActivity(db, 'abc-123')

Settings

import { getSetting, setSetting, getAllSettings, deleteSetting } from '@vox-ai-app/storage/settings'

setSetting(db, 'theme', 'dark')
const theme = getSetting(db, 'theme')
const all = getAllSettings(db)
deleteSetting(db, 'theme')

License

MIT