data

Data Debugging

Inspect and verify database state and subsystem data files directly. Use this command to:

• View SQLite database tables and data
• Inspect relay state files (adapters, bindings, sessions, mailboxes)
• Debug "data not showing" issues
• Verify pulse schedule and run state
• Check mesh agent registry

Data Architecture

DorkOS stores data in the .dork directory:

{DORK_HOME}/
├── config.json              # Server configuration
├── dork.db                  # SQLite database (WAL mode)
├── logs/
│   └── dorkos.log           # NDJSON structured logs
└── relay/
    ├── adapters.json         # Adapter configurations
    ├── bindings.json         # Adapter-agent bindings
    ├── sessions.json         # Active session mappings
    ├── access-rules.json     # Access control rules
    └── mailboxes/            # Per-subject message files
        └── relay.*.json      # Message queues by subject

DORK_HOME Location

Environment	Location
Development	apps/server/.temp/.dork/
Production	~/.dork/ (or DORK_HOME env var)

Arguments

Parse $ARGUMENTS:

• If a table name is provided, query that SQLite table
• If a SQL query is provided, execute it
• If --relay flag, inspect relay state files
• If --pulse flag, inspect pulse schedules and runs
• If --mesh flag, inspect mesh agent registry
• If empty, show overview and prompt for action

Phase 1: Data Overview

1.1 Show Available Data Sources

DORK_HOME="apps/server/.temp/.dork"

echo "=== Config ==="
cat "$DORK_HOME/config.json" | python3 -m json.tool

echo "=== SQLite Tables ==="
sqlite3 "$DORK_HOME/dork.db" ".tables"

echo "=== Relay State Files ==="
ls -la "$DORK_HOME/relay/" 2>/dev/null

echo "=== Log Files ==="
ls -la "$DORK_HOME/logs/" 2>/dev/null

1.2 Determine Action

AskUserQuestion:
  question: "What would you like to inspect?"
  header: "Action"
  options:
    - label: "SQLite database"
      description: "Query pulse, relay, or mesh tables in dork.db"
    - label: "Relay state files"
      description: "Inspect adapters, bindings, sessions, mailboxes"
    - label: "Server configuration"
      description: "View config.json settings"
    - label: "Run a custom query"
      description: "Execute a specific SQL query"