feat(mother): Phase 1a — machine_id + local LLM schema #229

Merged
clawdie merged 1 commit from feat/phase1a-schema-mcp into main 2026-06-27 13:22:00 +02:00
Owner

Schema (mother_schema.sql):

  • Added machine_id TEXT UNIQUE column to hive_nodes
  • Idempotent migration ALTER TABLE + constraint
  • Extended derive_capabilities(): ollama_available, llama_cpp_available
    with model lists, plus inference_tier (local-fast/slow/remote-only)

MCP (node-register-mcp):

  • Accepts optional machine_id argument (null for unsecured nodes)
  • Passes through to INSERT/UPSERT with NULLIF for empty strings
  • COALESCE preserves existing machine_id on conflict (don't lose
    stable identity if hostname changes)

Sam & Hermes

Schema (mother_schema.sql): - Added machine_id TEXT UNIQUE column to hive_nodes - Idempotent migration ALTER TABLE + constraint - Extended derive_capabilities(): ollama_available, llama_cpp_available with model lists, plus inference_tier (local-fast/slow/remote-only) MCP (node-register-mcp): - Accepts optional machine_id argument (null for unsecured nodes) - Passes through to INSERT/UPSERT with NULLIF for empty strings - COALESCE preserves existing machine_id on conflict (don't lose stable identity if hostname changes) Sam & Hermes
clawdie added 1 commit 2026-06-27 13:21:42 +02:00
feat(mother): Phase 1a — machine_id + local LLM schema
Some checks failed
CI / rust (pull_request) Has been cancelled
CI / markdown (pull_request) Has been cancelled
CI / port (pull_request) Has been cancelled
CI / agent-jail-pkgs (pull_request) Has been cancelled
14697a07dd
Schema (mother_schema.sql):
- Added machine_id TEXT UNIQUE column to hive_nodes
- Idempotent migration ALTER TABLE + constraint
- Extended derive_capabilities(): ollama_available, llama_cpp_available
  with model lists, plus inference_tier (local-fast/slow/remote-only)

MCP (node-register-mcp):
- Accepts optional machine_id argument (null for unsecured nodes)
- Passes through to INSERT/UPSERT with NULLIF for empty strings
- COALESCE preserves existing machine_id on conflict (don't lose
  stable identity if hostname changes)

Sam & Hermes
clawdie merged commit 032f822de5 into main 2026-06-27 13:22:00 +02:00
clawdie deleted branch feat/phase1a-schema-mcp 2026-06-27 13:22:02 +02:00
Sign in to join this conversation.
No reviewers
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: clawdie/colibri#229
No description provided.