logo
Login
Cover image
MySQL-MCP-Server
Public

MySQL-MCP-Server

Try Now
2025-03-17

模型上下文协议（MCP）服务器的MySQL实现。该服务器允许AI模型通过标准化接口与MySQL数据库进行交互。

3 years

Works with Finder

1

Github Watches

0

Github Forks

1

Github Stars

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.

Features

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

Installation

npm install
npm run build

Usage

Claude Desktop App

code ~/Library/Application\ Support/Claude/claude_desktop_config.json


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

Replace the env config with yours!

License

MIT

相关推荐

谷物namer gpt

谷物namer gpt

  • NiKole Maxwell

    • I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

    1.1 (271)
    商业 营销
    产品说明评估员

    产品说明评估员

  • Bora Yalcin

    • Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.

    2.8 (274)
    商业 营销
    GG33基础知识

    GG33基础知识

  • Joshua Armstrong

    • Confidential guide on numerology and astrology, based of GG33 Public information

    3.3 (103)
    最新 其他
    GPT创建者

    GPT创建者

  • https://suefel.com

    • Latest advice and best practices for custom GPT development.

    5 (391)
    最新 其他
    缩略图创建专家

    缩略图创建专家

  • Alexandru Strujac

    • Efficient thumbnail creator for YouTube videos

    3.6 (287)
    最新 其他
    技术占星术加密宇宙

    技术占星术加密宇宙

  • Callycode Limited

    • A geek-themed horoscope generator blending Bitcoin prices, tech jargon, and astrological whimsy.

    1.2 (268)
    商业 金融
    无花果到前端

    无花果到前端

  • Emmet Halm

    • Converts Figma frames into front-end code for various mobile frameworks.

    1.8 (437)
    最新 其他
    我的数字治疗师

    我的数字治疗师

  • Beniyam Berhanu

    • Therapist adept at identifying core issues and offering practical advice with images.

    4.3 (489)
    商业 卫生保健
    NAS电子邮件

    NAS电子邮件

  • Khalid kalib

    • Write professional emails

    2.9 (114)
    生产率 写作助理
    moarify

    moarify

  • lumpenspace

    • Take an adjectivised noun, and create images making it progressively more adjective!

    3.9 (244)
    最新 其他
    软件实习生

    软件实习生

  • Elijah Ng Shi Yi

    • Advanced software engineer GPT that excels through nailing the basics.

    4.7 (333)
    最新 其他
    MCP-Servers-Hub

    MCP-Servers-Hub

  • apappascs

    • 发现市场上最全面，最新的MCP服务器集合。该存储库充当集中式枢纽，提供了广泛的开源和专有MCP服务器目录，并提供功能，文档链接和贡献者。

    4 (1)
    Micropython-MCP230XX

    Micropython-MCP230XX

  • ShrimpingIt

    • MCP系列GPIO Expander的基于Micropython I2C的操作，源自ADAFRUIT_MCP230XX

    4 (1)
    prysm

    prysm

  • OffchainLabs

    • 进行以太坊的实施

    4 (1)
    1Scan

    1Scan

  • huahuayu

    • 统一的API网关，用于将多个Etherscan样区块链Explorer API与对AI助手的模型上下文协议（MCP）支持。

    2 (1)
    mbotmcp

    mbotmcp

  • deemkeen

    • 用电源组合控制您的MBOT2：MQTT+MCP+LLM

    5 (1)

    Reviews

    4 (1)
    Avatar
    user_cR9zvKHw
    2025-04-16

    I've been using mysql-mcp-server for a while now, and it's an incredible tool! Developed by wuwen1030, it significantly simplifies the management of MySQL databases. The setup process is straightforward and the documentation on the GitHub page is very helpful. I highly recommend checking it out if you're looking for a reliable MCP solution for MySQL.