📊 Database Schema

Oxigraph RDF Triple Store (http://10.150.0.5:7878)

Table:

Column Type Description

Indexes

🔄 Event Flow

1 1. Gmail/Calendar → Pub/Sub topics
2 2. nerve-source-tasks subscribes → Claude extracts tasks
3 3. Tasks emitted as RDF triples → Oxigraph
4 4. tasks-web queries Oxigraph via SPARQL
5 5. task-mcp provides Claude Code integration

⚙️ Services

Service Type Language Description
nerve-source-tasks Cloud Run Python Extracts tasks from emails and meetings using AI
oxigraph Compute Engine VM Rust RDF triple store for Nerve events
task-mcp MCP Server Go Claude Code integration for querying tasks
tasks-web Cloud Run Go Web UI and API for task management

🔌 API Endpoints

Method Endpoint Description Parameters
GET /api/tasks List all tasks ?limit=50&offset=0&status=todo&priority=high
GET /api/tasks/:id Get task details Task ID in path
GET /api/search Search tasks ?q=authentication&limit=20
GET /api/stats Get task statistics None

📝 Task Data Model

{
  "id": "tasks:task-abc123",
  "source": "tasks",
  "event_type": "task",
  "user_id": "user@example.com",
  "title": "Fix OAuth redirect URI",
  "content": "Update the OAuth client settings...",
  "timestamp": "2024-02-08T18:30:00Z",
  "data": {
    "task_id": "task-abc123",
    "status": "todo",           // todo | in_progress | done | blocked
    "priority": "high",          // low | medium | high | urgent
    "assigned_to": "dev@example.com",
    "labels": ["bug", "auth", "production"],
    "entities": {
      "repos": ["org/repo-name"],
      "files": ["src/oauth.go", "terraform/main.tf"],
      "people": ["dev@example.com"],
      "projects": ["authentication"]
    },
    "workspace": {
      "repos": ["org/repo-name"],
      "branch": "fix-oauth-redirect",
      "files": ["src/oauth.go"]
    },
    "source_events": [
      {"type": "email", "id": "gmail:msg-123"}
    ]
  }
}

🛠️ Development Tools

  • task-mcp - Claude Code MCP server
    curl -sSL https://storage.googleapis.com/insilica-tools/task-mcp/install.sh | bash
  • nerve-cortex-mcp - Query all Nerve events
    curl -sSL https://storage.googleapis.com/insilica-tools/cortex-mcp/install.sh | bash
  • API Access - Direct HTTP access to task data
    curl https://tasks.insilica.co/api/tasks?limit=10