PerfDog to Tableau MCP Servers

🎮 Automate PerfDog mobile game performance data download and conversion to Tableau-ready CSV format.

🚀 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

pip install git+https://github.com/kimjeonghyun225-cpu/perfdog_MCP.git

Manual Setup

1. Clone the repository

   git clone https://github.com/kimjeonghyun225-cpu/perfdog_MCP.git
   cd perfdog_MCP
   

2. Install dependencies

   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:

   {
     "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.