广告合作
MCP.so
登录

Servidor de Consultas MySQL MCP Server

@fersoftware

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

fersoftware

关于 Servidor de Consultas MySQL MCP Server

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

Servidor de Consultas MySQL MCP Server 配置

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

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

Servidor de Consultas MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

1

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`.

2

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”.

3

My query was rejected by the security mechanism?

Check that the operation’s risk level is allowed in `ALLOWED_RISK_LEVELS`. For UPDATE/DELETE without WHERE, add a condition to reduce the risk.

4

Can I see sensitive information (passwords, keys) in query results?

In development mode, set `ALLOW_SENSITIVE_INFO=true`. In production, sensitive fields are always masked; this is by design for security.

5

What are the system requirements?

Python 3.6+, a running MySQL server, and the Python packages `mysql-connector-python`, `python-dotenv`, and

评论

数据库 分类下的更多 MCP 服务器

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

广告合作