广告提交登录

MySQL MCP Server for Smithery (Python)

@aqaranewbiz

基本信息

分类

数据库

传输方式

stdio

作者

aqaranewbiz

关于 MySQL MCP Server for Smithery

暂无概览

MySQL MCP Server for Smithery 配置

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

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

MySQL MCP Server for Smithery 工具

工具列表暂未提供

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

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

常见问题

1

What SQL statements are allowed?

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

2

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.

3

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.

4

Can I run multiple SQL statements in one query?

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

5

Does the server require authentication?

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

评论

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

MongoDB MCP Server

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

Sqlite

modelcontextprotocol

Model Context Protocol Servers

Postgres Mcp

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

Chroma MCP Server

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

Redis

modelcontextprotocol

Model Context Protocol Servers