P3D — TAC→UI Baseline Prompt rev3 Zero Residual Hardcode Patch Report

Date: 2026-05-12 Patched: rev2 → rev3

---

Top 7 fixes

1. DB connection discovered — Removed hardcoded postgres/directus/directus. Phase 0A discovers PG container from docker ps, credentials from compose/env files. If not found → DB_CONNECTION_UNKNOWN, DB phases BLOCKED.

2. Filesystem root discovered — Removed /opt/incomex. Phase 0B discovers project root from docker mounts, compose file location, container working directory. If not found → PROJECT_ROOT_UNKNOWN.

3. Source directory discovered — Removed /web/. Phase 0C finds nuxt.config.* within discovered project root, derives source dir from its parent. If not found → source_dir UNKNOWN.

4. Table existence verified — Phase 1A verifies all 4 TAC tables exist via information_schema.tables before any data query. TABLE_MISSING → BLOCKED.

5. "Expected" → "Semantic hint" — Concept table column renamed. Hints are search guidance for resolution, not assertions. Agent must verify against actual schema, not match by memory.

6. SQL = PATTERN ONLY — Phases 4–5 explicitly labelled "PATTERN ONLY — Agent must compile executable SQL after resolution and include compiled SQL in report." No pattern is executable as-is.

7. Audit uses resolved concept — Removed hardcoded doc_code in grep. Phase 6C uses <resolved_code_column_name> from Phase 1 concept resolution. Audit dynamically adapts if column name differs.

---

Confirmation

baseline_prompt_rev=3
gpt_review_required_before_dispatch=true
phase5c2_migration_allowed=false
agent_dispatch_allowed=false

---

rev3 Zero Residual Hardcode Patch Report | 2026-05-12