Provides tools for executing SQL queries, checking database connection status, and accessing SQL query examples to interact with MySQL databases.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type @ followed by the MCP server name and your instructions, e.g., "@MySQL MCP Server show me the first 5 rows from the customers table"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
一个基于Model Context Protocol (MCP)的MySQL服务器，允许通过MCP协议执行SQL查询。
通过MCP协议执行SQL查询
检查数据库连接状态
内置SQL查询示例提示
Related MCP server: MySQL MCP Server
# 克隆仓库
git clone https://github.com/shengshengshengbuxi/mysql_mcp_server.git
cd mysql_mcp_server
# 安装依赖
npm install
# 编译TypeScript代码
npm run build服务器使用以下环境变量进行配置：
MYSQL_HOST: MySQL主机地址（默认: localhost）
MYSQL_PORT: MySQL端口（默认: 3306）
MYSQL_USER: MySQL用户名（默认: root）
MYSQL_PASSWORD: MySQL密码（默认: 空）
MYSQL_DATABASE: MySQL数据库名（默认: 空）
# 设置MySQL连接参数
$env:MYSQL_HOST = "localhost"
$env:MYSQL_PORT = "3306"
$env:MYSQL_USER = "root"
$env:MYSQL_PASSWORD = "your_password"
$env:MYSQL_DATABASE = "your_database"
# 运行服务器
npm start要在Claude Desktop中使用此服务器，请编辑Claude Desktop配置文件：
Windows:
%USERPROFILE%\AppData\Roaming\Claude\claude_desktop_config.json添加以下配置：
{
"mcpServers": {
"mysql": {
"command": "node",
"args": [
"/path/to/mysql_mcp_server/dist/server.js",
],
"env": {
"MYSQL_HOST": "localhost",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASSWORD": "your password",
"MYSQL_DATABASE": "your database"
}
}
}
}execute_sql: 执行SQL查询
check_connection: 检查数据库连接状态
sql_example: 提供SQL查询示例
MIT
This server cannot be deployed
Connect to PlanetScale databases, branches, schema, query insights, and execute SQL
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
