Simple MCP MySQL Server

@alexcc4

Repository

Basic information

About Simple MCP MySQL Server

A lightweight MCP server for MySQL, built with python

#mysql #python #mcp-server

Simple MCP MySQL Server config

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

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

Simple MCP MySQL Server tools

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

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

More Databases MCP servers

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes