Servidor de Consultas MySQL

Name: Servidor de Consultas MySQL
Author: fersoftware

@fersoftware

代码仓库

关于 Servidor de Consultas MySQL

Servidor de Consultas MySQL baseado em MCP com suporte a SSE e segurança avançada

基本信息

分类

数据库

运行时

python

传输方式

stdio

发布者

fersoftware

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mysql-mcp-server-sse-fersoftware": {
      "command": "python",
      "args": [
        "src/server.py"
      ]
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is Servidor de Consultas MySQL?

Servidor de Consultas MySQL is an MCP (Model-Context-Protocol) server built with FastMCP that enables MySQL database operations over SSE (Server-Sent Events). It provides a query interface, automatic transaction management, and a built-in SQL security mechanism with risk level control and sensitive data protection. It is intended for developers who need a secure, real‑time MySQL query server that integrates with AI assistants or other MCP‑compatible clients.

How to use Servidor de Consultas MySQL?

Install Python 3.6+, clone the repository, install dependencies (pip install -r requirements.txt), and configure the .env file with MySQL credentials and security settings. Start the server with python src/server.py — it listens by default at http://127.0.0.1:3000/sse. Use the provided test client (test_client.py) or any MCP client to connect and execute tools such as mysql_query, mysql_show_tables, or mysql_paginate_results.

Key features of Servidor de Consultas MySQL

Real‑time SSE streaming for database queries
SQL security with four risk levels (LOW to CRITICAL)
Automatic transaction commit/rollback for modifications
Sensitive information detection and masking
Metadata queries (tables, columns, indexes, foreign keys)
Environment‑aware: different behaviour in development vs. production

Use cases of Servidor de Consultas MySQL

Allow AI assistants to run safe SELECT queries against a production MySQL database
Enable interactive database exploration through MCP‑compatible chat interfaces
Provide a secured query endpoint for internal tools that need SQL access
Automate schema inspections (table structure, indexes, foreign keys) via metadata tools
Run parameterised INSERT/UPDATE/DELETE operations with enforced WHERE clauses

FAQ from Servidor de Consultas MySQL

Why does my DELETE operation fail?

DELETE without a WHERE clause is classified as CRITICAL risk. Add a WHERE condition (even WHERE 1=1) to lower the risk level, and ensure CRITICAL is included in ALLOWED_RISK_LEVELS.

Environment variables are not working?

Make sure load_dotenv() is called before any other imports in server.py. Restart the server and check the log line “Configurações de nível de risco lidas das variáveis de ambiente”.