广告合作
MCP.so
登录

MySQL MCP Server

@wuwen1030

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

wuwen1030

关于 MySQL MCP Server

A MySQL implementation of the Model Context Protocol (MCP) server. This server allows AI models to interact with MySQL databases through a standardized interface.

MySQL MCP Server 配置

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

{
  "mcpServers": {
    "mysql": {
      "command": "node",
      "args": [
        "/ABSOLUTE/PATH/TO/PARENT/FOLDER/mysql-mcp-server/dist/index.js"
      ],
      "env": {
        "MYSQL_HOST": "",
        "MYSQL_PORT": "",
        "MYSQL_USER": "",
        "MYSQL_PASSWORD": "",
        "MYSQL_DATABASE": ""
      }
    }
  }
}

MySQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is MySQL MCP Server?

A MySQL implementation of the Model Context Protocol (MCP) server that allows AI models to interact with MySQL databases through a standardized read-only interface.

How to use MySQL MCP Server?

Install with npm install and build with npm run build, then configure the server in your Claude Desktop app's claude_desktop_config.json by providing the absolute path to the built index.js and setting environment variables for MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

Key features of MySQL MCP Server

  • List available database tables
  • Get table schemas
  • Execute read-only SQL queries
  • Safe transaction handling with automatic rollback

Use cases of MySQL MCP Server

  • Explore a MySQL database schema through an AI assistant
  • Run read-only queries to retrieve data without risk of modification
  • Enable AI models to answer questions backed by live database content

常见问题

1

What dependencies or runtime does MySQL MCP Server require?

Node.js is required. After cloning, run `npm install` and `npm run build` to compile the server.

2

How is authentication handled?

Authentication is configured via environment variables (`MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, `MYSQL_DATABASE`) passed to the server process.

3

Are write operations supported?

No. The server intentionally only supports read-only SQL queries and uses safe transaction handling with automatic rollback.

4

Where does the data live?

Data remains in the user's own MySQL database. The server does not store or persist any data externally.

5

What transport does the server use?

The server communicates over stdio, as configured in the Claude Desktop app's `claude_desktop_config.json` using the `command` and `args` fields.

评论

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

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K
广告合作