---
id: 9924
title: '[Sub-Task] Database Service & Health Diagnostics Migration'
state: CLOSED
labels:
  - enhancement
  - ai
  - architecture
assignees:
  - tobiu
createdAt: '2026-04-12T14:15:46Z'
updatedAt: '2026-04-12T17:00:00Z'
githubUrl: 'https://github.com/neomjs/neo/issues/9924'
author: tobiu
commentsCount: 0
parentIssue: 9922
subIssues: []
subIssuesCompleted: 0
subIssuesTotal: 0
blockedBy: []
blocking: []
closedAt: '2026-04-12T15:36:27Z'
---
# [Sub-Task] Database Service & Health Diagnostics Migration

Origin Session ID: af26000d-914a-4eb0-8d28-2c09e9cb4cb5
Parent Epic: #9922

## Context
With the shift to a ChromaDB + SQLite Two-Pillar paradigm, the underlying memory-core diagnostics and database routing layers are outdated. `DatabaseService.mjs` must stop routing all operations exclusively to the `neo-sqlite` directory, and `HealthService.mjs` needs to report multi-engine health strings accurately in its Heartbeat.

## Technical Requirements
1. **Health Tracking (`HealthService.mjs`):** Modify the healthcheck heartbeat payload. It currently merges vector and graph status. It must now evaluate `sqliteManager` (Graph mapping) and `chromaManager` (HNSW) independently. If Chroma fails, vector operations enter `DEGRADED`, but Graph traversals remain `OK`.
2. **Database Routing (`DatabaseService.mjs`):** Rewrite the backend maintenance endpoints. Legacy functions expecting single-file SQLite backups or truncations must explicitly branch: vector truncations ping Chroma REST endpoints, while Graph truncations delete SQLite records.

## Definitions of Done
- `mcp_neo-mjs-memory-core_healthcheck` returns distinct properties for `chroma` and `graph` engine vitality.
- Database backup/clear logic handles both components securely.

## Timeline

- 2026-04-12T14:15:49Z @tobiu added the `enhancement` label
- 2026-04-12T14:15:49Z @tobiu added the `ai` label
- 2026-04-12T14:15:49Z @tobiu added the `architecture` label
- 2026-04-12T14:15:57Z @tobiu added parent issue #9922
- 2026-04-12T14:23:23Z @tobiu referenced in commit `064482d` - "feat(memory-core): Migrate Database service and Health Diagnostics (#9924)"
- 2026-04-12T14:23:34Z @tobiu cross-referenced by PR #9926
- 2026-04-12T15:36:26Z @tobiu referenced in commit `66569e6` - "feat: Two-Pillar Hybrid RAG Architecture (#9922) (#9926)

* feat(memory-core): Re-align configuration and lifecycles for Two-Pillar RAG (#9923)

* feat(memory-core): Migrate Database service and Health Diagnostics (#9924)

* feat(memory-core): Implement Dual-Pass Re-Ranking Middleware and Extricate SQLiteVectorManager (#9925)"
- 2026-04-12T15:36:27Z @tobiu closed this issue
- 2026-04-12T17:00:00Z @tobiu assigned to @tobiu
- 2026-05-08T10:06:02Z @neo-gpt cross-referenced by #10944

