Back to Home
MCPRUNNER icon

gossisMCP

by MCPRUNNER

Overview

Analyzes SSIS (SQL Server Integration Services) DTSX files, providing detailed insights into package structure, data flows, control flows, logging, performance, security, and best practices, with extensible plugin support and workflow automation.

Installation

Run Command
go build -o ssis-analyzer.exe . && ./ssis-analyzer.exe

Environment Variables

  • GOSSIS_HTTP_PORT
  • GOSSIS_PKG_DIRECTORY
  • GOSSIS_LOG_LEVEL
  • GOSSIS_LOG_FORMAT

Security Notes

The `create_analysis_rule` tool's design permits passing Go code as a string, which is then intended to be compiled and loaded as a dynamic plugin. If the `buildPlugin` function (currently a no-op in the provided code) were fully implemented, this would introduce a critical Remote Code Execution (RCE) vulnerability. Additionally, while the README mentions plugin signature verification and sandboxing, the `LoadPlugin` implementation does not visibly enforce these security measures before dynamically loading shared libraries (`.so`/.dll files). This makes the system vulnerable to malicious plugins executing arbitrary code. Path traversal attacks are explicitly tested and mitigated in file path resolution utilities, and the server includes tools to detect hardcoded credentials and sensitive data patterns within SSIS packages, rather than storing them itself.

Similar Servers

Stats

Interest Score0
Security Score3
Cost ClassMedium
Avg Tokens500
Stars0
Forks0
Last Update2025-12-08

Tags

SSISDTSXETLData AnalysisGoPluginsWorkflowsPerformance OptimizationSecurity Analysis