twkit
Provides integration with MySQL for building Tableau data sources from MySQL tables or Custom SQL, with safe read-only SQL execution.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@twkitbuild a sales workbook from sales.csv with a bar chart dashboard"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
twkit
An MCP server that builds, edits, checks and renders Tableau Desktop workbooks (.twbx).
Agents call its tools as mcp__twkit__*; a person opens and publishes the result.
Features
Build: data sources (CSV, Hyper extracts with related tables, MySQL tables or Custom SQL), calculated fields, parameters, worksheets (bars, lines, areas, text and measure tables, pies, treemaps, maps, dual axes), dashboards with parameter controls, filter cards, legends and actions. A dashboard can be described as a YAML spec and assembled from tested blocks.
Edit: fields, formulas, filters, sorts, table calculations, number formats, colours, zones and page layouts of existing workbooks. A person's own workbook is written only through
owner_install: snapshot first, any unlisted loss refused.Check:
preflightruns every channel at once (file format and schema, metric formulas, data dry run, empty filters, label fit, house style) and lists what it could not check.Render: every page is drawn as HTML in headless Chrome and measured for clipping, empty space, row alignment and colour, without opening Tableau.
Safe data access: SQL from a workbook or a tool runs as a single read statement.
Related MCP server: Tableau MCP Server
Install
python -m venv .venv && .venv/bin/pip install -e ".[data,view,dev]"Register the server in the MCP client (.mcp.json):
{"mcpServers": {"twkit": {"command": "/path/to/twkit/.venv/bin/twkit-mcp"}}}Configure
Connections and secrets live only in the environment or ~/.twkit/.env (copy example.env,
chmod 600); ~/.twkit/config.toml holds paths and guards and never a connection. show_config
reports what resolved, a password only as present or absent. The environment overrides the file:
what | variables (environment or |
ClickHouse (data checks, extracts) |
|
workbook database (Tableau sign-in) |
|
SQL from a workbook or a tool reaches ClickHouse only as one read: it passes a lexical check, then
ClickHouse's own parse (EXPLAIN AST, which runs nothing) of the exact statement that runs, a
subquery as Tableau runs Custom SQL, with readonly=1.
Folders protected from every write except owner_install:
[guard]
protected = ["~/Documents/My Tableau Repository/Workbooks"]
writable = ["~/Documents/My Tableau Repository/Workbooks/_ai"]Requirements
Python 3.10+; Chrome for the page renders.
Tableau Desktop only for window captures and open checks (macOS, Screen Recording permission).
Development: CLAUDE.md (also AGENTS.md).
Licence
Proprietary: all rights reserved (LICENSE). The Tableau document schemas in
vendor/tableau-document-schemas/ are Tableau's files under the Apache License 2.0
(LICENSE.txt alongside), used only to validate workbooks.
This server cannot be deployed
Maintenance
Related MCP Connectors
Build, run and publish Workbench flows, tasks, shims and knowledge bases.
551Sandbox workspace tools: search, file read, DB queries, integrations. Returns synthetic data.
- OleanderOAuthdev.oleander
The all-in-one data stack for agents. Upload files, run SQL, evolve tables, and render charts.
Search, write and run work across Compass, Workbench, Caliper, Ledger, Prism and Napkin.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceEnables AI applications to integrate with Tableau through developer primitives including tools, resources and prompts. Supports querying data from datasources, exploring content like workbooks and views, and retrieving visualizations using the Tableau REST API.15,013 npmApache 2.0
- FlicenseNot gradedqualityNot gradedmaintenanceEnables discovery, querying, and exporting of Tableau Cloud dashboards and data sources. Supports searching workbooks, filtering data, and exporting views as PDF, PNG, PowerPoint, CSV, or JSON.-
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to programmatically read, modify, and query Tableau workbook files (.twb and .twbx) on the local filesystem via 80 tools.8MIT
- AlicenseNot gradedqualityCmaintenanceA local MCP server that allows LLMs to inspect and safely edit Tableau Desktop workbooks (.twb) via XML, including creating native calculated fields using Tableau formula syntax.MIT