Skip to content

[260526-ologpp] replace raw-SQL with controller delegation for episode delete/rebuild MCP tools #36

@DarkCodePE

Description

@DarkCodePE

Implements 260526-ologpp

Layers

  • code: agentdb/src/mcp/agentdb-mcp-server.ts:1055-1073 (remove raw-SQL), tool registration near L394-426
  • tests: agentdb/tests/mcp-tools.test.ts (extend)

Acceptance Criteria

See docs/plans/260526-ologpp-mcp-controller-delegation-spec.md §5 (A1-A9) and §1 MUSTs (M1-M8).

Summary: register reflexion_delete_episode + reflexion_rebuild_index MCP tools that delegate to existing ReflexionMemory.deleteEpisode (L1152) and ReflexionMemory.rebuildIndex (L1297). Remove raw-SQL block at L1055-1073. Structured return shape {success, removed}. No bulk delete, no soft delete (separate issues).

Dependencies

None — independent of [260526-kpoimj]. Search vs admin paths are disjoint per spec §7. Sequence after #1 recommended only for clean rebase.

Out-of-scope

Per spec §3: bulk delete, soft delete/tombstoning, time-travel, full audit of other raw-SQL hot spots (L910, L1301-1306, L1347, L1382-1390) tracked as SHOULD S1.

Source artifacts

  • Spec: docs/plans/260526-ologpp-mcp-controller-delegation-spec.md
  • ADR (correction context): docs/adr/ADR-038-reflexion-memory-correction.md

Metadata

Metadata

Assignees

No one assigned

    Labels

    ready-for-afkIssue is fully specified and ready for autonomous agent execution

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions