Tableau数据交互服务

git clone https://github.com/samiribrh/tableau-mcp.git
cd tableau-mcp

# Install Poetry if you haven't already
curl -sSL https://install.python-poetry.org | python3 -

# Install project dependencies
poetry install

pip install mcp tableauserverclient pantab pandas python-dotenv openpyxl

# Tableau Server Configuration
TABLEAU_SERVER=https://your-tableau-server.com
TABLEAU_SITE_ID=your-site-id
TABLEAU_PAT_NAME=your-pat-name
TABLEAU_PAT_SECRET=your-pat-secret
TABLEAU_PROJECT_NAME=Sales

# Optional: Default file directory
DEFAULT_FILE_DIRECTORY=C:\Users\YourUsername\Downloads

{
  "mcpServers": {
    "tableau-mcp": {
      "command": "poetry",
      "args": [
        "run",
        "python",
        "main.py"
      ],
      "cwd": "C:\\path\\to\\tableau-mcp"
    }
  }
}

{
  "mcpServers": {
    "tableau-mcp": {
      "command": "C:\\Python313\\python.exe",
      "args": [
        "C:\\path\\to\\tableau-mcp\\main.py"
      ],
      "cwd": "C:\\path\\to\\tableau-mcp"
    }
  }
}

{
  "mcpServers": {
    "tableau-mcp": {
      "command": "poetry",
      "args": [
        "run",
        "python",
        "main.py"
      ],
      "cwd": "/path/to/tableau-mcp"
    }
  }
}

{
  "mcpServers": {
    "tableau-mcp": {
      "command": "/usr/local/bin/python3",
      "args": [
        "/path/to/tableau-mcp/main.py"
      ],
      "cwd": "/path/to/tableau-mcp"
    }
  }
}

"Convert sales_data to hyper format"
→ Finds sales_data.xlsx in Downloads and converts to sales_data.hyper

"Convert Q4_report.xlsx to hyper"
→ Converts the specific file to Hyper format

"Convert C:\Documents\data.xlsx to output.hyper"
→ Converts with custom output path

"Upload revenue.hyper to Tableau"
→ Uploads to default project (from .env)

"Upload customer_data.hyper to Marketing project"
→ Uploads to specific project

"Upload C:\Reports\sales.hyper to Sales project"
→ Upload from custom path

"Check if sales_data exists in Tableau"
→ Checks in default project

"Does customer_report exist in the Marketing project?"
→ Checks specific project

"Convert monthly_sales to hyper and upload it to the Finance project"
→ Converts Excel file and uploads in one go

tableau-mcp/
├── main.py              # MCP server entry point
├── mcp_server.py        # Tool definitions and handlers
├── tableau_api.py       # Tableau Server API interactions
├── config.py            # Configuration management
├── utils.py             # Helper utilities
├── .env                 # Environment variables (create this)
├── pyproject.toml       # Poetry dependencies
├── poetry.lock          # Locked dependencies
└── README.md            # This file

# Ensure all dependencies are installed with Poetry
poetry install

# Or add a specific package
poetry add package-name

# If using pip directly
pip install mcp tableauserverclient pantab pandas python-dotenv openpyxl

# In tableau_api.py
def your_new_function(param1, param2):
    # Implementation
    pass

# In mcp_server.py - get_tool_definitions()
Tool(
    name="your_tool",
    description="Description of what it does",
    inputSchema={
        "type": "object",
        "properties": {
            "param1": {"type": "string", "description": "..."}
        },
        "required": ["param1"]
    }
)

# In mcp_server.py - handle_tool_call()
elif name == "your_tool":
    result = _handle_your_tool(arguments)

# Test the server manually with Poetry
poetry run python main.py
# Then send a JSON-RPC request via stdin

# Test Tableau connection
poetry run python -c "from tableau_api import connect_tableau; connect_tableau()"

# Add development dependencies
poetry add --group dev pytest pytest-asyncio

# Run tests (if you create them)
poetry run pytest