概要
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
