The fastest, cheapest, most efficient open-source agent harness. Run more than 500 agents on a $10 VPS.
Code Commits Issues Pull requests Wiki Builds Discussions Projects Insights Search Files 6 branches · 115 tags openhuman / docs / storage-schema.md 8.0 KB
Code Raw Blame Permalink Storage schema
Each crate declares its collections with CollectionSpec; the host calls
ensure_collection for every declaration at boot. Sections preserve the declaring
crate, including when two crates use the same collection name.
Record shapes and migrations stay with their owners.
openhuman-core
Collection
Indexes
Expiry field
Search fields
agents.registry
approvals.flow_trust
by_flow (flow_id, tool_name)
approvals.requests
by_decided (pending, decided_ms)by_pending (pending, created_ms)by_session (session_id, pending)
artifacts.args
artifacts.records
by_thread (thread_id, created_ms)
artifacts.versions
config.documents
cost.records
by_time (ts_ms)
devices.paired
by_active (revoked, created_ms)
inbound.results
by_source (source, created_ms)by_status (status, created_ms)
notifications.core
by_read (workspace, read, timestamp_ms)
notifications.dedup
notifications.integration
by_provider (provider, received_ms)by_status (status)
notifications.settings
openhuman.journal_backfill
profiles.registry
subagents.session_epochs
subagents.sessions
task_sources.ingested
by_source (source_id, ingested_ms)
task_sources.sources
by_created (created_ms)
threads.channel_messages
threads.reply_viseme_timelines
threads.staged_attachments
threads.transcript_keys
tinyagents-harness
Collection
Indexes
Expiry field
Search fields
harness.attachment_stash
touched (touched_ms)
harness.embedding_cache
by_signature (sig)
harness.run_status
by_active (active)by_root (root_run_id)by_thread (thread_id)
tinyagents-session
Collection
Indexes
Expiry field
Search fields
conversations.appends
conversations.threads
history.messages
session_id (session_id, id)
history.search
session (session_id)
agent_name, content, tool_name
history.sessions
agent (agent_definition_id)channel (source_channel)parent (parent_session_id, started_ms)started (started_ms)status_started (status, started_ms)thread (thread_id)
history.tool_calls
created (created_ms)session_id (session_id, id)tool (tool_name)
ledger.agent_runs
kind (kind)parent (parent_run_id)status (status)thread (parent_thread_id)updated (updated_ms)worker (worker_thread_id)
ledger.event_heads
ledger.event_outbox
run_sequence (run_id, sequence) unique
ledger.members
created (created_ms)team_name (team_id, name) uniqueteam (team_id)
ledger.tasks
claimed (claimed_by_member_id)order (team_id, order_index, created_ms)status (status)team (team_id)
ledger.teams
status (status)thread (parent_thread_id)updated (updated_ms)
ledger.telemetry
updated (updated_ms)
ledger.tool_effects
run (run_id)started (started_ms)status (status)
ledger.workflow_runs
definition (definition_id)status (status)thread (parent_thread_id)updated (updated_ms)
session.transcript_entries
by_stem_written (stem, written)by_stem (stem, seq)
session.transcripts
by_agent_id_created (agent_id, created_ms)by_agent_name_created (agent_name, created_ms)by_thread_created (thread_id, created_ms)
session.turn_states
by_thread (thread_id)
tsd.counters
tsd.kv
kv_by_key (owner, ns, key)
tsd.leases
tsd.migrations
tinyagents-tasks
Collection
Indexes
Expiry field
Search fields
tasks.completions
by_parent (parent_key)by_state (state)
tasks.history
task_rev (task_id, rev) unique
tasks.records
kind (kind_label)node (node_id)parent (parent_run_id)root (root_run_id)status (status)thread (thread_id)
tinybox-bus
Collection
Indexes
Expiry field
Search fields
box.boxes
box.cli_imports
box.jail_index
box.migrations
box.templates
tinychannels-bus
Collection
Indexes
Expiry field
Search fields
channel_remote_bindings
channel_remote_busy
channel_remote_meta
channels.delivery_failed
channels.delivery_pending
channels.delivery_results
channels.media_metadata
channels.migrations
channels.remote_bindings
channels.remote_busy
channels.remote_meta
channels.whatsapp_device
channels.whatsapp_identity
channels.whatsapp_lid_mapping
channels.whatsapp_prekey
channels.whatsapp_sender_key
channels.whatsapp_session
channels.whatsapp_signed_prekey
channels.whatsapp_sync_key
channels_delivery_failed
channels_delivery_pending
channels_delivery_results
whatsapp_device
whatsapp_identity
whatsapp_lid_mapping
whatsapp_prekey
whatsapp_sender_key
whatsapp_session
whatsapp_signed_prekey
whatsapp_sync_key
tinyconnectors-bus
Collection
Indexes
Expiry field
Search fields
connectors.migrations
connectors.user_scopes
tinyeventqueues-bus
Collection
Indexes
Expiry field
Search fields
teq.ambient
teq.buckets
teq.cadence
teq.coalesce
by_due (due_ms)by_thread (thread_group)
teq.conversations
teq.digest
teq.habituation
teq.outcomes
by_disposition (disposition)by_expiry (expires_ms)
teq.redriven
teq.staged
by_cadence (cadence_key)by_due (due_ms)
teq.threads
teq.tombstones
by_expiry (expires_ms)
tinyjuice-bus
Collection
Indexes
Expiry field
Search fields
juice.savings
tinymcp-bus
Collection
Indexes
Expiry field
Search fields
mcp.registry_cache
cache_key (cache_key)
mcp.registry_index
source (source)
mcp.registry_index_state
mcp.server_names
mcp.servers
installed_ms (installed_ms)qualified_name (qualified_name)
mcp.tool_cache
tsd.migrations
tinyskills-drivers
Collection
Indexes
Expiry field
Search fields
skills.bundles
skills.catalogs
skills.migrations
tinywallet-bus
Collection
Indexes
Expiry field
Search fields
wallet.budgets
wallet.migrations