广告合作
MCP.so
登录

MySQL Database Access MCP Server

@shensiqi0701

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

shensiqi0701

关于 MySQL Database Access MCP Server

暂无概览

MySQL Database Access MCP Server 配置

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

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

MySQL Database Access MCP Server 工具

工具列表暂未提供

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

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

1

What queries are allowed?

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

2

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.

3

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.

4

Does the server modify data?

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

评论

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

Neon MCP Server

neondatabase-labs

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

MongoDB MCP Server

mongodb-js

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

1.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

广告合作