---
id: "AE24-040"
category: "technical"
confidence: 0.95
date: "2026-02-16"
source_file: "hive/progress/session_23_handoff.md (Session 23, Finding #2)"
---

# AE24-040

The MCP-PostgreSQL Disconnect pattern is a critical production bug class: when the data loader reads from one source (JSON files) while the API writes to another (PostgreSQL), data never syncs and the system silently serves stale data. Solution: PG-primary with JSON-fallback pattern ensures single source of truth with graceful degradation.
