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
go build -o ssis-analyzer.exe . && ./ssis-analyzer.exeEnvironment 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
ENScan_GO
An OSINT (Open Source Intelligence) tool for gathering comprehensive corporate information from various public data sources, primarily for security assessments (HW/SRC scenarios).
visual-tree-explorer
An MCP server for efficient codebase exploration, providing file tree visualization, symbol extraction, and dependency analysis in a single tool call.
database-ontology-mcp
Analyzes relational database schemas, generates semantic ontologies (RDF/OWL, R2RML), and provides tools for Text-to-SQL convenience, secure query execution, and data visualization.
dlt-mcp
The dlt-mcp server allows LLMs to retrieve up-to-date information about dlt pipelines, datasets, and schemas, enhancing the development experience in AI-enabled IDEs.