Dev-Assistant
Verified Safeby 8resd8
Overview
An AI-powered local server that allows an LLM to query a local MySQL database and analyze local server log files via the Model Context Protocol (MCP).
Installation
java -Dfile.encoding=UTF-8 -jar <path-to-your-project>/build/libs/resd-0.0.1-SNAPSHOT.jarSecurity Notes
The server restricts database queries to only 'SELECT' statements, which is a strong measure against data manipulation. It uses local Stdio for communication, preventing external network exposure. However, the `DatabaseMcpService` directly executes LLM-generated SQL queries via `jdbcTemplate.queryForList(sql)` without parameterized statements, making it potentially vulnerable to SQL injection if an LLM crafts a malicious 'SELECT' query (e.g., to exfiltrate data or cause performance issues). Log file analysis is limited to 50 lines, reducing potential resource exhaustion.
Similar Servers
gcloud-mcp
Enables AI assistants to interact with the Google Cloud environment using the gcloud CLI for natural language cloud management and workflow automation.
gemini-cli-desktop
A cross-platform desktop and web UI for interacting with AI models (Gemini CLI, Qwen Code, LLxprt Code) through ACP and MCP, featuring tool confirmation, code diffing, chat history, and file browsing.
code-assistant
Standardizes communication between code editors and AI coding agents, enabling autonomous code analysis and modification via command-line, GUI, or server modes.
conductor-tasks
Conductor Tasks acts as an intelligent AI-powered assistant for developers, streamlining the entire development lifecycle from task generation and planning (parsing PRDs, expanding tasks, generating implementation steps) to execution and code modification (generating diffs). It provides visual task management, integrates with various IDEs, and leverages multiple LLM providers for optimal results and cost efficiency.