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

Related MCP server: STDF MCP Server

📦 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.