mysql_to_dashboard
Create Tableau dashboards from MySQL tables automatically. Analyzes database schemas, suggests charts, generates workbooks with live connections, and outputs .twb files for data visualization.
Instructions
Build a Tableau dashboard from a MySQL table (end-to-end).
Pipeline: MySQL → schema inference → chart suggestion → workbook creation → live MySQL connection → .twb output.
Requires mysql-connector-python for schema inference.
Args: server_host: MySQL server hostname. dbname: Database name. table_name: Table to visualize. username: Database username. password: Database password (used for schema inference only; not stored in the workbook). port: Server port (default 3306). output_path: Output .twb path (defaults to _dashboard.twb). dashboard_title: Dashboard title. max_charts: Maximum charts (0 = use rules default). template_path: TWB template path. theme: Theme preset name. rules_yaml: Optional YAML string with dashboard rules overrides.
Returns: Summary of the created dashboard with file path.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| server_host | Yes | ||
| dbname | Yes | ||
| table_name | Yes | ||
| username | Yes | ||
| password | No | ||
| port | No | ||
| output_path | No | ||
| dashboard_title | No | ||
| max_charts | No | ||
| template_path | No | ||
| theme | No | ||
| rules_yaml | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |