SSIS DTSX Analyzer

What it does

This comprehensive MCP server provides deep inspection and analysis of SSIS (SQL Server Integration Services) DTSX files. It transforms basic XML parsing into a powerful platform for DBAs and developers to optimize ETL workflows, detect security vulnerabilities, and validate best practices.

Tools

• parse_dtsx: Generates a structural summary of an SSIS package.
• analyze_data_flow: Inspects sources, transformations, and destinations within a data flow.
• validate_best_practices: Checks packages against industry standards and common pitfalls.
• detect_security_issues: Scans for hardcoded credentials and sensitive data exposure.
• batch_analyze: Parallel processing of multiple DTSX files with aggregated metrics.
• extract_script_code: Pulls C# or VB.NET code from Script Tasks for analysis.

Installation

Build the server using Go: go build -o ssis-analyzer.exe .

Add to your .vscode/mcp.json or Claude config:

{
  "servers": {
    "ssis-analyzer": {
      "type": "stdio",
      "command": "ssis-analyzer.exe"
    }
  }
}

Supported hosts

• Claude Desktop
• VS Code Copilot