Simple MCP MySQL Server

Name: Simple MCP MySQL Server
Author: alexcc4

@alexcc4

代码仓库

关于 Simple MCP MySQL Server

A lightweight MCP server for MySQL, built with python

#mysql #python #mcp-server

基本信息

分类

数据库

运行时

python

传输方式

stdio

发布者

alexcc4

配置

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

{
  "mcpServers": {
    "mcp-mysql-server-alexcc4": {
      "command": "uv",
      "args": [
        "sync"
      ]
    }
  }
}

工具

Execute read-only SQL queries and return results

概览

What is Simple MCP MySQL Server?

A lightweight Model Context Protocol (MCP) server that enables secure interaction with MySQL databases, allowing AI assistants like Claude to list tables, read data, and execute read-only SQL queries through a controlled interface.

How to use Simple MCP MySQL Server?

Clone the repository and run uv sync to install dependencies. Set the five environment variables (DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME). Start manually with uv run main.py or integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json. Then ask natural language queries like “Show me all tables” or “Top 10 rows from users table”.