Database Schema
SQLite database at ~/Library/Application Support/recall/recall.db.
commands
| Column | Type | Description |
|---|---|---|
id | INTEGER PK | Auto-increment |
description | TEXT NOT NULL | Human-readable label |
command | TEXT NOT NULL | Shell command |
aliases | TEXT NOT NULL DEFAULT ‘’ | Space/comma-separated tags |
created_at | INTEGER NOT NULL | Unix timestamp (seconds) |
updated_at | INTEGER NOT NULL | Unix timestamp (seconds) |
use_count | INTEGER NOT NULL DEFAULT 0 | Times copied |
last_used | INTEGER | Unix timestamp of last copy, or NULL |
embeddings
| Column | Type | Description |
|---|---|---|
command_id | INTEGER PK FK→commands(id) | Cascade delete |
vector | BLOB NOT NULL | 384-dim float32 vector, little-endian |
Migrations
Migrations run at app startup via idempotent ALTER TABLE ... ADD COLUMN (silently ignores duplicate column errors):
ALTER TABLE commands ADD COLUMN use_count INTEGER NOT NULL DEFAULT 0;
ALTER TABLE commands ADD COLUMN last_used INTEGER;