Back to Apps
SSIS DTSX Analyzer
by mcprunner
Enterprise-grade analysis of SQL Server Integration Services (SSIS) packages with 80+ specialized tools for DTSX files.
0 stars
0 views
Works in:VS Code Copilot
Exposes:ToolsResources
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
Quick install
go build -o ssis-analyzer.exe .Information
- Pricing
- free
- Published
- 5/1/2026
