MCP.so
登录

MySQL MCP Server for Smithery (Python)

@aqaranewbiz

代码仓库

关于 MySQL MCP Server for Smithery (Python)

暂无概览

基本信息

分类

数据库

运行时

python

传输方式

stdio

发布者

aqaranewbiz

配置

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

{
  "mcpServers": {
    "mcp-mysql-server-aqaranewbiz": {
      "command": "node",
      "args": [
        "run.js"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is MySQL MCP Server for Smithery (Python)?

MySQL MCP Server for Smithery (Python) is a connector that lets you connect to a MySQL database directly from Smithery. It is built with Python and provides tools for listing databases, tables, describing schemas, and executing read-only SQL queries.

How to use MySQL MCP Server for Smithery (Python)?

Add the server in Smithery, then enter your MySQL credentials (host, port, user, password, optional database). Alternatively, clone the repository, install dependencies (npm install, pip install -r requirements.txt), and start with node run.js or python mcp_server.py.

Key features of MySQL MCP Server for Smithery (Python)

  • Connect to MySQL databases with configurable credentials
  • List all accessible databases
  • View all tables in a database
  • Get detailed schema information for tables
  • Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
  • Built‑in query validation blocks write operations

Use cases of MySQL MCP Server for Smithery (Python)

  • Explore the structure of a MySQL database from Smithery
  • Run read-only queries to retrieve data without risk of modification
  • Audit database schemas across multiple databases
  • Integrate database inspection into Smithery workflows

FAQ from MySQL MCP Server for Smithery (Python)

What SQL statements are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN queries are permitted. INSERT, UPDATE, DELETE, DROP, and other write commands are rejected.

What are the runtime dependencies?

Python 3 with mysql-connector-python>=8.0.0 and Node.js (for the launcher script). Missing modules are auto‑installed if possible.

How do I troubleshoot connection issues?

Verify your database credentials, ensure the MySQL server is running and accessible, and check Smithery’s console log for errors.

Can I run multiple SQL statements in one query?

No. Multiple statements separated by semicolons are not allowed for security reasons.

Does the server require authentication?

Yes, you must provide a valid MySQL username and password. The server does not implement additional authentication layers.

评论

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

Meilisearch MCP Server

meilisearch

A Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.

193

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245