mssql_to_dashboard
Convert Microsoft SQL Server tables into Tableau dashboards automatically. Analyzes database schemas, suggests visualizations, and generates .twb files with live database connections.
Instructions
Build a Tableau dashboard from a Microsoft SQL Server table (end-to-end).
Pipeline: MSSQL → schema inference → chart suggestion → workbook creation → live MSSQL connection → .twb output.
Requires pyodbc for schema inference and ODBC Driver 17 for SQL Server.
Args: server_host: MSSQL server hostname. dbname: Database name. table_name: Table to visualize. username: Database username (ignored if trusted_connection=True). password: Database password (used for schema inference only). port: Server port (default 1433). trusted_connection: Use Windows Authentication instead of SQL auth. 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 | No | ||
| password | No | ||
| port | No | ||
| trusted_connection | 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 |