feat: star-schema-advisor slash command

[cristinabaldor]

Summary

Build the /star-schema-advisor Claude Code slash command to help analysts triage rpt_tableau__* reporting views during the star schema migration.

The tool:

1. Parses every field in a chosen reporting view alongside how it is actually used in viz (dimension or aggregated measure)
2. Produces a field-by-field verdict: dim, fact, semantic layer, recreate in BI, ambiguous, or skip
3. Writes a shareable markdown report that serves as the analyst review artifact and a persistent semantic layer queue for a future /cube-measure-generator command
4. Applies approved dbt mart changes (adding columns to existing models or drafting new ones), leaving all mart files unstaged for analyst review

Deliverables

• scripts/tableau-analyze-workbook.py — standalone Tableau XML parser; replaces scripts/tableau-extract-calcs.py
• .claude/commands/star-schema-advisor.md — slash command workflow
• docs/superpowers/star-schema-reports/ — per-run report directory
• tests/scripts/test_tableau_analyze_workbook.py + fixtures

Spec & Plan

• Spec: docs/superpowers/specs/2026-03-20-star-schema-advisor-design.md
• Plan: docs/superpowers/plans/2026-03-20-star-schema-advisor.md

[cbini]

Consolidation Summary

This issue is now the single tracker for the star-schema-advisor tooling. The following was consolidated here:

From #3513 — "docs: star-schema-advisor spec and implementation plan"

What it was: The design spec and implementation plan for the /star-schema-advisor slash command, covering the full workflow for triaging rpt_tableau__* reporting views into dbt mart changes and a semantic layer queue.

Why it was consolidated: #3513 was purely the design docs for this issue — the spec and plan are deliverables listed in this issue's body.

Documents (on active branches):

• Design spec (on cbaldor/feat/claude-star-schema-advisor)
• Implementation plan (on cbini/docs/claude-star-schema-spec-fixes)

From #3472 — "feat: tableau-to-dbt upstream workflow tool"

What it was: The earlier iteration of this tooling — a /tableau-upstream slash command and tableau-extract-calcs.py script that extracted calculated fields from Tableau workbooks and guided analysts to move fields upstream into existing rpt_tableau__ models.

Why it was consolidated: This issue's tableau-analyze-workbook.py supersedes tableau-extract-calcs.py with viz usage tracking, LOD detection, the 4-bucket verdict system, and tests. However, the two scripts are independent implementations (zero shared commits). PR #3473 contains unique work (Tableau Server auth with HTTPS enforcement, session signout, env-var-based auth) that should be reviewed for carry-forward.

Branch (preserved for reference):

• claude/feat/tableau-upstream-tool — 14 commits, PR feat: add tableau-extract-calcs script and tableau-upstream slash command #3473 (closed). Retained until useful parts are carried into feat: add /star-schema-advisor slash command and tableau workbook parser #3537.

Unique artifacts on that branch not present in #3537:

• scripts/tableau-extract-calcs.py — Tableau Server download/auth logic (HTTPS enforcement, env-var-based auth, session signout)
• .claude/commands/tableau-upstream.md — earlier slash command workflow
• docs/superpowers/specs/2026-03-18-tableau-calc-field-categorization-design.md
• docs/superpowers/specs/2026-03-18-tableau-upstream-lineage-tracing-design.md
• docs/superpowers/plans/2026-03-18-tableau-upstream-enhancements.md

Active PRs

• feat: add /star-schema-advisor slash command and tableau workbook parser #3537 (cbaldor/feat/claude-star-schema-advisor) — implementation: slash command + tableau parser + tests
• docs: fix and extend star-schema-advisor spec #3542 (cbini/docs/claude-star-schema-spec-fixes) — spec fixes/extensions

Relationship to #3543

This issue feeds into #3543 (full star schema data mart) — the advisor tool triages extracts into mart changes.