mcp-server-computer-study
Verified Safeby small-xiexu
Overview
An AI agent tool server implementing Model Context Protocol (MCP) to provide various functionalities for AI models, such as system information retrieval, database exports, weather queries, and CSDN article publishing.
Installation
mvn spring-boot:runEnvironment Variables
- CSDN_CA_KEY
- CSDN_CA_NONCE
- CSDN_CA_SIGNATURE
Security Notes
The server implements robust multi-layered security for database operations, including a business-layer SQL validator and a Druid SQL firewall, explicitly blocking write/DDL operations and SQL injection vectors. File path validation prevents path traversal attacks during CSV export. CSDN API authentication secrets (cookies, x-ca-* headers) are externalized to local files and environment variables, avoiding hardcoding. The `ComputerService` executes fixed system commands (`systeminfo`, `system_profiler`, `lshw`) which inherently carry environmental risks but are not directly exploitable via user input in this implementation. The default 'admin'/'admin123' credentials for the Druid monitoring page are a minor weakness, though the web server and thus the monitoring UI are disabled by default in `application.yml` for MCP server's STDIO communication model.
Similar Servers
mcp-mysql-server
Provides an MCP-compliant interface for AI models to securely interact with a MySQL database for CRUD operations, schema inspection, and performance analysis.
mysql_mcp_server
This server provides a Model Context Protocol (MCP) interface to a MySQL database, enabling AI models to execute SQL queries and retrieve database schema information.
mcp-server-study
This project implements a Spring AI-based MCP (Model Context Protocol) server, enabling AI models to interact with external systems by providing various tool capabilities like querying computer configurations, exporting database data, querying weather, and publishing CSDN articles.
mysql_mcp_server
A Model Context Protocol (MCP) server that enables AI assistants to securely interact with MySQL databases for listing tables, reading data, and executing SQL queries.