PerfDog to Tableau MCP Server

# PerfDog to Tableau MCP Servers 🎮 Automate PerfDog mobile game performance data download and conversion to Tableau-ready CSV format. [](https://www.python.org/downloads/) []() ## 🚀 Features ### PerfDog Server - **Auto-login** with session persistence - **Bulk download** Excel performance data from PerfDog projects - **API integration** for case metadata - **Smart naming** `{Device}_{Case}.xlsx` ### Tableau Converter - **Summary CSV** - Device-level statistics (FPS, CPU, Memory, Jank, etc.) - **TimeSeries CSV** - Second-by-second performance metrics - **Platform detection** - Auto-detect iOS/Android from device info - **CPU normalization** - Proper CPU calculation per platform - **Package name extraction** - Include app package in filename ## 📦 Installation ### Quick Install ```bash pip install git+https://github.com/kimjeonghyun225-cpu/perfdog_MCP.git ``` ### Manual Setup 1. **Clone the repository** ```bash git clone https://github.com/kimjeonghyun225-cpu/perfdog_MCP.git cd perfdog_MCP ``` 2. **Install dependencies** ```bash pip install -r requirements.txt ``` 3. **Configure Claude Desktop** **Windows:** Edit `%APPDATA%\Claude\claude_desktop_config.json` **macOS:** Edit `~/Library/Application Support/Claude/claude_desktop_config.json` Add: ```json { "mcpServers": { "perfdog": { "command": "python", "args": ["C:/path/to/perfdog_MCP/perfdog_mcp_server.py"] }, "tableau-converter": { "command": "python", "args": ["C:/path/to/perfdog_MCP/tableau_converter_MCP.py"] } } } ``` 4. **Restart Claude Desktop** ## 💡 Usage ### With Claude Skill (Recommended) 1. **Install the Claude Skill** - Download `perfdog-tableau-converter.skill` - Upload to Claude.ai → Settings → Skills 2. **Use with Claude** ``` "Convert this PerfDog project to Tableau: https://perfdog.wetest.net/taskdata/191797/cases Output: C:\Users\me\Desktop\tableau Project name: PUBG_v3.8.0" ``` ### Direct MCP Usage Claude will automatically: 1. Ask for PerfDog credentials (first time only) 2. Request project URL, output path, and project name 3. Download all Excel files 4. Convert to Tableau CSV format 5. Report completion ## 📊 Output Files ### Summary CSV (`summary_{project}.csv`) Device-level statistics including: - Device info (Type, Product, Platform) - FPS metrics (Avg, Median, Max, 1% Low) - Stability indicators (MedRange, Std, Smooth Index) - CPU & Memory (Avg, Peak) - Jank metrics (Jank, BigJank, Drop FPS) ### TimeSeries CSV (`fps_{project}.csv`) Per-second measurements including: - FPS, CPU, Memory, GPU - Network (Recv/Send) - Temperature - Platform-specific metrics ## 🛠️ Development ### Project Structure ``` perfdog_MCP/ ├── perfdog_mcp_server.py # PerfDog downloader MCP server ├── tableau_converter_MCP.py # Tableau converter MCP server ├── requirements.txt # Python dependencies ├── README.md # This file └── perfdog-tableau-converter.skill # Claude Skill ``` ### Dependencies ``` mcp>=1.0.0 aiohttp>=3.9.0 aiofiles>=23.2.0 pandas>=2.0.0 openpyxl>=3.1.0 ``` ## 🎯 Use Cases - **QA Performance Testing** - Automate test data collection - **Version Comparisons** - Compare performance across game versions - **Dashboard Creation** - Feed data into Tableau dashboards - **Regression Analysis** - Track performance trends over time ## 🔒 Configuration Session files and logs are stored in: - **Session:** `~/.perfdog_mcp/perfdog_session.json` - **Logs:** `~/.perfdog_mcp/perfdog_downloader.log` and `tableau_converter.log` - **Downloads:** `~/Desktop/perfdog_downloads/` ## 🐛 Troubleshooting ### Login fails - Verify credentials at https://perfdog.wetest.net - Check logs in `~/.perfdog_mcp/` ### MCP server not recognized - Restart Claude Desktop completely - Verify paths in `claude_desktop_config.json` - Check Python is accessible from command line ### Path issues - Windows: Use double backslashes `C:\\Users\\...` - macOS/Linux: Use forward slashes `/Users/...` ## 📞 Support - **GitHub Issues:** https://github.com/kimjeonghyun225-cpu/perfdog_MCP/issues - **Internal:** KRAFTON Compatibility QA Team ## 📝 License Internal use - KRAFTON ## 🙏 Credits Developed by KRAFTON Compatibility QA Team for mobile game performance testing automation.