Tableau Workbook Auditor

io.github.andey0Saikiran由 GitHub 帳號 andey0Saikiran 發布v1.0.1更新於 Oct 24, 2026

Local-only Tableau .twbx audit: lineage, unused fields, duplicate calcs, SQL, version diffs

已驗證STDIO僅桌面開發者工具資料與分析

概覽

AI 產生的概覽

在本機執行的 MCP 伺服器,解析 Tableau .twbx/.twb 活頁簿,為 AI 助理提供稽核、版本差異比對與欄位血緣追蹤。

可以做什麼
  • 稽核活頁簿中未使用的欄位、重複計算與效能問題
  • 對兩個版本做語意差異比對,並說明變更影響的下游欄位
  • 檢視計算欄位、參數及其相依關係,並匯出完整血緣圖
  • 列出自訂 SQL、Initial SQL 與預存程序參照及其連線
  • 列出篩選器與工作表,以及各自使用的欄位和篩選值
適用情境
適合維護 Tableau 活頁簿的情境:想讓助理說明兩個版本之間改了什麼、某個計算相依於哪些欄位、活頁簿為何變慢,或哪些欄位可能可以刪除。
執行需求
透過 npx(套件 tableau-lineage-mcp)以 stdio 在本機執行,或安裝為 Claude Desktop 擴充功能;非擴充方式需要 Node.js 18+。不需帳號、API 金鑰或網路存取。所有工具都接收本機 .twbx 或 .twb 檔案路徑。
安裝前請注意
工具結果(欄位名稱、公式、SQL 文字等)會回傳給你所選的 AI 助理,該對話受該助理的隱私政策規範。未使用欄位只是附信賴度的候選,並非可安全刪除的確定清單,刪除前請先看理由。伺服器本身不寫入磁碟、不發出網路請求。

安裝

在 SourceWeft 中

  1. 開啟 儀表板中的 Tableau Workbook Auditor,將其新增到工作區。
  2. 為需要使用其工具的對話啟用該服務。

Desktop only,透過 STDIO。 STDIO 服務會啟動本機處理程序,因此需要 SourceWeft 桌面主機。

其他 MCP 客戶端

參照 儲存庫 中的啟動說明。

README

tableau-lineage-mcp

Let your AI assistant read the lineage inside Tableau workbooks without the workbook ever leaving your machine.

An MCP server that parses local Tableau workbooks (.twbx / .twb) and exposes eleven tools to Claude, Cursor and any other MCP client: a full workbook audit (unused fields, duplicate calculations, performance findings), a semantic diff between two versions, and the complete lineage of every calculated field, parameter, filter, worksheet, dashboard and stored SQL statement.

It is the same open-source extraction engine that powers tableau-lineage.com, wrapped for AI assistants. Parsing happens in-process on your machine: no upload, no server, no account. When reading a .twbx, only the workbook XML is decompressed; the bundled data extract is never touched.

What you can ask your assistant

  • "Audit ~/Downloads/Sales.twbx. What is safe to delete?"
  • "What changed between v3 and v4 of this dashboard, and what does it break?"
  • "Which fields does [Profit Ratio] depend on?"
  • "Why is this workbook slow?"
  • "Which sheets filter on Region, and what values are selected?"
  • "Write a data dictionary for this workbook."

Install

Claude Desktop (one click, no terminal)

Download the extension and double-click it. Claude Desktop installs it for you. No Node install and no config file needed, because Claude Desktop ships its own Node.

You can also drag the .mcpb onto the Claude Desktop window, or use Settings → Extensions → Advanced settings → Install Extension.

Claude Code

bash
claude mcp add tableau-lineage -- npx -y tableau-lineage-mcp

Claude Desktop (manual, if you prefer config over the extension)

Add to claude_desktop_config.json (Settings → Developer → Edit Config):

json
{  "mcpServers": {    "tableau-lineage": {      "command": "npx",      "args": ["-y", "tableau-lineage-mcp"]    }  }}

Cursor / other MCP clients

Any client that supports stdio MCP servers works with the same command: npx -y tableau-lineage-mcp.

Requires Node.js 18+.

Tools

ToolWhat it does
audit_workbookUnused fields and parameters (graded by confidence, with reasons), duplicate calculations, and performance findings with severities and fixes
diff_workbooksSemantic diff of two versions: calculations added, removed, renamed or edited (each edit with the downstream fields it affects), plus parameters, filters, sheets, dashboards, data sources and SQL
analyze_workbookOverview: stats, data sources, calculated fields by type, parameters, raw fields
list_calculated_fieldsEvery calculation with formula, type, and direct dependencies; optional substring filter
get_fieldOne field in full detail, including everything that directly uses it
trace_dependenciesUpstream tree (down to raw columns and parameters) plus transitive downstream impact
list_parametersParameters with values, datatypes, allowed values, and which fields use them
get_lineage_graphThe complete dependency graph as nodes and edges JSON
list_sql_queriesCustom SQL (full query text), Initial SQL, stored-procedure references with parameters, and RAWSQL_* calculations, each with the connection it targets
list_filtersEvery filter, deduplicated across worksheets: field, kind, context-filter status, member selections and ranges, plus a by_worksheet breakdown
list_worksheetsEvery worksheet with the fields it uses (caption-resolved) and the filters it applies

All tools take a path to a local .twbx or .twb file. Field names are case-insensitive and brackets are optional: Profit Ratio and [profit ratio] both resolve.

Privacy Policy

Full policy: https://github.com/andey0Saikiran/tableau-lineage/blob/main/PRIVACY.md

What is collected: nothing. This server makes no network requests of any kind. It reads only the workbook paths you explicitly pass to it, parses them in memory on your machine, and returns the results to the MCP client that started it. It does not read your other files, your conversation history, or your assistant's memory, and it writes nothing to disk.

Storage and retention: none. Workbook data lives in memory for the length of the call and is discarded when the process exits. There is no server, no database and no logging.

Third parties: none. Note that the results of a tool call (field names, formulas, audit findings) are returned to the AI assistant you chose to ask, so that it can answer you; your workbook file itself is never sent anywhere. Your assistant's own privacy policy governs that conversation.

Contact: https://github.com/andey0Saikiran/tableau-lineage/issues · security reports: https://github.com/andey0Saikiran/tableau-lineage/security/advisories/new

How it works

  • The workbook is read from your local disk and parsed in the Node process. Nothing is sent anywhere.
  • Unused fields are reported as candidates with a confidence level, never as a guaranteed-safe delete list: a workbook file cannot prove a field is unreferenced everywhere. Read the reason before deleting anything.
  • For .twbx packages, only .twb XML entries are decompressed. The packaged data extract (.hyper / .tde) is skipped entirely.
  • No analytics, no telemetry, no network calls at all.

Because this package is open source, you can verify all of the above in the code.

Prefer a UI?

The same engine runs as a free web app at tableau-lineage.com: drag a .twbx in and get the audit, an interactive lineage graph, a searchable data dictionary, and a version comparison, 100% in your browser.

Development

bash
git clone https://github.com/andey0Saikiran/tableau-lineagecd tableau-lineage/mcpnpm installnpm test        # builds, then runs an end-to-end JSON-RPC smoke test

License

MIT © Sai Kiran Andey

來源:mcp/README.md,提交 35c20b6

工具

0
SourceWeft 尚未在沙箱中啟動過該軟體包,因此其工具未知。

版本歷史

1
  1. v1.0.1最新Sep 16, 2026

評分

已滿足適用檢查項的 50%

該評分衡量此收錄條目的完整程度,依據註冊中心條目、端點與公開來源計算得出。它不是對伺服器本身的評價,也不表示伺服器安全或目前可用:可連通性是帶日期的檢查結果,評分也不包含安裝量或使用者評價。

  • 近 30 天內可連通25 分

    請保持端點能夠回應 MCP 握手;SourceWeft 每 30 天探測一次。

  • 已宣告認證方式10 分

    請在註冊中心條目中宣告憑證請求標頭,或保持端點能夠回應探測,以便判定其認證方式。

  • 已列出工具15 分

    請讓伺服器在無憑證時回應 tools/list,或發布可在沙箱中無憑證啟動的軟體包。

  • 描述必需15 分
  • 圖示10 分
  • 文件15 分
  • 授權條款10 分