Skip to main content
Glama
shengshengshengbuxi

MySQL MCP Server

MySQL MCP Server

一个基于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集成

要在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

F
license - not found
-
quality - not tested
D
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Servers

  • F
    license
    B
    quality
    D
    maintenance
    A Model Context Protocol server that enables AI models to interact with MySQL databases through a standardized interface, providing tools for querying, executing commands, and managing database schemas.
    Last updated
    7
  • A
    license
    -
    quality
    D
    maintenance
    Enables AI assistants to interact with MySQL databases by executing SQL queries, describing table schemas, and listing tables. It provides seamless database integration for tools like Cursor through the Model Context Protocol.
    Last updated
    947
    MIT
  • F
    license
    -
    quality
    D
    maintenance
    Enables interaction with MySQL databases through the Model Context Protocol, allowing users to execute queries, manage records, and inspect table schemas.
    Last updated
  • F
    license
    -
    quality
    D
    maintenance
    A Model Context Protocol service that enables AI assistants to directly query and manage MySQL databases through natural language. It supports SQL execution, schema inspection, and atomic transactions for comprehensive database interaction.
    Last updated

View all related MCP servers

Related MCP Connectors

  • Connect to PlanetScale databases, branches, schema, query insights, and execute SQL

  • A comprehensive Model Context Protocol (MCP) server that enables AI assistants to interact with yo…

  • Run SOQL queries to explore and retrieve Salesforce data. Access accounts, contacts, opportunities…

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/shengshengshengbuxi/mysql_mcp_server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server