MySQL MCP Server

@michael7736

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

michael7736

关于 MySQL MCP Server

MySQL MCP server project

#mysql #mcp #database-server

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

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

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

概览

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol (MCP) server that enables AI agents to execute SQL queries against a MySQL database. It provides tools for reading, creating, inserting, updating, and deleting data, returning results in JSON format. Designed for developers who want to connect their MCP-compatible agents (like Claude) to a MySQL database.

How to use MySQL MCP Server?

Install by cloning the repository and running npm install and npm run build. Configure the server using environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE). Then add the server to your MCP settings file (e.g., claude_desktop_config.json) with the build path and connection details. Once configured, agents can invoke tools like run_sql_query to interact with the database.

Key features of MySQL MCP Server

Execute SELECT, CREATE, INSERT, UPDATE, DELETE queries
Returns query results in JSON format
Configurable MySQL connection via environment variables
Transaction logging with unique IDs
Provides five distinct SQL tools

Use cases of MySQL MCP Server

Query and view database records through natural language conversations.
Create new tables and insert sample data via agent commands.
Update existing records, such as adjusting product prices.
Delete unwanted data, like removing a product entry.
Perform database administration tasks without writing raw SQL manually.

常见问题

What is MySQL MCP Server and what does it do?

It is an MCP server that allows AI agents to execute SQL queries against a MySQL database, supporting SELECT, CREATE, INSERT, UPDATE, and DELETE operations.

How do I configure the database connection?

Set the environment variables MYSQL_HOST, MYSQL_PORT, MYS

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

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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