nabu.db•201 kB
SQLite format 3 @ 1 .�* � �\
] � �.�^��3�? � U+qindexidx_messages_tomessagesCREATE INDEX idx_messages_to ON messages(to_agent)[/yindexidx_messages_frommessagesCREATE INDEX idx_messages_from ON messages(from_agent)S/mindexidx_agents_statusagentsCREATE INDEX idx_agents_status ON agents(status)�?�]tabletaskstasksCREATE TABLE tasks (
id TEXT PRIMARY KEY,
milestone_id TEXT,
project_id TEXT NOT NULL,
title TEXT NOT NULL,
description TEXT,
status TEXT DEFAULT 'pending',
assigned_to TEXT,
priority INTEGER DEFAULT 5,
metadata TEXT, -- JSON object
created INTEGER NOT NULL,
completed_at INTEGER,
FOREIGN KEY (milestone_id) REFERENCES milestones(id),
FOREIGN KEY (project_id) REFERENCES projects(id),
FOREIGN KEY (assigned_to) REFERENCES agents(id)
))= indexsqlite_autoindex_tasks_1tasks�!!�{tablemilestonesmilestones
CREATE TABLE milestones (
id TEXT PRIMARY KEY,
project_id TEXT NOT NULL,
title TEXT NOT NULL,
description TEXT,
status TEXT DEFAULT 'pending',
due_date INTEGER,
completed_at INTEGER,
metadata TEXT, -- JSON object
created INTEGER NOT NULL,
FOREIGN KEY (project_id) REFERENCES projects(id)
)3
G! indexsqlite_autoindex_milestones_1milestones�3
�9tableservicesservicesCREATE TABLE services (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
type TEXT NOT NULL, -- api, database, queue, etc.
endpoint TEXT,
status TEXT DEFAULT 'unknown',
health_check_url TEXT,
last_check INTEGER,
response_time_ms INTEGER,
metadata TEXT, -- JSON object
created INTEGER NOT NULL,
updated INTEGER NOT NULL
)/C indexsqlite_autoindex_services_1services�
�mtableprojectsprojectsCREATE TABLE projects (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
path TEXT NOT NULL UNIQUE,
description TEXT,
type TEXT, -- git, npm, python, etc.
status TEXT DEFAULT 'active',
metadata TEXT, -- JSON object (git info, dependencies, etc.)
created INTEGER NOT NULL,
updated INTEGER NOT NULL
)/ C indexsqlite_autoindex_projects_2projects
/C indexsqlite_autoindex_projects_1projects �S�ytablememoriesmemoriesCREATE TABLE memories (
id TEXT PRIMARY KEY,
content TEXT NOT NULL,
type TEXT NOT NULL CHECK (type IN ('fact', 'insight', 'experience', 'error')),
embedding BLOB, -- Vector embedding
agent_id TEXT,
project_id TEXT,
relevance_score REAL DEFAULT 1.0,
access_count INTEGER DEFAULT 0,
last_accessed INTEGER,
metadata TEXT, -- JSON object
created INTEGER NOT NULL,
FOREIGN KEY (agent_id) REFERENCES agents(id),
FOREIGN KEY (project_id) REFERENCES projects(id)
)/C indexsqlite_autoindex_memories_1memories�K�itablemessagesmessagesCREATE TABLE messages (
id TEXT PRIMARY KEY,
from_agent TEXT NOT NULL,
to_agent TEXT, -- NULL for broadcasts
content TEXT NOT NULL,
channel TEXT,
timestamp INTEGER NOT NULL,
message_type TEXT NOT NULL DEFAULT 'message',
metadata TEXT, -- JSON object
FOREIGN KEY (from_agent) REFERENCES agents(id),
FOREIGN KEY (to_agent) REFERENCES agents(id)
)/C indexsqlite_autoindex_messages_1messages�;�QtableagentsagentsCREATE TABLE agents (
id TEXT PRIMARY KEY,
name TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'online',
capabilities TEXT NOT NULL, -- JSON array
last_seen INTEGER NOT NULL,
metadata TEXT, -- JSON object
created INTEGER NOT NULL
)+? indexsqlite_autoindex_agents_1agents
� 1���������������� �|7[ �Aproj_9321189dda9df6a1OpenGl/home/persist/repos/learning/Cpp/OpenGlgitactive{"repository":"git@github.com:alephpt/OpenGL-Projects.git","packageInfo":{},"gitInfo":{"remoteUrl":"git@github.com:alephpt/OpenGL-Projects.git","currentBranch":"master","lastCommit":{"hash":"846ea8b1c24834575451021e6ec66aab42dff41b","author":"alephpt","date":"2024-04-23T19:56:01.000Z","message":"I can't figure out fov"},"status":{"staged":0,"unstaged":7,"untracked":0}},"lastScan":"2025-09-02T18:19:40.339Z"}������7W �[proj_fa0e8df2b90e9190OpenGL/home/persist/repos/learning/C/OpenGLgitactive{"repository":"git@github.com:alephpt/OpenGL-Projects.git","packageInfo":{},"gitInfo":{"remoteUrl":"git@github.com:alephpt/OpenGL-Projects.git","currentBranch":"master","lastCommit":{"hash":"653019ecee6f3af4c2b915ea9c4adce942400b0a","author":"alephpt","date":"2024-03-25T06:59:56.000Z","message":"dunno what I'm doing at this point"},"status":{"staged":0,"unstaged":20,"untracked":1}},"lastScan":"2025-09-02T18:19:40.326Z"}������67+Am�]proj_2ceb4e53f597a13aroadmap-manager/home/persist/repos/hookerVisual Planning and Roadmap Management Interfacegitactive{"repository":"git@github.com:TheNexusGroup/hooker.git","framework":"react","language":"typescript","packageInfo":{"name":"roadmap-manager","version":"1.0.0","description":"Visual Planning and Roadmap Management Interface","main":"index.js","scripts":{"dev":"concurrently \"npm run dev:server\" \"npm run dev:client\"","dev:server":"tsx watch src/server/index.ts","dev:server:simple":"tsx watch src/server-simplified.ts","dev:client":"vite","build":"npm run build:server && npm run build:client","build:server":"tsc -p tsconfig.server.json","build:client":"vite build","start":"NODE_ENV=production tsx src/server-unified.ts","start:production":"NODE_ENV=production tsx src/server-unified.ts","start:unified":"NODE_ENV=production tsx src/server-unified.ts","start:mcp":"NODE_ENV=production tsx src/server-unified.ts --mcp","service:install":"sudo cp hooker.service /etc/systemd/system/ && sudo systemctl daemon-reload && sudo systemctl enable hooker","service:start":"sudo systemctl start hooker","service:stop":"sudo systemctl stop hooker","service:status":"sudo systemctl status hooker","service:logs":"sudo journalctl -u hooker -f","test":"jest","lint":"eslint src/**/*.{ts,tsx}","format":"prettier --write src/**/*.{ts,tsx,css}","typecheck":"tsc --noEmit"},"dependencies":{"@modelcontextprotocol/sdk":"^1.17.4","@reduxjs/toolkit":"^2.0.0","@types/cors":"^2.8.19","@types/express":"^5.0.3","@types/node":"^24.3.0","@types/react":"^18.2.0","@types/react-beautiful-dnd":"^13.1.5","@types/react-dom":"^18.2.0","@types/uuid":"^10.0.0","@types/ws":"^8.18.1","axios":"^1.11.0","commander":"^14.0.0","concurrently":"^9.2.1","cors":"^2.8.5","discord.js":"^14.22.1","dotenv":"^17.2.1","express":"^5.1.0","node-fetch":"^3.3.2","react":"^18.2.0","react-beautiful-dnd":"^13.1.1","react-dom":"^18.2.0","react-redux":"^9.0.0","react-router-dom":"^6.30.1","reactflow":"^11.10.0","sqlite3":"^5.1.7","tsx":"^4.20.5","typescript":"^5.3.0","uuid":"^11.1.0","ws":"^8.18.3"},"devDependencies":{"@testing-library/jest-dom":"^6.1.0","@testing-library/react":"^14.1.0","@typescript-eslint/eslint-plugin":"^6.15.0","@typescript-eslint/parser":"^6.15.0","@vitejs/plugin-react":"^4.2.0","eslint":"^8.55.0","eslint-plugin-react":"^7.33.0","eslint-plugin-react-hooks":"^4.6.0","jest":"^29.7.0","prettier":"^3.1.0","vite":"^5.0.0"},"framework":"react","language":"typescript"},"gitInfo":{"remoteUrl":"git@github.com:TheNexusGroup/hooker.git","currentBranch":"main","lastCommit":{"hash":"684b4e40cc5b01c306e1c747e1ebe06e65cae848","author":"Richard Christopher","date":"2025-08-31T23:56:47.000Z","message":"Implement bidirectional Discord-Claude communication system"},"status":{"staged":0, .>