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”.

Key features of Simple MCP MySQL Server?

List all MySQL tables in the database
Retrieve detailed schema information for all tables
Execute read-only SQL queries with error handling
Secure database access through environment variables
Simple configuration and deployment

Use cases of Simple MCP MySQL Server?

Ask Claude to list all tables in the database
Retrieve the top 10 rows from the users table
Find all orders placed in the last 30 days
Count the number of users by country
Show the schema of the products table

FAQ from Simple MCP MySQL Server

What dependencies are required?

Python 3.12.2+, uv (recommended), and a MySQL server.

What database permissions are recommended?

Use a database user with minimal

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

mcp_mysql_server

wenb1n-dev

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能；还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245