sql-mcp: hierarchy adopt · role_playing reject+strip

decision: partial (research 8709c016 → intent:pass → done). DW 표면(describe_table)은 dim/fact 컬럼 중심; libSQL에 hierarchy/role_playing 자식 테이블이 없으면 스키마만 넣어도 round-trip 소실·노이즈.

hierarchy — adopt (단계)

  • $defs.hierarchy: name + levels(≥2 unique, coarse→fine dimension names) + optional description; cube.hierarchies[] optional; AP:false.
  • libSQL meta_cube_hierarchies + store 분해/재조립; links 검증 levels ⊆ dimension names.
  • describe_table optional hierarchies[] = drill GROUP BY 순서 힌트 (컴파일러 auto-expand 없음).
  • 증거: unit hierarch + http api_meta_cube_hierarchies_roundtrip; sql-mcp **PR 2.

role_playing — reject + strip

  • 쿼리 가능 컬럼을 만들지 않음. sql-mcp는 별도 dimension + view join alias(다중 FK role-play)로 표현.
  • uni-semantic → sql-mcp emit: cube.role_playing[] strip (스키마 추가 없음). 허브 IR 필드는 유지 (PR #18 · 8066ed99).
  • 후속(선택): emit 전 dimension+join alias 전개 — MCP 본구현 티켓 아님.

semantic-ui hierarchy 편집 (PR #3)

  • CubeMappingEditor Hierarchies: ordered dim multi-select (coarse→fine); Apply validates name + levels≥2 unique + levels⊆dims (hierarchyLevelsError / hierarchyError in semantic-ui/src/model.ts).
  • Empty hierarchy list omits hierarchies key (additive clear compatibility).
  • No role_playing UI (Non-goal). Consumes FU1 schema/store (PR #2).
  • Evidence: cd semantic-ui && npm test 103 passed; merge f9564d11 PR #3; head deleted.
  • Dup close: f3582e2c cancelled; canonical UI ticket a506b29f.

Follow-ups (backlog)

  1. schema+$defs+skills+libSQL+store round-trip + levels⊆dims 검증 — 546582a6 (schema+store+describe 축은 PR 2로 일부 닫힘)
  2. describe_table + skill/client 힌트
  3. semantic-ui 편집 — done PR #3 / canonical a506b29f (dup f3582e2c cancelled)

관련