MySQL Database Access MCP Server

Name: MySQL Database Access MCP Server
Author: shensiqi0701

@shensiqi0701

代码仓库

关于 MySQL Database Access MCP Server

暂无概览

基本信息

分类

数据库

许可证

MIT

运行时

node

传输方式

stdio

发布者

shensiqi0701

配置

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

{
  "mcpServers": {
    "mysql-mcp-server-modification": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "@dpflucas/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

工具

未检测到工具

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

概览

What is MySQL Database Access MCP Server?

A read-only MCP server that provides tools to interact with MySQL databases, including listing databases, listing tables, describing table structures, and executing read-only SQL queries.

How to use MySQL Database Access MCP Server?

Install via npm (npm install -g @valuprosys/mysql-mcp-server), set the required environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and optionally MYSQL_DATABASE), then add the server configuration to your MCP client config under mcpServers.mysql.

Key features of MySQL Database Access MCP Server

List all accessible databases on the MySQL server
List tables within a specified database
Describe table structure including column comments
Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)

Use cases of MySQL Database Access MCP Server

Querying database metadata without writing full SQL
Exploring table schemas during development or debugging
Performing safe, read-only data lookups from an AI assistant

FAQ from MySQL Database Access MCP Server

What queries are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN statements are permitted. Other SQL statements will be rejected.

What environment variables are required?

MYSQL_HOST, MYSQL_PORT (default 3306), MYSQL_USER, and MYSQL_PASSWORD must be set. MYSQL_DATABASE (default database name) is optional.

How do I configure the server with my MCP client?

Add the following to your MCP configuration under mcpServers.mysql: command npx, args ["@valuprosys/mysql-mcp-server"], and the necessary environment variables.

Does the server modify data?

No. The server is strictly read-only and only accepts SELECT, SHOW, DESCRIBE, and EXPLAIN queries.

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

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

mcp_mysql_server

xwb602625136

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

245