MCP.so
Sign In

Simple MCP MySQL Server

@alexcc4

Repository

About Simple MCP MySQL Server

A lightweight MCP server for MySQL, built with python

#mysql#python#mcp-server

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

1

Execute read-only SQL queries and return results

Overview

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

Frequently asked questions

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

Comments

Basic information

Category

Databases

Transports

stdio

Author

alexcc4

More Databases MCP servers

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

mcp_mysql_server

xwb602625136

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

245

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Elasticsearch MCP Server

elastic

685

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s